ucybdbld fails to update Custom Attributes after modification
book
Article ID: 129093
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
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 ! *