Submit a ticketCall us
Home > Success Center > Orion Platform > High blocking on the Orion database

High blocking on the Orion database

Updated November 22, 2017

Overview

High volume of blocking caused by the following procedure:

apm_dbm_APM_HardwareItemStatistics_DeleteOrphans

This procedure runs the following code:

DELETE TOP (@ChunkSize) orph FROM APM_HardwareItem_Detail orph LEFT JOIN HWH_HardwareItem parent ON orph.HardwareItemID = parent.ID WHERE parent.ID IS NULL

Environment

  • NPM 12.1
  • SAM 6.3 HF2

Cause 

Bug in SAM 6.3 and Hardware Health (HWH) 7.x caused by residual code before HWH was moved from SAM to a separate package. This residual code conflicts with HWH updates implemented in version 8.0.

The following database procedures should be deleted when upgrading from HWH 7.1 to HWH 8.0:

  • apm_dbm_APM_HardwareHierarchy_DeleteOrphans
  • apm_dbm_APM_HardwareItem_DeleteOrphans
  • apm_dbm_APM_HardwareCategoryStatus_DeleteOrphans
  • apm_dbm_APM_HardwareInfo_DeleteOrphans

Resolution

Update SAM to version 6.4 and install the latest hotfixes. 

 

 

Last modified

Tags

Classifications

Public