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

Article Id: 84358

Status: Published

Updated On: 15-04-2018 08:00

Legacy Id: 000013863

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

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)