FAQ: How to resolve "Activity was deadlocked with another user" error in Microsoft Dynamics 365 Business Central

Message

"{\"error\":{\"code\":\"Internal_ServerError\",\"message\":\"The activity was deadlocked with another user who was modifying the [X] table. Please retry the activity. CorrelationId:...} 

Solution

The error occurs when two transactions are blocking each other. Business Central has a setting called Lock Time-out that is set to 10 seconds by default. You can disable this for long-running processes by calling the Database.LockTimeout(false) function as described in How to solve Table Locking Issues in Business Central.

Note that this article also recommends optimizing the time to complete the transactions. To do this in integrator.io, modify your Microsoft Dynamics 365 Business Central connection settings. Under the Advanced section, set the Concurrency level to 1.