search cancel

Not able to deactivate some objects

book

Article ID: 254615

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Some objects still appear in the Process Monitoring page after being manually deactivated with the option 'forced'.

The following error appears in the log:

20221027/033418.147 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20221027/033418.147 - U00003592 UCUDB - Status: '' Native error: '1' Msg: 'ORA-00001: unique constraint (AUTOMIC.PK_ACV) violated'

When running a trace (tcp/ip=2, db=4) the following message appears in the trace file:

20221027/033416.787 - JPEXEC_R       RCV DEACT  frm AUTOMIC#WP033               MQWP   MsgID: 0070156462 c-acv: 00000000
20221027/033416.788 -  STRT UCUMIGR    OPC: 00002
20221027/033416.788 -  EXIT UCUMIGR    RET: 0000000000 TIME: 0000,00000 RETTEXT=' '
20221027/033416.788 - U00009909 TRACE: (BINDPAR: EH_AH_Idnr    )                     0x7eff7714c5f4 000004
                00000000 5C855C1E               >\…\.509379932
<...>
20221027/033416.794 - INSERT INTO ACV (ACV_AH_Idnr, ACV_VName, ACV_Type, ACV_Encrypted, ACV_Connection, ACV_Key, ACV_Value) SELECT ECV_AH_Idnr, ECV_VName, ECV_Type, ECV_Encrypted, ECV_Connection, ECV_Key, ECV_Value FROM ECV WHERE ECV_AH_Idnr = ?
20221027/033418.140 - U00003524 UCUDB: ===> Time critical DB call\!    OPC: 'EXEC' time: '1:346.341.999'
20221027/033418.140 - U00003525 UCUDB: ===> 'INSERT INTO ACV (ACV_AH_Idnr, ACV_VName, ACV_Type, ACV_Encrypted, ACV_Connection, ACV_Key, ACV_Value) SELECT ECV_AH_Idnr, ECV_VName, ECV_Type, ECV_Encrypted, ECV_Connection, ECV_Key, ECV_Value FROM ECV WHERE ECV_AH_Idnr = ?'
20221027/033418.140 - UCUDB32 EXEC RET 0000 HSTMT: 0x000000038cd420 VALUE: 0xffffffffffff8de4 ALL: 1.34634 DB: 1.34624 ODBC: 0.00002 UDB: 0.00009
20221027/033418.141 - U00009909 TRACE: (BINDPAR: ECV_AH_Idnr    )                     0x7eff77b70b1c 000004
                00000000 5C855C1E               >\…\.509379932<
20221027/033418.141 - INSERT INTO ACV (ACV_AH_Idnr, ACV_VName, ACV_Type, ACV_Encrypted, ACV_Connection, ACV_Key, ACV_Value) SELECT ECV_AH_Idnr, ECV_VName, ECV_Type, ECV_Encrypted, ECV_Connection, ECV_Key, ECV_Value FROM ECV WHERE ECV_AH_Idnr = ?
20221027/033418.147 - U00029108 UCUDB: SQL_ERROR  Database handles DB-HENV: 237c1d0 DB-HDBC: 23f9590
20221027/033418.147 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20221027/033418.147 - U00003592 UCUDB - Status: '' Native error: '1' Msg: 'ORA-00001: unique constraint (AUTOMIC.PK_ACV) violated'
20221027/033418.147 - U00003594 UCUDB Ret: '2' opcode: 'EXEC' SQL Stmnt: 'INSERT INTO ACV (ACV_AH_Idnr, ACV_VName, ACV_Type, ACV_Encrypted, ACV_Connection, ACV_Key, ACV_Value) SELECT ECV_AH_Idnr, ECV_VName, ECV_Type, ECV_Encrypted, ECV_Connection, ECV_Key, ECV_Value FROM ECV WHERE ECV_AH_Idnr = ?'
20221027/033418.147 - UCUDB32 EXEC RET 0002 HSTMT: 0x000000038cd420 VALUE:      (nil) ALL: 0.00609 DB: 0.00590 ODBC: 0.00002 UDB: 0.00018

We see that the same insert into ACV is repeated twice: the first time 36324 records are inserted (hex 8de4) but the second time it fails (RET 0002). Because of this, the change is not committed and deactivation fails.

Environment

Release : 12.3 / 21.0

Cause

Due to a hardcoded limit of 32767 (hex 7fff), the insert is looping.

Resolution

This is a bug that will be fixed in a future version of v21.0. No fix in v12.3 will be provided.