DB Load: U00021161 ERROR: Transport case is inconsistent
Article ID: 103916
Updated On:
Products
CA Automic Workload Automation - Automation Engine
AUTOMIC WORKLOAD AUTOMATION
Issue/Introduction
The DB Load Utility is executed to load a 'transport case' in the AWA database. During this execution the database reports a 'transaction log full' issue.
Extract from the DBLoad utility log file:
============================================================================================
U00003592 UCUDB - Status: '42000' Native error: '9002' Msg: 'The transaction log for database '<DB NAME>' is full due to 'ACTIVE_TRANSACTION'.'
U00003536 UCUDB: FATAL DATA BASE ERROR: Re-connection will be attempted in 10 seconds.
============================================================================================
The 'transport case' loading fails with the following error messages:
============================================================================================
U00003594 UCUDB Ret: '6' opcode: 'INSR' SQL Stmnt: 'INSERT INTO OT (OT_OH_Idnr, OT_Type, OT_Lnr, OT_Content) VALUES (?, ?, ?, ?)'
U00003524 UCUDB: ===> Time critical DB call! OPC: 'INSR' time: '59:466.179.113'
U00003525 UCUDB: ===> 'INSERT INTO OT (OT_OH_Idnr, OT_Type, OT_Lnr, OT_Content) VALUES (?, ?, ?, ?)'
U00021161 ERROR: Transport case is inconsistent (processed object '' table 'OT' ), loading to Database is not possible. Please contact Automic Support !
============================================================================================
Extract from the DBLoad utility log file:
============================================================================================
U00003592 UCUDB - Status: '42000' Native error: '9002' Msg: 'The transaction log for database '<DB NAME>' is full due to 'ACTIVE_TRANSACTION'.'
U00003536 UCUDB: FATAL DATA BASE ERROR: Re-connection will be attempted in 10 seconds.
============================================================================================
The 'transport case' loading fails with the following error messages:
============================================================================================
U00003594 UCUDB Ret: '6' opcode: 'INSR' SQL Stmnt: 'INSERT INTO OT (OT_OH_Idnr, OT_Type, OT_Lnr, OT_Content) VALUES (?, ?, ?, ?)'
U00003524 UCUDB: ===> Time critical DB call! OPC: 'INSR' time: '59:466.179.113'
U00003525 UCUDB: ===> 'INSERT INTO OT (OT_OH_Idnr, OT_Type, OT_Lnr, OT_Content) VALUES (?, ?, ?, ?)'
U00021161 ERROR: Transport case is inconsistent (processed object '' table 'OT' ), loading to Database is not possible. Please contact Automic Support !
============================================================================================
Cause
Utilities always interferes directly with a database. For this reason, any technical issue occurring on a database will always have a severe impact on a currently running Utility. 'Retry on Error' is not handled by Automation utilities. No guarantee can be given that any utility action will execute fine in such a situation.
Environment
Release: AUTWAB99000-12.0-Automic Workload Automation-Base Edition
Component:
Component:
Resolution
Resolution consists in fixing the database issue first and to run the 'transport case' insertion again.
No Fix
No Fix
Feedback
Yes
No
Powered by
