Reorganization causing deadlocks on Oracle database

book

Article ID: 88131

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

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