DBload error during update 11.2 to 12.3 because Vara key already exists

book

Article ID: 192530

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

In preparation for the update from version 11.2 to 12.3, the key SMGR_SUPPORT_LEGACY_SECURITY in the variable UC_SYSTEM_SETTINGS is set in advance in 11.2.

The DB load of the initial data V12.3SP2 is then aborted with the following error message:

insert into ovw (OVW_OH_Idnr, OVW_VValue, OVW_OH_Client, OVW_VRName, OVW_Value1) values ((Select oh_idnr from oh where oh_name = 'UC_SYSTEM_SETTINGS' and oh_client = 0),'SMGR_SUPPORT_LEGACY_SECURITY', 0, 'FREI', 'Y')
20200307/102741.885 - U00038089 Fehler: Konnte SQL-Kommando nicht ausführen:
'

insert into ovw (OVW_OH_Idnr, OVW_VValue, OVW_OH_Client, OVW_VRName, OVW_Value1) values ((Select oh_idnr from oh where oh_name = 'UC_SYSTEM_SETTINGS' and oh_client = 0),'SMGR_SUPPORT_LEGACY_SECURITY', 0, 'FREI', 'Y')'
20200307/102741.885 - U00038251 Operation fehlgeschlagen da ein Satz mit dem gleichen Primärschlüssel bereits existiert.
20200307/102741.886 - U00038068 A B B R U C H der Verarbeitung wegen Fehler

Cause

Usage/admin error

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

the SMGR_SUPPORT_LEGACY_SECURITY key must be set after upgrade