Workflow Error post Activation

Document ID : KB000006481
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After enabling Workflow in CA Identity Manager we have the following error message in Application Server:

 

16:07:47,259 ERROR [com.workpoint.server.pojo.UniqueIDUpdatePvtBean] (http-/0.0.0.0:8080-8) getNextTableIDSql() cannot find row in WP_INI table for SECTION_NAME='Database' and KEY_NAME='ID', so cannot construct TableID. 

16:07:47,259 ERROR [com.workpoint.server.UniqueIDMap] (http-/0.0.0.0:8080-8) Exception caught while obtaining a new ID: java.lang.NullPointerException 

at com.workpoint.server.UniqueIDMap.getNewCache(Unknown Source) [iam_im_wpServer.jar:] 

at com.workpoint.server.UniqueIDMap.verifyID(Unknown Source) [iam_im_wpServer.jar:] 

at com.workpoint.server.recordset.Script.save(Unknown Source) [iam_im_wpServer.jar:] 

Environment:
CA Identity Manager 12.x
Cause:

During CA Identity Manager startup, the Workflow database was not populate correctly

Resolution:

1. Stop CA Identity Manager (IdM) service ( JBoss/WildFly, Websphere or Weblogic)

2. Backup your IdM database ( Oracle or SQL Server) 

3. Run the "wp_drop_tables.sql" script to drop all Workpoint tables 

4. Start IdM service which will re-create all WP tables and populate them. 

 

About step 3, you can find the "wp_drop_tables.sql" script under: 

X:\...\IAM Suite\Identity Manager\tools\Workpoint\database\

 

Note: DBA must run script with user with DROP permission 

Additional Information:

Note: If you are using Workflow already, and you have data and jobs pending of approval/rejection, these steps will delete all data and jobs pending approval/rejection.