Migrating your JTX 3.x System

This topic applies to ArcEditor and ArcInfo only.

About migrating your Workflow Manager database

To upgrade an existing JTX 3.0.1 Database, use the Workflow Manager Post Installation tool. The tool will detect if the database already has a Workflow Manager schema installed in it and, if it does, will update it.

Database connection management

At previous versions of Workflow Manager, the connection information for the Workflow Manager Repository and spatial data workspace were managed in the JTX_CONN_INFO table. Now, this information is managed in the JTX_DATABASES table. If you were taking advantage of keeping your connection information stored separately from the rest of the repository, you will need to move this table now.

This change has two impacts on how the connection properties are configured for Workflow Manager.

  1. After upgrading a 3.x database, you will need to reconfigure your Workflow Manager database connection in the Workflow Manager Administrator or ArcCatalog or take advantage of the option at the end of the postinstallation.
  2. The spatial data workspace connections are managed differently. These are called Data Workspace connections and are not configured as part of the Workflow Manager Database wizard anymore. One benefit of this is that you now have the ability to connect to spatial data that is stored in many different ArcSDE geodatabases. See the adding data workspace connection topic in the Configuring Workflow Manager book for more on creating spatial data connections.

New privileges

With the new functionality added at Workflow Manager, new privileges to control access have been added. When upgrading existing JTX 3.x databases, these privileges will be added to the configuration but not associated with any groups. You'll need to add the privileges to the groups that should be able to perform the action. These privileges are

  • DeleteJobs
  • ManageDataWorkspace
  • CanChangeJobOwner

Custom steps

One of the main things you will notice when you begin to build workflows with Workflow Manager are the changes that have been made to the step type execution. Three new execution types have been added:

  • Open File: Opens the file you define. The file is stored in the database, so there's no need to worry about the correct file path. This is also handy for workflows that will be executed from the Web.
  • Launch URL: Launches a Web browser pointing to the URL you've configured.
  • Ask Question: Asks the question you've configured. This execution type supercedes the previous custom steps that asked a question (Workflow ManagerCustomSteps.AskUser and Workflow ManagerCustomSteps.AskQuestion).

Also, the previous custom step library, Workflow ManagerCustomSteps, has been upgraded. Although the old steps can still be run on Workflow Manager, it's recommended that you upgrade to new steps provided with Workflow Manager. If you have developed custom steps for your organization, it is recommended that you upgrade to use the new interface, IJTXCustomStep, from the old, IJTXCustomExecute.

How to update to the latest schema

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

    The Workflow Manager Post-Installation wizard appears.

    Connection Info
    Step One: Enter the connection information for an existing JTX 3.x repository.
  2. Enter the connection information for an existing 3.x repository.
  3. Click Next.

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

  4. Select the configuration keyword used to store the repository.
    Configuration Keyword
    Step Two: Choose the configuration keyword for the repository in the geodatabase.
  5. Click Next.
  6. Choose whether you would like to add a new Workflow Manager Database connection to this repository when the upgrade is complete.
    Workflow Manager DB Connection
    Step Three: 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 the postinstallation was successful or not.

  8. Choose whether you would like to view the log.
    View Log
    Finally, a screen will show the success of the upgrade and offer you a chance to view a log of the process.
  9. Click Close.

Published 6/7/2010