Scenario:
A user's AE database on the MS SQL server is experiencing deadlocks.
Solution:
Verify if versioning is enabled:
To enable:
For more details, refer to the documentation.
A user's AE database on the MS SQL server is experiencing deadlocks.
Solution:
Verify if versioning is enabled:
SELECT is_read_committed_snapshot_on FROM sys.databases
WHERE name= 'YourDatabaseName'
To enable:
alter database database name set READ_COMMITTED_SNAPSHOT ON
For more details, refer to the documentation.
otherwise you will receiver the error message:
Please execute the following statement to solve the issue: