Scenario
An error occurred while DTS was migrating full data based on a task that contains full data migration or synchronization. The error log information contains "Lock wait timeout exceeded; try restarting transaction".
Keywords
Lock wait timeout exceeded
Possible Causes
The performance of the destination database is insufficient or the destination database is under heavy load, which slows down the execution.
A connection to the destination database for a non-DTS workload is holding the lock for a long time.
Solutions
Pause the task.
Check the lock usage and load status on the destination database to see if slow SQL statements exist.
After the destination database is recovered to a normal status, restart the DTS task.