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)