Question

2
Replies
58
Views
PradeepPydi Member since 2017 204 posts
Anthem
Posted: 6 months ago
Last activity: 6 months 1 week ago

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 Low-Code App Development Upgrades Healthcare and Life Sciences
Share this page LinkedIn