SQL PI repository failed to upgrade to 7.3.1.x or 8.0 in the SQL Server cartridge (4380764)

During an upgrade from an earlier SQL Server cartridge release to a 7.3.1.x or 8.0.x cartridge the process was unable to complete due to callback request errors. The user continued on upgrading the Agent Managers to the newer 8.0.x cartridge.

Are there any steps necessary to complete the upgrade to the SQL PI repository?

Sixteen additional Wait Events were added to the SQL Server cartrigde in the 7.3.1.10 release as part of Enhancement FOG-9903. These new wait events should be updated and schema_id in the pa_repository table should be increased.

There should be 1229 (or less) wait events in the pass_wait_event_dim table for versions of the SQL Server cartridge at 7.3.0.x and lower.

1). Populate the SQL Server Wait Events table

i). Check the number of rows in the pass_wait_event_dim table after the insert. There should be 1245 rows in the table.

select count(*) from pass_wait_event_dim

ii). If there are less than 1245 rows, delete the existing set of wait events from the SQL Server PI repository

delete from pass_wait_event_dim

iii). Run the attached script of SQL insert statements into the pass_wait_event_dim table. Users must be logged in Supportlink to download this file.

iv). Confirm the number of rows in the pass_wait_event_dim table after the insert. There should be 1245 rows in the table.

select count(*) from pass_wait_event_dim

2). Check the current schema_id value in the pa_repository table

i). Check the pa_repository table to confirm the highest row present.

select * from pa_repository

• There should be a row with the schema_version 1.19 if the cartridge is a 7.3.1.x release (such as 7.3.1.10)
• There should be a row with the schema_version 1.20 if the cartridge is a 7.3.1.x release (such as 8.0.0.10)

ii). If a pa_repository record does NOT exist for the upgraded cartridge version, run the below SQL to insert pa_repository record: 

insert into pa_repository values(current_timestamp, '20200814-1500', '5.0.4-0', '1.19', 0)

insert into pa_repository values(current_timestamp, '20200814-1500', '5.0.4-0', '1.20', 0)

select * from pa_repository