AWA: When upgrading, DB load fails with error on SMG_SUPPORT_LEGACY_SECURITY

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to upgrade the Automation Engine, the DB Load fails with:

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')
20200502/094342.954 - U00038089 Error: Problem during execution of SQL command:

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Key already exists, being entered manually.

Resolution

Remove the entry from the Database for SMGR_SUPPORT_LEGACY_SECURITY (select * from OVW where OVW_VValue = 'SMGR_SUPPORT_LEGACY_SECURITY) and reattempt the load.