Upgrade Workflow Database (Workflow Manager)

Available with Workflow Manager license.

Summary

Upgrades an existing Workflow Manager (Classic) database with the latest schema and configuration. The Workflow Manager (Classic) 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 (Classic) databases created with version 10.2.x or earlier, a group named Administrator is created with the AdministratorAccess privilege. The user running the tool is added to the Administrator group, which grants the user administrator access. Administrator access means the current user can connect to the selected database through ArcGIS Workflow Manager (Classic) Administrator to make edits to components of your system. The existing Workflow Manager (Classic) system settings are preserved during the upgrade.

Note:

The Workflow Manager (Classic) system tables are geodatabase tables and are registered with your enterprise geodatabase. It is recommended that you do not delete or modify these tables using your database tools.

Usage

• When upgrading a Workflow Manager (Classic) 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.

  Note:

  The Update, Insert, Select, and Delete privileges are equivalent to those granted to the data creator user. These database-level permissions should be assigned by your database administrator for the Workflow Manager (Classic) database.

• 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 Store parameter defines the user store from which the user and role information is imported. When Portal is chosen, the users are retrieved from an existing portal and added to the Workflow Manager (Classic) repository. When Traditional is chosen, the users and group roles are defined by the administrator in ArcGIS Workflow Manager (Classic) Administrator. These roles can be imported from an Active Directory or created manually.

  Note:

  To import the user store information using the Portal option, you must be signed in to the portal.

Parameters

Dialog

Label	Explanation	Data Type
Input Database Connection	The location of the enterprise geodatabase connection file to the Workflow Manager (Classic) database, which contains Workflow Manager (Classic) 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)	Specifies the user store from which the users and roles will be retrieved. The users can be imported from a portal and are assigned to roles created in the Workflow Manager (Classic) repository. The portal user profile information cannot be edited using ArcGIS Workflow Manager (Classic) Administrator. The users and roles can be created in the Workflow Manager (Classic) repository using the Traditional option. When using the Traditional option, the users and roles can be imported from the Active Directory in ArcGIS Workflow Manager (Classic) Administrator. 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 (Classic) repository using ArcGIS Workflow Manager (Classic) Administrator. Users and roles can be imported from the Active Directory when this option is used. This is the default.	String

Derived Output

Label	Explanation	Data Type
Output Database Path (.jtc)	The output database file (.jtc) with Workflow Manager (Classic) schema. The .jtc file is stored in the Project folder.	File

Python

arcpy.wmx.UpgradeWorkflowDatabase(Input_Database_Connection, {User_Store})

Name	Explanation	Data Type
Input_Database_Connection	The location of the enterprise geodatabase connection file to the Workflow Manager (Classic) database, which contains Workflow Manager (Classic) 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)	Specifies the user store from which the users and roles will be retrieved. The users can be imported from a portal and are assigned to roles created in the Workflow Manager (Classic) repository. The portal user profile information cannot be edited using ArcGIS Workflow Manager (Classic) Administrator. The users and roles can be created in the Workflow Manager (Classic) repository using the Traditional option. When using the Traditional option, the users and roles may be imported from the Active Directory in ArcGIS Workflow Manager (Classic) Administrator. 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 (Classic) repository using ArcGIS Workflow Manager (Classic) Administrator. Users and roles can be imported from the Active Directory when this option is used. This is the default.	String

Derived Output

Name	Explanation	Data Type
Output_DatabasePath	The output database file (.jtc) with Workflow Manager (Classic) schema. The .jtc file is stored in the Project folder.	File

Code sample

UpgradeWorkflowDatabase example 1 (stand-alone script)

This script upgrades an existing Workflow Manager (Classic) database to ArcGIS Pro schema, and the user store is set up in ArcGIS Workflow Manager (Classic) 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 example 2 (stand-alone script)

This script upgrades an existing Workflow Manager (Classic) database to ArcGIS Pro schema, and the user store is imported from the portal you are currently signed in to. The database configuration keyword WMX is used.

# 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

Output CONFIG Keyword

Licensing information

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