PI Blocking History is not displayed for all SQL Server databases in the 7.3.0.10 cartridge
Review shows that there is blocking listed when narrowing down to previous time ranges, but sometimes the FMS logs show
VERBOSE [http-exec-66] system._dbwc_mssql_newpa_performance.scripts.CallQueryLockTree - Failed to Call Query Lock Tree with error : Failed to execute SQL:SELECT object_id AS object_id, object_name AS object_name, object_database AS object_database, object_owner AS object_owner, object_type AS object_type, resource_description AS resource_description FROM pass_object_dim_1m_202506061800 WHERE object_id IN (...Cause:Invalid column name 'resource_description'.Error Code: 207SQL State: S0001------------
Looking at the tables in the PI database, the 'resource_description' column is not listed.
Product defect
WORKAROUND
This issue was logged as HFIX-560 and has been fixed in the 7.3.0.23 and higher releases of the SQL Server cartridge. Contact Support for a copy of the hotfix.
STATUS
This issue has been logged as defect ID FOG-9918 and will be fixed in an upcoming release of the SQL Server cartridge.