Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Transaction was deadlocked on lock resources with another process" while executing ExecuteBatchDelete API in SQL Server
Problem Description
In Master Data Management (MDM), the following error message occurs while running the ExecuteBatchDelete API in an SQL Server:

"Transaction was deadlocked on lock resources with another process" ​
Cause
This is a known issue and MDM-22670 has been submitted to be addressed in a future release.
Solution
This is a known issue and MDM-22670 has been submitted to be addressed in a future release.

Workaround


Increase the  value of the following property in cmxserver.properties to a value higher than the maximum number of records to be deleted in 1 execution 

cmx.server.batch.delete.block_size

The above changes ensure that the delete runs in one thread only and therefore does not cause a deadlock, which seems to be occurring during deletion from the HIST tables.

More Information
Applies To
Product(s): Multidomain MDM
Product Version(s):
Database:
Operating System(s):
Other Software:

Reference
Attachments
Last Modified Date:2/7/2019 1:43 AMID:564805
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)