DB Load fails during Upgrade from 11.1.4 to 11.2.3 on Oracle Databases

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Trying to load the initial data during an upgrade from Automation Engine 11.1.4 to Automation Engine 11.2.3, the load fails with Oracle error ORA-00001. In the log-file of the DB Load tool, this error can be found:
 

20161122/124744.565 - INSERT INTO UC_SVALM (SVALM_SVAL_VName, SVALM_OType, SVALM_HostAttrType, SVALM_SubType, SVALM_AttName, SVALM_SecureLevel, SVALM_AttType, SVALM_Evaluation, SVALM_MinVal, SVALM_MaxVal, SVALM_CorrMinMax, SVALM_UCase, SVALM_DisplayMsgNr, SVALM_DescrMsgNr, SVALM_VarChange, SVALM_Rev) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
20161122/124744.612 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 8113090  DB-HDBC: 816e580
20161122/124744.612 - U00003591 UCUDB - DB error info: Opc: 'OCIStmtExecute' Return code: 'ERROR'
20161122/124744.612 - U00003592 UCUDB - Status: '' NativeError: '1' Msg: 'ORA-00001: unique constraint (UC4.PK_SVALM) violated'
20161122/124744.612 - U00003594 UCUDB-Ret: '2' Opcode: 'INSR' SQL-Stmnt: 'INSERT INTO UC_SVALM (SVALM_SVAL_VName, SVALM_OType, SVALM_HostAttrType, SVALM_SubType, SVALM_AttName, SVALM_SecureLevel, SVALM_AttType, SVALM_Evaluation, SVALM_MinVal, SVALM_MaxVal, SVALM_CorrMinMax, SVALM_UCase, SVALM_DisplayMsgNr, SVALM_DescrMsgNr, SVALM_VarChange, SVALM_Rev) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
...
20161122/124744.612 - ucdbup: exit with ret: 0001
...
20161122/124825.440 - U00000002 EXISTS
20161122/124825.456 - U00000002 EXISTS

Cause

Date in UC_SVALM table is not deleted before inserting new records into the same table.

Environment

Upgrade from 11.1.4 to 11.2.3

Resolution

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

Fix Version(s):

• Automation Engine 12.1.0
• Automation Engine 12.0.1
• Automation Engine 11.2.4
• Automation Engine 11.2.3 HF2