Error occurs when running the script to update the data schema
Error occurs when running the script to update the data schema.
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
Duplicate pzinskey values are present in the pr_data table.
ResolutionPerform 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
0% found this useful