ZDU upgrade causes system to be inaccessible during the DB load step
Article ID: 84358
Updated On:
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.
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.
By design
Root Cause: The lock escalation on Microsoft SQL server causes this behavior.
Environment
OS: All
OS Version: N/A
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
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)
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)
Feedback
Yes
No
Powered by
