DB unload fails with ORA-00054

book

Article ID: 206280

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

On version/service pack older than 12.1.3, 12.2.1, and 12.3.0, the db unload or ucybdbun runs for some time and then ends with the errors below - table names in [brackets] may differ; for example, this might fail on MELD table or AH table as well:
 

20170714/213810.400 - U0003592 UCUDB - Status: '' Native error: '54' Msg: 'ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired'
20170714/213810.400 - U0000005 LOCK
20170714/213810.400 - U0037178 Error occured in SQL-Turncate of table [DIVDB].
20170714/213810.400 - U0037107 Error during reorganization of table ['RH']. Program exits with error.
20170714/213810.448 - U0037022 ABORTING due to error.

Cause

This is caused by a defect where there was an incorrect order of operations in the code:

delete 
truncate 
commit 

which should have been

delete 
commit 
truncate 

Environment

Release : 12.2.0, 12.1.2

Component : AUTOMATION ENGINE

Resolution

The utilities should be updated to the latest service pack for the version being run; for example, if the utilities are running on 12.2.0, they should be updated to the latest 12.2.x service pack.

This was fixed with the utilities for 12.1.3, 12.2.1, and 12.3.0.

If this still does not resolve the issue, please see knowledge article 87971: https://knowledge.broadcom.com/external/article?articleId=87971