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\Miner and Miner\ArcFM Solution\Bin\PxDatabaseUpdater.exe. Login 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.

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 *in addition to the indices created with this tool, you should also create these recommended indices to improve performance	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.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.