Reorganization causing deadlocks on Oracle database

Article Id: 88131

Status: Published

Updated On: 15-04-2018 08:06

Legacy Id: 000008662

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

Error Message :
DEADLOCK

Only on an Oracle database when the automatic reorganization of the MQ-tables is turned on, a stored procedure is triggered to reorganize, when they exceed the block size. This stored procedure causes deadlocks.

Cause:

Cause type:
Defect
Root Cause: Modified the Oracle stored procedure.

Environment:

Release: AUTWAB99000-10.0-Automic Workload Automation-Base Edition
Component:

Resolution:

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Automation Engine of Automation Engine 11.2.2 - already available
Automation Engine of Automation Engine 11.1.3 - already available
Automation Engine of Automation Engine 10.0.8 - already available

Additional Information:

Workaround :
None