KNOWN ISSUE: Eliminate unnecessary blocking (tablockx) on ResourceAssociation table in spResourceAssociationsDeleteData

book

Article ID: 158013

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

The customer is seeing frequent deadlocks involving
spResourceAssociationsDeleteData.

In some instances this causes:
1. the PM Import to fail, causing clients to be unable to download certain update packages,
2. or it locks on ResourceAssociation, causing some issues with Asset (usually when calling spSetAssetData).

Cause

Known issue.

Resolution

A permanent fix has been provided in 7.1 SP2 MP1 V6. (See HOWTO81832)

Applies To

Symantec Management Platform 7.1 SP2, 7.1 SP2 MP1

Attachments

Fix_eTrack3157905_spResourceAssociationsDeleteData_updated.sql get_app