Upgrading an existing Workflow Manager system

Available with Standard or Advanced license.

Available with Workflow Manager license.

Migration of your Workflow Manager database

To upgrade an existing Workflow Manager database, use the Workflow Manager Upgrade Workflow Database geoprocessing tool or combination of the geoprocessing tool along with the Post Installation tool for a Workflow Manager 10.0 repository. The tool will detect if the database already has an older Workflow Manager schema and upgrade it. The following sections describe upgrading various versions of the Workflow Manager database to the latest schema.

Upgrading a 10.1 or later repository

Existing Workflow Manager 10.1 or later repositories need to be upgraded using the the Upgrade Workflow Database geoprocessing tool. The tool will make the following changes to the database:

• Add new table and fields
• Remove legacy tables
• Import new privileges
• Import new status types
• Import new activity types
• Import new system settings
• Import new priority
• Import new hold types
• Add the current user to the Administrator group

Upgrading a 10.0 repository

Existing Workflow Manager 10.0 databases must be upgraded to 10.1, 10.2, 10.2.1, 10.3, or 10.3.1 using the specific postinstallation utility. After the postinstallation utility has upgraded the repository, the repository must be further upgraded using the Upgrade Workflow Database geoprocessing tool.

1. From the Start menu, click ArcGIS Workflow Manager > Workflow Manager Post Installation.

   The ArcGIS Workflow Manager Post-Installation wizard appears.

   

   Enter the connection information for an existing repository

2. Enter the connection information for an existing repository.
3. Click Next.

   Workflow Manager automatically detects that a repository already exists in the geodatabase.

4. Choose the configuration keyword used to store the repository.

   

   Choose the configuration keyword for the repository in the geodatabase.

5. Click Next.
6. Optionally choose to add a new Workflow Manager database connection to this repository when the upgrade is complete.

   Note:

   The following characters cannot be used in the connection alias and repository name: \ / : * ? < > | ".

   

   Choose to create a new Workflow Manager database connection for the upgrade repository

7. Click Finish.

   The final page in the wizard appears, indicating whether or not the postinstallation was successful.

8. Optionally choose to view the log.

   

   A screen shows the success of the upgrade and offers you a chance to view a log of the process.

9. Click Close.

Note:

The MinimumConfig.jxl file contains updated configuration elements. You can import this in the Administrator after running the postinstallation to merge the latest contents with your existing repository. For more information, see Merging configuration files.

New privileges

With the new functionality added in Workflow Manager, new privileges to control access have also been added. When upgrading existing Workflow Manager databases, these privileges are included as part of the sample configuration files, Minimum Configuration and Quick Start Configuration. The privileges added at various versions are listed in the following subsections.

Note:

Privileges were not added at 10.2.x.

Privileges added at 10.3.x

• AdministratorAccess
• CanTakeJobsOffline
• OfflineJobOverride

Privileges added at 10.1

• CanRecreateWorkflow
• CanReopenClosedJobs
• CanSubscribeToNotifications
• CanUpdateUserProfile
• ExportJobs