Upgrade to 8.0x SPx is failing with Oracle error: check constraint violated

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Upgrade to 8.0x SPx is failing with Oracle error: check constraint violated

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Symptoms

An upgrade to Applications Manager 8.0 is failing with the error seen below:

ERROR at line 1:

ORA-02290: check constraint (UC4APPMGR.SSV_MUST_BE_LOWERCASE) violated

ORA-06512: at "UC4APPMGR.AWAPI", line 3876

ORA-06512: at "UC4APPMGR.AWAPI", line 3714

ORA-06512: at "UC4APPMGR.AW_IMPORT", line 3573

ORA-06512: at "UC4APPMGR.AW_IMPORT", line 4381

---

Cause

There error is seen during the portion of awinstall which tried to import Automic Objects, 'IMPEXP IMPORT UC4_Install ISAIMPORT'. The reason for the failure is because there is a constraint that exists which is being violated. As per the error above the constraint in question here is SSV_MUST_BE_LOWERCASE which is a custom user constraint (not from Automic).

---

Resolution

We recommend that you run the SQL below (with your DBA) to check to see what exactly that constraint is:

SQL> select constraint_name,constraint_type,table_name ,search_condition from user_constraints where constraint_name NOT like 'SYS%'; 

If the constraint in question is identified as a custom constraint then you will need to work with the Developer/DBA of the same at your end to resolve the issue. If this is identified as a Automic defined constraint, then please contact Automic Support for further assistance.