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]
Release : 14.2
Component : IdentityMinder(Identity Manager)