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 type: Defect Root Cause: Modified the Oracle stored procedure.
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