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.