Question
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
Error code 1: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PEGA_RULES_1.PR_INDEX_REFERENCE_PK) violated<CR><CR> at com.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.
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.