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

Article:TECH206232  |  Created: 2013-05-15  |  Updated: 2013-08-27  |  Article URL
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


The customer is seeing frequent deadlocks involving

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).


Symantec Management Platform 7.1 SP2, 7.1 SP2 MP1


Known issue.


This issue has been reported to the Symantec Development team. The fix is in ITMS 7.1 SP2 MP1 Rollup v6 (See HOWTO81832).


Supplemental Materials

Value3157905, 3190700

Article URL

Terms of use for this information are found in Legal Notices