Automation Engine deadlock while using Client Copy on a MSSQL database
Article ID: 216892
Updated On:
Products
Issue/Introduction
While using Client Copy on a live Client, the system experiences a performance issue and ultimately stops entirely.
Not only the jobs in the Client that is copied experience problems, all Clients are affected.
Killing the Client Copy sessions ultimately resolves the issue.
The WP log files contain messages like this:
20210508/231654.881 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 307180 DB-HDBC: 307260
20210508/231654.881 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
20210508/231654.881 - U00003592 UCUDB - Status: '40001' Native error: '1205' Msg: 'Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.'
20210508/231654.897 - U00000006 DEADLOCK
Environment
Release : 12.1
Component : AUTOMATION ENGINE
Cause
The MSSQL database application sometimes applies locks to blocks of data instead of individual line:
https://docs.microsoft.com/en-us/troubleshoot/sql/performance/resolve-blocking-problems-caused-lock-escalation
Resolution
Turn lock escalation of for all AE tables, see also here:
https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Admin/admin_MSSQLServer.htm
Feedback
