[AWA] Database Unload Utility fails due to invalid order of statements


Article ID: 110137


Updated On:


CA Automic Workload Automation - Automation Engine


  • The AE DB Unload Utility can not finish due to DB lock issue after truncate DIVDB statement
20180704/125549.041 - truncate table DIVDB 20180704/125549.044 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 1d6e9b0 DB-HDBC: 1de6bf8 
20180704/125549.044 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR' 
20180704/125549.044 - U00003592 UCUDB - Status: '' Native error: '54' Msg: 'ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired' 
20180704/125549.044 - UCUDB32 EXEC RET 0005 HSTMT: 0x00000001e32590 VALUE: (nil) ALL: 0.00304 DB: 0.00285 ODBC: 0.00002 UDB: 0.00018 20180704/125549.044 - U00000005 LOCK
  • The issue still persist after removing “commit_write='BATCH,NOWAIT'” from connection string


Utility 12.1.2+build.536


This issue had been confirm as a bug and will be fixed in

- Automation.Engine 12.1.3 - Available
- Automation.Engine 12.2.1 - Available
- Automation.Engine 12.3.0 - Available

Workaround: Use manual query to perform utility activities