Question
Last activity: 22 Nov 2018 5:07 EST
Error saving Data-Agent-Queue instance for: Pega-ProCom
Hi All,
I am getting below Exception:
Error saving Data-Agent-Queue instance for: Pega-ProCom on node 840e9bbc17ce4dabd327d6e815450f36 com.pega.pegarules.pub.database.DuplicateKeyException: Database-Saver-UpdateInsertfail Index-Reference 1 23000 ORA-00001: unique constraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated DatabaseException caused by prior exception: com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated | SQL Code: 1 | SQL State: 23000 DatabaseException caused by prior exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated
Errorcode1:java.sql.SQLIntegrityConstraintViolationException:ORA-00001:uniqueconstraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated<CR><CR> atcom.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:293)<CR>
Can anyone help as what is the cause of this exception and what might be the resolution.
Log States as follows:
2018-11-2007:36:03,967GMT*8*EXCP0001*0*0*9c3fbe0f16067ca5aa741fb53a02ae1e*shared*shared*BAADC64B9135B65F6D66A745802F41D43*none*blank*COE-CAP:05.99.01*17b9c327b01b5ce3743e0fa5c2f26836*N*260*A0D43A82A1F9AB110DF983F0A4961CDD3*7584*WorkManager.PRPCWorkManager:474*STANDARD*com.pega.pegarules.session.internal.async.AgentRuleUtils*NA*(MasterForNewAgents)*Rule-Declare-DecisionTable**NA****NA*NA*NA*NA*NA*NA*NA*NA*[MSG][ErrorsavingData-Agent-Queueinstancefor:Pega-ProComonnode9c3fbe0f16067ca5aa741fb53a02ae1e][STACK][com.pega.pegarules.pub.database.DuplicateKeyException:Database-Saver-UpdateInsertfailIndex-Reference123000ORA-00001:uniqueconstraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated<CR><CR>DatabaseExceptioncausedbypriorexception:com.ibm.websphere.ce.cm.DuplicateKeyException:ORA-00001:uniqueconstraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated<CR><CR> | SQLCode:1 | SQLState:23000<CR><CR>DatabaseExceptioncausedbypriorexception:java.sql.SQLIntegrityConstraintViolationException:ORA-00001:uniqueconstraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated<CR><CR> | SQLCode:1 | SQLState:23000<CR><CR>From: (BAADC64B9135B65F6D66A745802F41D43:(MasterForNewAgents)) <CR> SQL:INSERTINTOPEGA_RULES_1.pr_index_reference (pzInsKey , pzTenantId , pxCommitDateTime , "PXCREATEDATETIME" , "PXCREATEOPERATOR" , "PXCREATEOPNAME" , "PXCREATESYSTEMID" , "PXINDEXCOUNT" , "PXINDEXPURPOSE" , "PXINSINDEXEDCLASS" , "PXINSINDEXEDKEY" , "PXINSNAME" , "PXJAVACLASS" , "PXJAVAMETHODNAME" , "PXOBJCLASS" , "PXPAGENAME" , "PXREFERENCINGDESCRIPTION" , "PXREFERENCINGINSNAME" , "PXREFERENCINGRULESETNAME" , "PXREFERENCINGRULESETVERSION" , "PXRULECLASSNAME" , "PXRULEFAMILYNAME" , "PXRULEOBJCLASS" , "PXSAVEDATETIME" , "PXUPDATEDATETIME" , "PXUPDATEOPERATOR" , "PXUPDATEOPNAME" , "PXUPDATESYSTEMID" , "PYLABEL" , "PYRULENAME") VALUES (? , COALESCE((SELECTMAX(pzTenantId) FROMPEGA_RULES_1.pr_index_referenceWHEREPZINSKEY= ? GROUPBY (PZINSKEY)), 'shared') , CURRENT_TIMESTAMP , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)<CR> SQLInserts: <INDEX-REFERENCEDATA-AGENT-QUEUEPEGA-PROCOM!9C3FBE0F16067CA5AA741FB53A02AE1E!26!RULEREFERENCE> <INDEX-REFERENCEDATA-AGENT-QUEUEPEGA-PROCOM!9C3FBE0F16067CA5AA741FB53A02AE1E!26!RULEREFERENCE> <<null>> <<null>> <<null>> <<null>> <26> <RuleReference> <Data-Agent-Queue> <DATA-AGENT-QUEUEPEGA-PROCOM!9C3FBE0F16067CA5AA741FB53A02AE1E> <DATA-AGENT-QUEUEPEGA-PROCOM!9C3FBE0F16067CA5AA741FB53A02AE1E!26!RULEREFERENCE> <<null>> <<null>> <Index-Reference> <<null>> <<null>> <PEGA-PROCOM!9C3FBE0F16067CA5AA741FB53A02AE1E> <<null>> <<null>> <<null>> <<null>> <Rule-Obj-Class> <<null>> <<null>> <<null>> <<null>> <<null>> <<null>> <Data-Corr-> <CR><CR>CausedbySQLProblems.<CR>Problem#1, SQLState23000, Errorcode1:com.ibm.websphere.ce.cm.DuplicateKeyException:ORA-00001:uniqueconstraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated<CR><CR>Problem#2, SQLState23000, Errorcode1:java.sql.SQLIntegrityConstraintViolationException:ORA-00001:uniqueconstraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated<CR><CR> atcom.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:293)<CR> atcom.pega.pegarules.data.internal.access.DeferredOperationResult.throwSaveException(DeferredOperationResult.java:126)<CR> atcom.pega.pegarules.data.internal.access.DeferredOperationResult.throwUpdateInsertfailException(DeferredOperationResult.java:96)<CR> atcom.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:935)<CR> atcom.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:803)<CR> atcom.pega.pegarules.data.internal.access.UpdateProcessor.performOps(UpdateProcessor.java:1522)<CR> atcom.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:245)<CR> atcom.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:82)<CR> atcom.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:235)<CR> atcom.pega.pegarules.data.internal.access.UpdateProcessor.processUpdates(UpdateProcessor.java:178)<CR> atcom.pega.pegarules.data.internal.access.Saver.save(Saver.java:682)<CR> atcom.pega.pegarules.data.internal.access.Saver.save(Saver.java:1899)<CR> atcom.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:2704)<CR> atcom.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:2695)<CR> atcom.pega.pegarules.session.internal.async.AgentRuleUtils.saveDataInstance(AgentRuleUtils.java:287)<CR> atcom.pega.pegarules.session.internal.async.AgentRuleUtils.saveDataInstance(AgentRuleUtils.java:248)<CR> atcom.pega.pegarules.session.internal.async.AgentRuleUtils.createDAQInstance(AgentRuleUtils.java:410)<CR> atcom.pega.pegarules.session.internal.async.AgentRuleUtils.createOrUpdateDAQ(AgentRuleUtils.java:400)<CR> atcom.pega.pegarules.session.internal.async.AgentRuleUtils.checkAndUseDataInstance(AgentRuleUtils.java:365)<CR> atcom.pega.pegarules.session.internal.async.MasterForNewAgents.manageSchedules(MasterForNewAgents.java:379)<CR> atcom.pega.pegarules.session.internal.async.MasterForNewAgents.run(MasterForNewAgents.java:291)<CR> atcom.pega.pegarules.session.internal.async.Agent.runAgentTask(Agent.java:916)<CR> atcom.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.processAsyncTask(AsyncServant.java:222)<CR> atcom.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.invoke(AsyncServant.java:168)<CR> atcom.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:331)<CR> atcom.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:274)<CR> atcom.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:225)<CR> atsun.reflect.GeneratedMethodAccessor76.invoke(UnknownSource)<CR> atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)<CR> atjava.lang.reflect.Method.invoke(Method.java:508)<CR> atcom.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)<CR> atcom.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)<CR> atcom.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)<CR> atcom.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:246)<CR> atcom.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168)<CR> atcom.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(UnknownSource)<CR> atcom.pega.pegarules.session.internal.engineinterface.etier.mdb.PRAsync.processRequest(PRAsync.java:155)<CR> atcom.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.AsyncTask.run(AsyncTask.java:64)<CR> atcom.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.RunnableWrapper.run(RunnableWrapper.java:71)<CR> atcom.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271)<CR> atjava.security.AccessController.doPrivileged(AccessController.java:640)<CR> atcom.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:797)<CR> atcom.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)<CR> atcom.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)<CR> atcom.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)<CR>Causedby:com.ibm.websphere.ce.cm.DuplicateKeyException:ORA-00001:uniqueconstraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated<CR><CR> atsun.reflect.GeneratedConstructorAccessor76.newInstance(UnknownSource)<CR> atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)<CR> atjava.lang.reflect.Constructor.newInstance(Constructor.java:437)<CR> atcom.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:627)<CR> atcom.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:686)<CR> atcom.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2267)<CR> atcom.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1191)<CR> atcom.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:853)<CR> atcom.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeUpdate(DatabasePreparedStatementImpl.java:458)<CR> atcom.pega.pegarules.data.internal.access.Saver.executeUpdate(Saver.java:1530)<CR> atcom.pega.pegarules.data.internal.access.Saver.insertInstance(Saver.java:1094)<CR> atcom.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:931)<CR> ...41more<CR>]*
Still I am not able to get what this implies.
What Pega version is it? Any strategic application installed?
Hello,
I think you will have to investigate the log files to fully understand where this issue is coming from.
Now having said that you could just try to stop and restart the agent to check if the error remains.