Process Framework Database Upgrade

Use the Database Upgrade tool ONLY if you have a previous version of Process Framework. If you are installing Process Framework for the first time, you will NOT need this tool. The Database Upgrade tool must be run on a machine with ArcGIS and ArcFM installed. It cannot be run with just the standalone version of Workflow Manager installed.

If you have installed a previous version of Process Framework, the Process Framework Database Upgrade tool will update your database with enhancements available in the latest version. Select Process Framework Database Upgrader from Start menu | ArcFM Solution | Process Framework | Administration. This tool is also available here: Program Files (x86)\Miner and Miner\ArcFM Solution\Bin\PxDatabaseUpdater.exe. Log in to the database you wish to upgrade.

The ArcFM Solution supports two types of login authentication: database and operating system. Database authentication requires the user to enter their user name and password when logging into an ArcFM application. Operating system authentication uses the user's Windows login name and password. If you wish to use operating system authentication, your Windows user name and password must be valid for the selected Process Framework database. Authentication does not impact Access geodatabases.

Select a task from the Available Upgrade Tasks list and click the Execute Task button.

NOTE: If you use a stand-alone Process Framework database, which is not part of your geodatabase, click Cancel in the SDE Database Connection window each time it appears.

After you’ve executed this task, additional tasks will be added to the Available Upgrade Tasks list if upgrades are necessary for the version to which you are upgrading. Refer to the "What's New" page for your current ArcFM version for information on the necessary Process Framework upgrade tasks specific to that version. The following tasks are always available in the list:

Upgrade Task

When to Execute

Create Table Indices

Execute after tables have been added to database.

Process Framework Tables: ArcFMSystemTable Model Name

Execute this script after Process Framework tables have been added.

Session Manager Tables: ArcFMSystemTable Model Name

Execute this script after Session Manager tables have been added.

Workflow Manager Tables: ArcFMSystemTable Model Name

Execute this script after Workflow Manager tables have been added.

The last three upgrade tasks listed above (ArcFM System Model Name) will display an ArcCatalog login form when they are executed. Log into SDE as a user who has permissions for the following:

  • View the Process Framework, Session Manager and Workflow Manager tables

  • Update model names on these tables

Select the task you wish to perform and click Execute Task. The Messages window lists the upgrades that were performed and whether they were successful. Click Close to dismiss the tool. Once executed, the tasks may not be reversed.

You may also need to update your Session Manager or Workflow Manager tasks, transitions, roles, states, etc.

If the upgrade tool adds a new table to your database, your Database Administrator must update the read/write permissions. The table below indicates whether the upgrade tool adds new tables to the database. The table does not list all of the tasks performed, only whether tables are added. "None" does NOT mean the upgrade task does nothing.

Release

Upgrade Task

Tables Added

10.2

No upgrade tasks

 none

10.1.1

No upgrade tasks

 none

10.1

No upgrade tasks

 none

10.0.3 SP1

No upgrade tasks

 none

10.0.3

No upgrade tasks

 none

10.0.2

No upgrade tasks

 none

10.0.1 SP1

No upgrade tasks

 none

10.0.1

No upgrade tasks

 none

9.3.1 SP1

No upgrade tasks

none

9.3.1

Workflow Manager

MM_WMS_DESIGN_PRODUCT_TYPE

9.3 Rev2

Process Framework

none

9.3 Rev2

Process Framework Mobile

MM_MOBILE_PACKET_ADAPTERS

9.3 Rev2

Session Manager

none

9.3 Rev2

Workflow Manager

MM_WMS_DESIGN_PRODUCT_TYPE

9.3 SP1

No upgrade tasks

none

9.3

Process Framework

none

9.2.1

Session Manager

none

9.2

Process Framework

MM_PX_MESSAGING_ROLE
MM_PX_MESSAGING (This table must be readable by all Process Framework users.)

9.1.2 SP1

No upgrade tasks

none

9.1.2

Process Framework

none

9.1.2

Session Manager

none

9.1 SP1

Process Framework

none

9.1

Process Framework

MM_PX_HISTORY
MM_PX_SUBTASKS_PARAMETERS
MM_MOBILE_DB_VERSION
MM_MOBILE_STATE

9.0.1 SP1

Process Framework

none

9.0.1 SP1

Workflow Manager

none

9.0.1

Process Framework

none

9.0.1

Session Manager

MM_SESSION_TYPE

9.0.1

Workflow Manager

MM_WMS_DESIGN_TYPE

9.0.1

Process Framework Mobile

MM_MOBILE_STORED_DISPLAY

Note for Users Upgrading from 8.3.2 or earlier: When executing the Process Framework 9.0.1 upgrade script, you may encounter an error similar to the following:

Initializing Table: MM_PX_TRANSITION
Transition "SessionApprove" has no "To" state so a default node type could not be set. 
It will be set to <NONE>. -- OK.

This error occurs because the upgrade script cannot determine a node type if there is no "to" state. The "to" state is missing because the "Approve Session" transition is obsolete. To correct the error, unassign the defunct "Approve Session" transition using the Process Framework Administration tool.

QR code for this page

Was this helpful?