Facing issue while saving workpoint designer workflow

Products

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

Issue/Introduction

I have created a custom script in agents tab of workflow and when I try to add it to synchronous event and save the workflow. I am facing below issue. I tried to add other script even I am facing the same issue with key value.

 

04:32:34,456 ERROR [com.workpoint.server.pojo.GenericServerBean] (EJB default - 3) Violation of PRIMARY KEY constraint 'pk_wp_act_script'. Cannot insert duplicate key in object 'dbo.WP_ACT_SCRIPT'. The duplicate key value is (78, WPDS).

 SQL = Execute Batch: INSERT INTO WP_ACT_SCRIPT (ACT_SCRIPT_ID, ACT_SCRIPT_DB, ACT_ID, ACT_DB, WORK_STATE_ID, SCRIPT_ID, SCRIPT_DB, SCRIPT_TYPE_ID, SCRIPT_ASYNC, ROW_VERSION, LU_ID, LU_DATE, SORT_ORDER, MAX_AGENT_EXECUTIONS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Batch Item 1: 78,'WPDS',41,'WPDS',3,351,'WPDS',3,0,1, 'root',2019-11-07 04:32:34.489,0,0

04:32:34,457 ERROR [org.jboss.as.ejb3.invocation] (EJB default - 3) JBAS014134: EJB Invocation failed on component ProcessUpdatePvt_EJB for method public abstract com.workpoint.common.data.ProcessData com.workpoint.server.pojo.ProcessUpdatePvt.save(java.lang.String,java.lang.String,com.workpoint.common.data.ProcessData,int) throws com.workpoint.server.ejb.WorkPointEJBException: com.workpoint.server.ejb.WorkPointEJBException: A duplicate key violation has occurred

        at com.workpoint.server.pojo.GenericServerBean.createException(Unknown Source) [iam_im_wpServer.jar:]

        at com.workpoint.server.pojo.GenericServerBean.createException(Unknown Source) [iam_im_wpServer.jar:]

        at com.workpoint.server.pojo.ProcessUpdatePvtBean.save(Unknown Source) [iam_im_wpServer.jar:]

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_152]

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_152]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_152]

Environment

Release : 14.2

Component : IdentityMinder(Identity Manager)

Resolution

Steps to resolve:

• Edit /admin_tools/Workpoint/bin/IdCheck.bat .
• Based on the Workflow database type, update the database CLASSPATH with the appropriate JDBC driver.
• Run Idcheck.bat and connect to Workflow database
• Analyze and Fix the key violations if any.

You will then be able to import/save workflow process from workpoint designer Wizard.