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

Document ID : KB000085103
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
20161122/124744.612 - U00003592 UCUDB - Status: '' NativeError: '1' Msg: 'ORA-00001: unique constraint (UC4.PK_SVALM) violated'

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 a Message EXISTS.

In the log-file, 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_FEHLER    Database-Handles  DB-HENV: 8113090  DB-HDBC: 816e580
20161122/124744.612 - U00003591 UCUDB - DB-Fehler-Info: Opc: 'OCIStmtExecute' Rückgabewert: '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 mit ret: 0001
...
20161122/124825.440 - U00000002 EXISTS
20161122/124825.456 - U00000002 EXISTS

 
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Date in UC_SVALM table is not deleted before inserting new records into the same table.
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Automation Engine 12.1.0 - Available
Automation Engine 12.0.1 - Available
Automation Engine 11.2.4 - Available
Automation Engine 11.2.3 HF2 - Available
Additional Information:
Workaround :
N/A