Question

2
Replies
96
Views
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 221 posts
Anthem
Posted: March 6, 2020
Last activity: March 10, 2020
Posted: 6 Mar 2020 5:57 EST
Last activity: 10 Mar 2020 9:15 EDT
Closed

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 ?

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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.