Skip to main content
Contact a Moderator

Discussion

3
Replies
294
Views
 Vigneshwaran Aravindhan (VigneshAravind)
Cognizant
Senior Technology Architect
Cognizant
IN
VigneshAravind Member since 2007 29 posts
Cognizant
Posted: April 7, 2017
Last activity: April 6, 2018
Posted: 7 Apr 2017 6:55 EDT
Last activity: 6 Apr 2018 19:26 EDT
Closed

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ABC_RULES . PR_INDEX_REFERENCE_PK ) violated

This is our environment Unix + Oracle 12C + PRPC 7.2.1 in which we are upgrading an application from PRPC 6.1 SP2
We are at the second step in a split-schema out-of-place upgrade -aka- "rules upgrade"
While running the upgrade.sh we are receiving the below error; kindly verify and help us.
We have already ensured that the DB connection details and the connection credentials are valid. Could this be a space issue ?

2017-04-06 22:51:08,806 [ main] [ ] [ ] ( internal.util.MoveLog) ERROR - Fast Install Failed to save page with key INDEX-REFERENCE RULE-ACCESS-WHEN DATA-ADMIN-OPERATOR-ACCESSGROUP PZHASNOMTRESTRICTEDROLES #20130918T235445.563 GMT!0!RULEREFERENCE
[java] com.pega.pegarules.pub.PRException: There were 100 instances that were not imported.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.commit(FastLoader.java:823)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.execute(FastLoader.java:780)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:363)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadInstance(FastLoader.java:289)
[java] at com.pega.pegarules.deploy.internal.loaders.UpgradeFastLoader.importContents(UpgradeFastLoader.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.ArchiveImporterAbstract.importArchive(ArchiveImporterAbstract.java:46)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.handleArchive(Upgrader.java:154)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.runUpgrade(Upgrader.java:58)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
[java] at java.lang.reflect.Method.invoke(Method.java:507)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Apr 06, 2017 10:51:08 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
[java] com.pega.pegarules.pub.PRException: PRException
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:369)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadInstance(FastLoader.java:289)
[java] at com.pega.pegarules.deploy.internal.loaders.UpgradeFastLoader.importContents(UpgradeFastLoader.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.ArchiveImporterAbstract.importArchive(ArchiveImporterAbstract.java:46)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.handleArchive(Upgrader.java:154)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.runUpgrade(Upgrader.java:58)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
[java] at java.lang.reflect.Method.invoke(Method.java:507)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.PRException: There were 100 instances that were not imported.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.commit(FastLoader.java:823)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.execute(FastLoader.java:780)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:363)
[java] ... 16 more
[java]
[java] Apr 06, 2017 10:51:08 PM com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega
[java] SEVERE: Problem during method invocation (main)
[java] com.pega.pegarules.pub.PRException: PRException
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:369)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadInstance(FastLoader.java:289)
[java] at com.pega.pegarules.deploy.internal.loaders.UpgradeFastLoader.importContents(UpgradeFastLoader.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.ArchiveImporterAbstract.importArchive(ArchiveImporterAbstract.java:46)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.handleArchive(Upgrader.java:154)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.runUpgrade(Upgrader.java:58)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
[java] at java.lang.reflect.Method.invoke(Method.java:507)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.PRException: There were 100 instances that were not imported.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.commit(FastLoader.java:823)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.execute(FastLoader.java:780)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:363)
[java] ... 16 more
[java]
[java] Exception in thread "main" java.lang.RuntimeException: Problem during method invocation (main)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:279)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.PRException: PRException
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:369)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadInstance(FastLoader.java:289)
[java] at com.pega.pegarules.deploy.internal.loaders.UpgradeFastLoader.importContents(UpgradeFastLoader.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.ArchiveImporterAbstract.importArchive(ArchiveImporterAbstract.java:46)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.handleArchive(Upgrader.java:154)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.runUpgrade(Upgrader.java:58)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
[java] at java.lang.reflect.Method.invoke(Method.java:507)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] ... 1 more
[java] Caused by: com.pega.pegarules.pub.PRException: There were 100 instances that were not imported.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.commit(FastLoader.java:823)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.execute(FastLoader.java:780)
[java] at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:363)
[java] ... 16 more

System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 4 years ago
Posted: 7 Apr 2017 9:34 EDT
Vigneshwaran Aravindhan (VigneshAravind)
Cognizant
Senior Technology Architect
Cognizant
IN

We noticed the following error at the beginning of the log. We have decided to follow the suggestions mentioned at https://pdn.pega.com/community/pega-7-upgrade-center/question/prpc-61-pega-72-rule-upgrade-faile-unique-constraint

Show More

We noticed the following error at the beginning of the log. We have decided to follow the suggestions mentioned at https://pdn.pega.com/community/pega-7-upgrade-center/question/prpc-61-pega-72-rule-upgrade-faile-unique-constraint


