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

Article Id: 158013
Status: Published
Updated On: 05-08-2014 06:49
Legacy Id: TECH206232
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

insert_drive_file Fix_eTrack3157905_spResourceAssociationsDeleteData_updated.sql
arrow_downward Download