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

book

Article ID: 110137

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

  • 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

Environment

Utility 12.1.2+build.536

Resolution

Resolution:
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