ArcMap

Upgrade Workflow Database

Available with Workflow Manager license.

Summary

The Upgrade Workflow Database tool upgrades an existing Workflow Manager database with the latest schema and configuration. The Workflow Manager Database is used to store the job and configuration information for your work management system and one feature class that is used to store the geometries for the Location of Interest (LOI) for your jobs.

In Workflow Manager databases created with earlier version than 10.3, a group named Administrator is created with AdministratorAccess privilege. The user running the tool is added to the Administrator group which grants the user administrator access. For more information about Privileges, see Privileges. Administrator access means that the current user can connect to the selected database through the Workflow Manager Administrator to make edits to components of your system. The existing Workflow Manager system setting are preserved during the upgrade.

Usage

  • When upgrading a Workflow Manager Database, an owner user account with privileges—including Update, Insert, Select, and Delete—is required, and a direct connection file (.sde) to the enterprise database must be used.

  • The Upgrade Workflow Database tool updates system tables, adding new fields and tables that are part of the new schema. The following configuration elements are also updated.

    • Privileges
    • Groups
    • Status Types
    • Activity Types
    • Notification Types
    • Settings
    • Priorities
    • Holds

  • The User Storeparameter defines from which user store the user and role information is imported. You have two choices to get the information: Portal and Traditional. When Portal is selected, the users are retrieved from an existing Portal and added to the Workflow Manager repository. When Traditional is selected, the users and group roles are defined by the Administrator in the Workflow Manager Administrator. These roles may be imported from an Active Directory or created manually.

Syntax

UpgradeWorkflowDatabase_wmx (Input_Database_Connection, {User_Store})
ParameterExplanationData Type
Input_Database_Connection

The location of the enterprise geodatabase connection file to Workflow Manager database, which contains Workflow Manager system tables. The connection file must connect directly to the database, and the connection should be made as a database owner.

Workspace
User_Store
(Optional)

The user store from which to retrieve the users and roles. The users can be imported from a Portal and are assigned to roles created in Workflow Manager repository. The Portal user profile information cannot be edited using Workflow Manager Administrator. The users and roles can be created in Workflow Manager repository using the Traditional option. When using the Traditional option, the users and roles may be imported from the Active Directory in Workflow Manager Administrator.

If no option is selected Traditional is used by default.

  • PORTAL —The users will be imported from the Portal you are currently signed in to.
  • TRADITIONAL —The users and roles will be created in the Workflow Manager repository using Workflow Manager Administrator. Users and roles can be imported from the Active Directory when this option is used.
String

Code sample

UpgradeWorkflowDatabase - Traditional user store

This script upgrades an existing Workflow Manager database to the latest schema, and the user store is set up in the Workflow Manager Administrator. Since no database configuration keyword is specified, DEFAULTS will be used by the tool.

# Import arcpy module
import arcpy

# Local variables:
Input_Database_Connection = r'C:\wmxrepository.sde'
User_Store = 'Traditional'

# Process: Upgrade Workflow Database
arcpy.UpgradeWorkflowDatabase_wmx(Input_Database_Connection, "", User_Store)
UpgradeWorkflowDatabase - Portal user store

This script upgrades an existing Workflow Manager database to ArcGIS Pro schema, and the user store is imported from a Portal you are currently signed in to. The database configuration keyword WMX is utilized.

# Import arcpy module
import arcpy

# Local variables:
Input_Database_Connection = r'C:\wmxrepository.sde'
Config_keyword = 'WMX'
User_Store = 'Portal'

# Process: Upgrade Workflow Database
arcpy.UpgradeWorkflowDatabase_wmx(Input_Database_Connection, Config_keyword, User_Store)

Environments

Licensing information

  • ArcGIS Desktop Basic: No
  • ArcGIS Desktop Standard: Requires Workflow Manager
  • ArcGIS Desktop Advanced: Requires Workflow Manager

Related topics