Support Article
Error occurs when running the script to update the data schema
SA-87948
Summary
Error occurs when running the script to update the data schema.
Error Messages
WARNING - Statement: ALTER TABLE TMPEGW71.pr_data
[java] ADD CONSTRAINT "PR_DATA_PK" PRIMARY KEY
Steps to Reproduce
- Update from Pega 7.2.2 to 7.4
- Log in to the application
- Run the update.sh script
Root Cause
Duplicate pzinskey values are present in the pr_data table.
Resolution
Perform the following local-change:- Run the below query to get the duplicate pzinskey:
select pzinskey from pr_data group GROUP BY pzinskey
HAVING COUNT(*) > 1;
- Remove the duplicate entries from the table and resume the upgrade process
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.