Blocking history missing in 7.3.1 and higher SQL Server cartridges. Errors similar to the following appear in the agent log files.
ERROR [OLAP Roll-up - ] com.dell.dsgi.spi.common.utils.logger.LogUtils - RollupExecutionHelper.java:300:com.dell.dsgi.spi.repository.domain.rollup.RollupExecutionHelper$6.executeSQL():
Fail to Aggregate Table data to [pass_object_dim] SQL Statement: [INSERT INTO pass_object_dim_p26 WITH(ROWLOCK)
These errors are present for all pass_object_dim tables from _p0 through p_29.
Missing resource_description column on pass_object_dim tables in the PI 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.
