Question

2
Replies
78
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 207 posts
Anthem
Posted: March 6, 2020
Last activity: March 10, 2020

PEGA Upgrade (7.3.1 to 8.3.1) - SQL issues.

Hi Team,

While trying to upgrade from PRPC7.3.1 to PRPC8.3.1,we are running into the below mentioned issues because of which upgrade has been halted.

Application Specs : PRPC7.3.1,MSSQL and Tomcat 8.5.13.

How can I disable these kind of messages while running the upgrade related SQL scripts ?

Msg 2714, Level 16, State 5, Line 94 There is already an object named 'pr_history_PK' in the database. Msg 1750, Level 16, State 0, Line 94 Could not create constraint. See previous errors. Msg 2705, Level 16, State 4, Line 522 Column names in each table must be unique. Column name 'pzInsKey' in table 'dbo.pr_data_offline_sync' is specified more than once. Msg 2705, Level 16, State 4, Line 526 Column names in each table must be unique. Column name 'pxInsName' in table 'dbo.pr_data_offline_sync' is specified more than once. Msg 2705, Level 16, State 4, Line 528 Column names in each table must be unique. Column name 'pxSaveDateTime' in table 'dbo.pr_data_offline_sync' is specified more than once. Msg 2705, Level 16, State 4, Line 530 Column names in each table must be unique. Column name 'pxCommitDateTime' in table 'dbo.pr_data_offline_sync' is specified more than once. Msg 2705, Level 16, State 4, Line 544 Column names in each table must be unique. Column name 'pzPVStream' in table 'dbo.pr_data_offline_sync' is specified more than once. Msg 2705, Level 16, State 4, Line 1370 Column names in each table must be unique. Column name 'pyKeyRotationInterval' in table 'dbo.pr_data_admin_sec_sde_cdk' is specified more than once.  

Pega Platform 8.3.1 System Administration Upgrades Healthcare and Life Sciences