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