Discussion

3
Replies
262
Views
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.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn