Workflow Error post Activation

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

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 14.x

Cause

During the CA Identity Manager startup, the Workflow database was not populated 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 scripts "wp_dropfk.sql", "wp_droppk.sql", and "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 scripts under: 

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

 

Note: DBA must run the script with the 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.