Discussion

3
Replies
279
Views
Close popover
Akhilesh Suman (sumaa)
PEGA
Sr. System Architect I - India Consulting
PEG
IN
sumaa Member since 2013 2 posts
PEGA
Posted: April 22, 2016
Last activity: April 6, 2018
Closed

CS7.1.4.1 jar import fails : Error Violation of PRIMARY KEY constraint 'pr4_rule_PK' Can't insert duplicate key in pr4_rule

We upgraded PRPC from 6.3 SP1 to 7.2. The upgrade is successful.

Now, we are upgrading CPM from CPM : 06.03 to CS : 7.1.4.1.

We checked the pre-requisites and executed drop trigger script. The CustomerService_714.jar import proceeds for 2-3 phases till the point it asks whether aged updated should be imported. We de-select the checkbox and proceed. Import fails with error "Save Failed: Violation of PRIMARY KEY constraint 'pr4_rule_PK'. Cannot insert duplicate key in object 'rules7.pr4_rule'. DatabaseException caused by prior exception: java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'pr4_rule_PK'. Cannot insert duplicate key in object 'rules7.pr4_rule'. | SQL Code: 2627 | SQL State: 23000"

OS : Windows Server 2008 R2 Enterprise

App : Tomcat 7.0.39

DB : sql server 2008

Please look into it and advise how to proceed further.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

System Administration Upgrades
Moderation Team has archived post,
Close popover 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.