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

Document ID : KB000084358
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

While the ZDU (Zero Downtime Upgrade) is running DB. LOAD loading the initial data, the Automation Engine system becomes inaccessible. 
Environment:
OS: All
OS Version: N/A
Cause:
Cause type:
By design
Root Cause: The lock escalation on Microsoft SQL server causes this behavior.
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)