UPGRADE_SDB_ORACLE.sql script does not run in SQL PLUS during the upgrade procedure for Cumulative Patch 14.4.1 or 14.4.2 of Identity Governance in Vaap with errors ORA-06550

Products

• CA Identity Manager

Issue/Introduction

UPGRADE_SDB_ORACLE.sql script does not run in SQL PLUS during the upgrade procedure for Cumulative Patch 14.4.1 or 14.4.2 of Identity Governance in Vaap.

Having this following errors inside of log that table or view does not exist

        sselect count(*) INTO verExists from SAGE_VERSION WHERE DBVersion='10.04.13.01';
                                            *
ERROR at line 6:
ORA-06550: line 6, column 38:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 6, column 2:
PL/SQL: SQL Statement ignored
ORA-06550: line 510, column 10:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 510, column 3:
PL/SQL: SQL Statement ignored

        SELECT COUNT(*) INTO verExists FROM SAGE_VERSION WHERE DBVersion='10.08.23.01';
                                            *
ERROR at line 7:
ORA-06550: line 7, column 38:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 7, column 2:
PL/SQL: SQL Statement ignored
ORA-06550: line 15, column 11:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 15, column 4:
PL/SQL: SQL Statement ignored

Environment

IG under Vaap 14.4.1 or Vaap 14.4.2
upgrade with Vaap Cummulative Patch requeries DB manual updates using the script UPGRADE_SDB_ORACLE.sql

Cause

wrong user being used to run the script.

Resolution

The reason of errors is because is running with one Oracle user without permission EurekifySDB database.
In General the Oracle user EUREKIFY_SDB that owns that EurekifySDB database.
After running with Oracle user  EUREKIFY_SDB that owns the database this is executed successfully.
Can  please confirm checking inside of Vaap file /opt/CA/wildfly-ig/standalone/configuration/standalone-full-ha-ca-gm.xml what user was pointed during the initial deploy as the owner of EurekifySDB. There is one line that refers to <module-option name="UserName" value="EUREKIFY_SDB"/>. In this example is EUREKIFY_SDB that is the user that owns the EurekifySDB database in Oracle. (Need to confirm in each different environment) and run the Oracle script UPGRADE_SDB_ORACLE.sql logged with this user (in this example is EUREKIFY_SDB user.