DB Utilities causing performance issues due to updates across all clients

book

Article ID: 87294

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
U00011869 Client/Mode/TaskPrio/AH_Idnr/TZ/Prio/EH_Kick/Cale_Ahead/VersionMgmnt/XRO/Object_Audit: 0000/STOP/200/0000000000/ /200/0003/0014/N/N/N

When loading a transport case into a client within a system that has OBJECT_AUDIT and VERSION_MANAGEMENT enabled, there is a period of system slowness (also accompanied by a usage spike across all WP's). The logs will show for all clients:

U00011869 Client/Mode/TaskPrio/AH_Idnr/TZ/Prio/EH_Kick/Cale_Ahead/VersionMgmnt/XRO/Object_Audit: 0000/STOP/200/0000000000/ /200/0003/0014/N/N/N

This impact is greatly magnified if the transport case is being loaded into multiple/all clients.

Cause

Cause type:
Defect
Root Cause: The utilities during a transport case movement do not check for a client, but instead update all clients.

Environment

OS Version: N/A

Resolution

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

Fix Status: Released

Fix Version(s):
Automation Engine 12.0.3 - Available
Automation Engine 11.2.4 HF1 - Available

Additional Information

Workaround :
Perform any DB activity during scheduled times to minimize impact.