Upgrade Guide › WebLogic Version › Upgrade on a Single WebLogic Node › How to Migrate a Single Node Installation to WebLogic 11 › Upgrade the Workflow Database

Upgrade the Workflow Database

This procedure applies only if you are upgrading from CA Identity Manager r12.

As of CA Identity Manager r12.5, an updated version of WorkPoint Workflow was added to the installation. Update the workflow database to work with WorkPoint 3.4.2, so you can continue to use the workflow processes that you developed in WorkPoint 3.3.

To upgrade to WorkPoint 3.4.2

1. Locate the WorkPoint scripts in the Workpoint\database under the Administrative Tools folder. The scripts are in the following default locations:
   • Windows: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\Workpoint\database
   • UNIX: /opt/CA/IdentityManager/IAM_Suite/Identity_Manager/tools/Workpoint/database
2. Run the wp331_to_wp34_cnv_step1.sql script to create the new tables for Workpoint 3.4 and to add the new columns to the end of old tables.

   This script also inserts rows into the WP_*_TYPE tables as needed.

3. Run the wp331_to_wp34_cnv_step2.sql script to create the stored procedures required to convert the data.
4. Run the wp331_to_wp34_cnv_step3.sql script to convert the text data to the new columns.

   This script also populates the new WP_BULK_DATA table from the old WP_BULK_STORAGE table.

5. Run the wp34_20060927_add.sql script to create the new tables for Workpoint 3.4.20060927.

   This script also inserts rows into the WP_INI and WP_*_TYPE tables as needed.

6. Run the wp34_20070625_add.sql script to create the new tables for Workpoint 3.4.2.20070625. This also inserts rows into the WP_INI and WP_*_TYPE tables as needed.
7. Run the wp342_20071218_add.sql script to create the new tables for Workpoint 3.4.2.20071218.

   This script also inserts rows into the WP_INI and WP_*_TYPE tables as needed.

8. Save all changes to the database.