KNOWN ISSUE: Eliminate unnecessary blocking (tablockx) on ResourceAssociation table in spResourceAssociationsDeleteData
|Article:TECH206232|||||Created: 2013-05-15|||||Updated: 2013-08-27|||||Article URL http://www.symantec.com/docs/TECH206232|
|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.|
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
This issue has been reported to the Symantec Development team. The fix is in ITMS 7.1 SP2 MP1 Rollup v6 (See HOWTO81832).
Article URL http://www.symantec.com/docs/TECH206232