ucybdbld fails to update Custom Attributes after modification

book

Article ID: 129093

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

After the modification of Custom Attributes of an object, the promotion of that object by means of Transport Case, DB Unload and DB Load fails. The load step (ucybdbld) fails with the following error:

U00021161 ERROR: Transport case is inconsistent (processed object '' table 'OCA' ), loading to Database is not possible. Please contact Automic Support ! 

Setting traces on ucybdbld yields the following error:
0180606/181325.253 - INSERT INTO OCA (OCA_OH_Idnr, OCA_Name, OCA_Value) VALUES (?, ?, ?) 
20180606/181325.259 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: b243b0 DB-HDBC: b6b920 
20180606/181325.259 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR' 
20180606/181325.259 - U00003592 UCUDB - Status: '' Native error: '1' Msg: 'ORA-00001: unique constraint (UC4.PK_OCA) violated' 
20180606/181325.259 - U00003594 UCUDB Ret: '2' opcode: 'INSR' SQL Stmnt: 'INSERT INTO OCA (OCA_OH_Idnr, OCA_Name, OCA_Value) VALUES (?, ?, ?)' 
20180606/181325.259 - UCUDB32 INSR RET 0002 HSTMT: 0x00000000b85a80 VALUE: 0x00000000000001 ALL: 0.00607 DB: 0.00581 ODBC: 0.00003 UDB: 0.00023 
20180606/181325.259 - ucdbup: exit mit ret: 0001 
20180606/181325.259 - U00021161 ERROR: Transport case is inconsistent (processed object '' table 'OCA' ), loading to Database is not possible. Please contact Automic Support ! * 

Cause

The existing OCA is not handled correctly

Environment

Release: AUTWAB99000-12.2-Automic Workload Automation-Base Edition
Component:

Resolution

Solution:
 

Update to a fix version listed below or a newer version if available.

 

Fix version:

Component: Utility

Automation Engine 12.0.7 - Available
Automation Engine 12.1.4 - Available
Automation Engine 12.2.2 - Available
Automation Engine 12.3.0 - Planned release 2019-06-28