[java] 2017-04-06 22:51:08,805 [                main] [          ] [                    ] (   internal.loaders.FastLoader) ERROR   - Encountered batch element exception: 

     [java] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ABC_RULES.PR_INDEX_REFERENCE_PK) violated

     [java] 

     [java]               at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

     [java]               at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

     [java]               at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)

     [java]               at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)

     [java]               at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

     [java]               at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

     [java]               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)

     [java]               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)

     [java]               at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)

     [java]               at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:12029)

     [java]               at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12140)

     [java]               at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)

     [java]               at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:513)

     [java]               at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.commit(FastLoader.java:797)

     [java]               at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.execute(FastLoader.java:780)

     [java]               at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:363)

     [java]               at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadInstance(FastLoader.java:289)

     [java]               at com.pega.pegarules.deploy.internal.loaders.UpgradeFastLoader.importContents(UpgradeFastLoader.java:90)

     [java]               at com.pega.pegarules.deploy.internal.archive.importer.ArchiveImporterAbstract.importArchive(ArchiveImporterAbstract.java:46)

     [java]               at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.handleArchive(Upgrader.java:154)

     [java]               at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:90)

     [java]               at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.runUpgrade(Upgrader.java:58)

     [java]               at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)

     [java]               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)

     [java]               at java.lang.reflect.Method.invoke(Method.java:507)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)

     [java]               at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

     [java] 2017-04-06 22:51:08,805 [                main] [          ] [                    ] (   internal.loaders.FastLoader) ERROR   - Encountered batch element exception: 

     [java] java.sql.BatchUpdateException: ORA-00001: unique constraint (ABC_RULES.PR_INDEX_REFERENCE_PK) violated

     [java] 

     [java]               at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)

     [java]               at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)

     [java]               at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:513)

     [java]               at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.commit(FastLoader.java:797)

     [java]               at com.pega.pegarules.deploy.internal.loaders.FastLoader$BatchedSQLExecutor.execute(FastLoader.java:780)

     [java]               at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadMainRule(FastLoader.java:363)

     [java]               at com.pega.pegarules.deploy.internal.loaders.FastLoader.loadInstance(FastLoader.java:289)

     [java]               at com.pega.pegarules.deploy.internal.loaders.UpgradeFastLoader.importContents(UpgradeFastLoader.java:90)

     [java]               at com.pega.pegarules.deploy.internal.archive.importer.ArchiveImporterAbstract.importArchive(ArchiveImporterAbstract.java:46)

     [java]               at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.handleArchive(Upgrader.java:154)

     [java]               at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:90)

     [java]               at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.runUpgrade(Upgrader.java:58)

     [java]               at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

     [java]               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)

     [java]               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)

     [java]               at java.lang.reflect.Method.invoke(Method.java:507)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)

     [java]               at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)

     [java]               at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)

     [java]               at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

     [java] 2017-04-06 22:51:08,805 [                main] [          ] [                    ] (   internal.loaders.FastLoader) ERROR   - The update for instance of type Index-Reference with key INDEX-REFERENCE RULE-ACCESS-ROLE-OBJ PEGAUVU:USER LOG-PEGARULESMOVE!0!RULEREFERENCE was aborted.



Show Less
Posted: 4 years ago
Posted: 10 Apr 2017 1:16 EDT
Dhevendra Earva (earvd)
PEGA
Senior Manager, Cloud Engineering
Pegasystems Inc.
IN

This is a bug in the product with PegaUVU rulesets.


Upgrade process will remove all the index references which starts with Pega- before loading the indexes. But PegaUVU does not start with Pega- it wont remove them and when it tries load the indexes it throws an error.


Please follow the workaround mentioned in the following most.


https://pdn.pega.com/community/pega-7-upgrade-center/question/prpc-61-pega-72-rule-upgrade-faile-unique-constraint#comment-229756

Related content:

Question

ORA-00001: unique constraint PR_SYS_RULESET_INDEX_PK violated

Question Solved

Getting ORA-00001: unique constraint violated when running install.sh

Question

ORA-00001: unique constraint (PEGASA.PR_SYS_RULE_IMPL_PK)

Question

pyCommitError: ORA-00001: unique constraint (DATAPEGA.PC_ASM_COBA83_WORK_PK) violated

Question

pyCommitError: ORA-00001: unique constraint (DATAPEGA.PC_ASM_COBA83_WORK_PK) violated

Question Solved

Pega 7.3 Ignite : java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DATA_SCHEMA_USER.PRPC_IGNITE_SERVER_ADDR_PK)

Discussion

java.sql.SQLException: ORA-02443: Cannot drop constraint - nonexistent constraint

Discussion

PRPC 61 to Pega 7.2 rule upgrade faile with unique constraint PR_INDEX_REFERENCE_PK violated error

Question

unique constraint PEGA_RULES.PR_ASSEMBLEDCLASSES_PK violation error

Question

java.lang.LinkageError: loader constraint violation Exception post upgrade to Pega 8.5.1

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice