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.
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
i). Check the pa_repository table to confirm the highest row present.
select * from pa_repository
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
As part of enhancement FOG-5972 a column named resource_description was added to the series of PI tables being with pass_object_dim (e.g. pass_object_dim_p0).
i) Confirm that this resource_description column is included in pass_object_dim_p0 table.
ii). If column is missing, the run the attached upgrade_mssql_PI_schema.sql script in the PI repository. This script will add the column (if missing) to all pass_object_dim tables. Users must be logged into Supportlink to download this file.
iii). Then once again, confirm that this resource_description column is included in pass_object_dim_p0 table.