1). Confirming the pa_repository record
Please run the following SQL in the SQL Server PI repository database to check if the pa_repository records exist or not:
select * from pa_repository
If the pa_repository record does NOT exist, you can run below SQL to insert pa_repository record:
Upgrading from cartridge 6.3.x.x
insert into pa_repository values(current_timestamp, '20200814-1500', '5.0.4-0', '1.16', 0)
Upgrading from cartridge 7.1.x.x
insert into pa_repository values(current_timestamp, '20200814-1500', '5.0.4-0', '1.17', 0)
Upgrading from cartridge 7.3.0.x
insert into pa_repository values(current_timestamp, '20200814-1500', '5.0.4-0', '1.18', 0)
Upgrading from cartridge 7.3.1.x
insert into pa_repository values(current_timestamp, '20200814-1500', '5.0.4-0', '1.19', 0)
Upgrading from cartridge 8.0.x
insert into pa_repository values(current_timestamp, '20200814-1500', '5.0.4-0', '1.20', 0)
Then retry the upgrade step.
Note: It is okay to have multiple rows in this table with each having a different schema_version number.
2). Check for a resource_description column in the pass_object_dim_% tables.
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.
