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

Document ID : KB000110137
Last Modified Date : 10/08/2018
Show Technical Document Details
  • 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 on planned released date 24-09-2018 
- Automation.Engine 12.2.1
- Automation.Engine 12.3.0
Workaround: Use manual query to perform utility activities