What are the challenges you face when working across database platforms? Take the survey
Options

DeadLock

We have started using DM to mask our SQL Server 2008 DB, the masking was done successfully an year ago and we have updated the Data Sets with updated rules. However running it now throws an exception as below, and it is caused by a deadlock issue, we think it might be related to multiple workers running at the same time to execute on the same tables. We tried to set it to utilize 1 worker and it seems to work but the time to mask doubles.

#### Masking Rule Exceptions
RuleID=01-0075, Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

RuleID=20-0048-04, Invalid operation. The connection is closed.

RuleID=20-0048-04, Invalid operation. The connection is closed.
Tagged:

Answers

Sign In or Register to comment.