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.
Article Type
Technical Solution


Issue



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


Environment



Symantec Management Platform 7.1 SP2, 7.1 SP2 MP1


Cause



Known issue.


Solution



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

SourceETrack
Value3157905, 3190700


Article URL http://www.symantec.com/docs/TECH206232


Terms of use for this information are found in Legal Notices