ZDU upgrade causes system to be inaccessible during the DB load step

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

While the ZDU (Zero Downtime Upgrade) is running DB. LOAD loading the initial data, the Automation Engine system becomes inaccessible. 

Cause

Cause type:
By design
Root Cause: The lock escalation on Microsoft SQL server causes this behavior.

Environment

OS: All
OS Version: N/A

Resolution

Update to a fix version listed below or a newer version if available.
 

Fix Status: Released

Fix Version(s):
Component(s): Automation Engine

Automation.Engine 12.1.0 - Avaiable
Automation.Engine 12.0.0 - Available

Additional Information

Workaround :
Disable the lock escalation on all the tables before running the DB.LOAD step during a ZDU.

ALTER TABLE schema.tablename SET (LOCK_ESCALATION=DISABLE)