Identity Manager enables you to pause and resume in-progress workflows through REST APIs. This is typically useful when you want to upgrade your workflow database without losing the workflow states. The Identity Applications workflow migration utility helps you copy the workflow data from one database to another database. The migration utility is available as a zip file in the ISO files at <LINUX_ISO>/user_application/IDM_Tools/WorkflowMigrationAPI.zip and <WINDOWS_ISO/IdentityApplications/IDM_Tools/WorkflowMigrationAPI.zip. Perform the following steps to copy the migration data:
IMPORTANT:Before performing the data migration, you must stop the Roles and Resource Driver. The Roles and Resource driver should not be started until the data export and import operations are completed.
Copy the ISO file from <mountedISO>/user_application/IDM_Tools/WorkflowMigrationAPI.zip folder to /home directory and unzip the file.
To copy the data from one location to another location, you must specify the source and destination details in the silent properties file as following:
source.protocol=https source.ip=yourIP source.port=8543 source.rbpm.web.context=IDMProv source.username=cn=uaadmin,ou=sa,o=data source.password=password destination.protocol=https destination.ip=yourIP destination.port=8543 destination.rbpm.web.context=IDMProv destination.username=cn=uaadmin,ou=sa,o=data destination.password=password connection.timeout=10000000
Run the following commands to export data from their respective directories where you have unzipped the ISO files based on your Operating System:
Linux: Run the following command for Linux:
/opt/netiq/common/jre/bin/java -jar WorkflowMigrationAPI.jar -e filename.zip -f silent.properties
Windows: Run the following command for Windows:
C:\NetIQ\Common\JRE\bin\java -jar WorkflowMigrationAPI.jar -e filename.zip -f silent.properties
Create a new database for workflow engine and update the newly created workflow database details in the server.xml file.
Set com.netiq.idm.create-db-on-startup attribute to true in the ism-configuration.properties file.
Start the Tomcat server and ensure that the Workflow DB Schema has been created as part of the Tomcat startup.
Run the following commands to import the data which was exported in step 3:
Linux: Run the following command on Linux:
/opt/netiq/common/jre/bin/java -jar WorkflowMigrationAPI.jar -i filename.zip -f silent.properties
Windows: Run the following command on Windows:
C:\NetIQ\Common\JRE\bin\java -jar WorkflowMigrationAPI.jar -i filename.zip -f silent.properties
Start the Roles and Resource driver.
The following options are supported with the jar file:
-e Export to ZIP file name. Example: wf_db_migration.zip -i Import data from ZIP file name. Example: wf_db_migration.zip -sp Source Server protocol (http/https default: https) -ss Source Server IP address (default: localhost) -spo Source Server port (default: 8543) -srctx Source Server RBPM Context (default: IDMProv) -su Source Username. Example: cn=uaadmin,ou=sa,o=data -spwd Source Password -dp Destination Server protocol (http/https default: https) -ds Destination Server IP adrress(default: localhost) -dpo Destination Server port (default: 8543) -drctx Destination Server RBPM Context (default: IDMProv) -du Destination Username. Example: cn=uaadmin,ou=sa,o=data -dpwd Destination Password -f <filename> Use this option to silently copy the data. In a silent mode, the file reads the values from the silent property file. Using this option overrides the other options passed to the migration utility.
where source specifies the location from where you want to copy the migration data and destination specifies the location to which you want to copy these data. Location can be a server, File System, or a Database.
NOTE:You must specify the values for the properties for the source. If you do not specify the value for the password property in the silent properties file, the utility prompts you for the value when you run it in the command line.
Perform the following actions to copy the migration data:
Log in as a root user to the destination computer where you want to move the workflow migration.
Open a terminal session.
Specify the values for source and destination servers in the silent properties file.
Run the migration utility by entering the following command:
java -jar WorkflowMigrationAPI.jar [-option1] [value1]....[-optionN] [valueN]
Example 1: java -jar WorkflowMigrationAPI.jar -e wf_db_migration.zip -f silent.properties
This command copies all workflow migration data into the wf_db_migration.zip file. This option is useful when you want to save the exported settings.
Example 2: java -jar WorkflowMigrationAPI.jar -i wf_db_migration.zip -f silent.properties
This command imports all workflow migration data from the wf_db_migration.zip file to the destination server by reading the values provided in the silent properties file.
Example 3: java -jar WorkflowMigrationAPI.jar -e wf_db_migration.zip -sp http -ss localhost -spo 8543 -srctx IDMProv -su cn=uaadmin,ou=sa,o=data -spwd password
This command exports all workflow migration data from the server whose details are provided in the command prompt. This option is useful when you want to save the exported settings.
Example 4: java -jar WorkflowMigrationAPI.jar -i wf_db_migration.zip -dp http -ds localhost -dpo 8543 -drctx IDMProv -du cn=uaadmin,ou=sa,o=data -dpwd password
This command copies all client settings stored in the wf_db_migration.zip file to the destination server whose details are provided in the command prompt.