Support Article
Upgrade.bat fail: cannot validate PR_PERF_STATS_PK PK violated
SA-16805
Summary
Upgrading PRPC 5.5 to Pega 7.1.7 by running "upgrade.bat -dataOnly true" fails.
Error Messages
[java] WARNING: Failed to execute SQL in file oracledate02710.sql
[java] Oct 30, 2015 1:51:54 PM com.pega.pegarules.install.SQLLoader writeMe
ssage
[java] WARNING: Statement: ALTER TABLE RULES_SCHEMA.pr_perf_stats
[java] ADD CONSTRAINT pr_perf_stats_PK PRIMARY KEY
[java] (
[java] pzInsKey
[java] )
[java] java.sql.SQLException: ORA-02437: cannot validate (RULES_SCHEMA.PR_PERF_STATS_PK) - primary key violated
Steps to Reproduce
1. Migrate data schema from PRPC 5.5 to a temporary database
2. Run "upgrade.bat -dataOnly true" command
Root Cause
A defect or configuration issue in the operating environment
Resolution
Make the following change to the operating environment:
1. Migrate the updated Pega 7.1.7 rules schema to the new environment
2. Run the following commands to clear the pr_data_restore, pr_data_products and pr_perf_stats tables in the rules schema of the new environment:
- truncate table pr_data_restore;
- truncate table pr_data_products;
- truncate table pr_perf_stats;
3. Continue upgrading the data schema by rerunning the command: upgrade.bat --dataOnly true
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.