Question
Bank Of America
US
Last activity: 6 Aug 2020 9:53 EDT
ORA-00001: unique constraint PR_SYS_RULESET_INDEX_PK violated
We are getting a unique constraint violation in PR_SYS_RULESET_INDEX table. server logs shows below trace. What could the possible reason? How can we rectify the issue? Any help is greatly appreciated!!
We are getting a unique constraint violation in PR_SYS_RULESET_INDEX table. server logs shows below trace. What could the possible reason? How can we rectify the issue? Any help is greatly appreciated!!
ORA-00001: unique constraint (PGRULESOWNER.PR_SYS_RULESET_INDEX_PK) violated
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1296)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:837)
at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.executeUpdate(DatabasePreparedStatementImpl.java:476)
at com.pega.pegarules.data.internal.access.DatabaseImpl$SaverImpl.saveInstance(DatabaseImpl.java:5350)
at com.pega.pegarules.data.internal.access.DatabaseImpl$SaverImpl.saveAllOrNone(DatabaseImpl.java:5265)
at com.pega.pegarules.session.internal.authorization.context.GlobalContextCache.writeRuleSetListHashToDB(GlobalContextCache.java:2261)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.populateRuleSetIndexTableAndCache(PRSessionProviderImpl.java:2053)
at com.pega.pegarules.exec.internal.basic.DependentRuleSetListPoolImpl$PREngineDeps.populateRuleSetIndexTableAndCache(DependentRuleSetListPoolImpl.java:852)
at com.pega.pegarules.exec.internal.basic.DependentRuleSetListPoolImpl.getDependentRulesetList(DependentRuleSetListPoolImpl.java:413)
at com.pega.pegarules.exec.internal.basic.DependentRuleSetListPoolImpl.get(DependentRuleSetListPoolImpl.java:150)
at com.pega.pegarules.data.internal.access.RuleResolver.getDependentRuleSetList(RuleResolver.java:3635)
at com.pega.pegarules.data.internal.PRDataProviderImpl.invokeRuleResolutionGetDependentRuleSetList(PRDataProviderImpl.java:394)
at com.pega.pegarules.generation.internal.vtable.ruleres.VirtualTableResolver.lookupSingleCandidateImpl(VirtualTableResolver.java:306)
at com.pega.pegarules.generation.internal.vtable.VirtualTableImpl.lookupSingleCandidateImpl(VirtualTableImpl.java:402)
at com.pega.pegarules.generation.internal.PRGenProviderImpl.lookupSingleCandidateImpl(PRGenProviderImpl.java:972)
at com.pega.pegarules.invokedyn.impl.IdyEngineImpl.lookupSingleCandidateImpl(IdyEngineImpl.java:39)
at com.pega.pegarules.invokedyn.impl.optimization.InlineOptimization.callOverToTheRuleResolver(InlineOptimization.java:69)
at com.pega.pegarules.invokedyn.impl.optimization.InlineOptimization.optimize(InlineOptimization.java:84)
at com.pega.pegarules.invokedyn.impl.IdyTargetDescriptorAbstract.configure(IdyTargetDescriptorAbstract.java:199)
at com.pega.pegarules.invokedyn.impl.IdyDescriptorHandlerType1.bootstrap(IdyDescriptorHandlerType1.java:118)
at com.pega.pegarules.invokedyn.impl.IdyDescriptorHandlerType1.bootstrapType1(IdyDescriptorHandlerType1.java:88)
at java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(DirectHandle.java:302)
at java.lang.invoke.CollectHandle.invokeExact_thunkArchetype_X(CollectHandle.java:130)
at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49)
at java.lang.invoke.MethodHandle.invokeBsm(MethodHandle.java:898)
at java.lang.invoke.MethodHandle.resolveInvokeDynamic(MethodHandle.java:949)
at com.pegarules.generated.activity.ra_action_setflagsforclunpostable_bd5dee8eac9838e4d2a717a81cd918d7.step2_circum0(ra_action_setflagsforclunpostable_bd5dee8eac9838e4d2a717a81cd918d7.java:318)
at com.pegarules.generated.activity.ra_action_setflagsforclunpostable_bd5dee8eac9838e4d2a717a81cd918d7.perform(ra_action_setflagsforclunpostable_bd5dee8eac9838e4d2a717a81cd918d7.java:86)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10514)