In some scenarios the CA Identity Management workflow may produce a duplicate key violation (example below). CA provides a utility (IdCheck) to analyze and correct these data integrity issues.
2019-01-11 13:05:09,900 [main] INFO com.workpoint.gui.designer.Designer - PRODUCT = Workpoint; VERSION = 3.5.2; BUILD = 20140214.P004; BUILD DATE = 20 June 2015 2019-01-11 13:05:31,998 [AWT-EventQueue-0] ERROR com.workpoint.gui.common.ErrorDialog - Unable to generate script 'Temporary Get Resource Titles Script'. Exception returned from the HTTPPostMessage send. Error code = 1 Error message = ScriptUpdatePvt.save() returned java.sql.SQLException. Error message = A duplicate key violation has occurred 2019-01-11 13:05:31,998 [AWT-EventQueue-0] ERROR com.workpoint.gui.common.ErrorDialog - java.sql.SQLException: A duplicate key violation has occurred at com.workpoint.server.recordset.SmartStatement.executeBatch(Unknown Source) at com.workpoint.server.recordset.RecordSet.executeBatch(Unknown Source) at com.workpoint.server.recordset.WP_SCRIPT_LINE.insert(Unknown Source) at com.workpoint.server.recordset.Script.saveChildren(Unknown Source) at com.workpoint.server.recordset.Script.save(Unknown Source) at com.workpoint.server.pojo.ScriptUpdatePvtBean.save(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
The IdCheck process is used to recalculate all the NEXT_IDs in WP_ID_GEN table which tracks unique IDs. It ships as standard with CA Identity Manager including the Virtual Appliance (vAPP) and can be found in the folder
CA Identity Management Suite 14.x