Certain server routines (EXSTAJ, NXTBLK) cause deadlocks.
search cancel

Certain server routines (EXSTAJ, NXTBLK) cause deadlocks.

book

Article ID: 205191

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

The Automation Engine reports a lot of deadlocks in the following server routines: JPEXEC_R/EXSTAJ and JPEXEC_R/NXTBLK

20201215/112926.077 - U00003434 Server routine  'JPEXEC_R/NXTBLK' required '0' minutes and '20,517' seconds for processing.
20201215/112926.769 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
20201215/112936.741 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
20201215/112936.749 - U00003434 Server routine  'JPEXEC_R/EXSTAJ' required '0' minutes and '10,601' seconds for processing.
20201215/112936.759 - U00003434 Server routine  'JPEXEC_R/EXSTAJ' required '0' minutes and '10,584' seconds for processing.
20201215/112936.772 - U00003434 Server routine  'JPEXEC_R/EXSTAJ' required '0' minutes and '10,643' seconds for processing.
20201215/112940.742 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
20201215/112946.544 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
20201215/112949.545 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
20201215/112949.546 - U00003434 Server routine  'JPEXEC_R/NXTBLK' required '0' minutes and '33,721' seconds for processing.
20201215/112956.767 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
20201215/112956.810 - U00003434 Server routine  'JPEXEC_R/EXSTAJ' required '0' minutes and '20,042' seconds for processing.
20201215/112958.769 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
20201215/113006.734 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
20201215/113010.735 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
20201215/113010.736 - U00003434 Server routine  'JPEXEC_R/NXTBLK' required '0' minutes and '44,637' seconds for processing.
20201215/113016.599 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
20201215/113016.607 - U00003434 Server routine  'JPEXEC_R/EXSTAJ' required '0' minutes and '19,780' seconds for processing.
20201215/113016.658 - U00003434 Server routine  'JPEXEC_R/NXTBLK' required '0' minutes and '39,900' seconds for processing.
20201215/113019.600 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
20201215/113026.718 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Defect.

Resolution

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

Article title: How to register to Broadcom Software Product updates and Critical Alerts

https://knowledge.broadcom.com/external/article?articleId=133819

Public short description EN:
Fixed a problem which caused a large number of deadlocks.

Public description EN:
A problem has been fixed where errors in processing of EXSTAJ and NXTBLK messages caused deadlocks with an Oracle or a SQL Server database.

Component: Automation Engine

Automation Engine 12.3.4 - Available

Automation Engine 12.3.3 HF4 - Available

Automation Engine 12.2.7 - Available

Powered by Wolken Software