on Jan 16, 2017Article Content
| Article Number | 000034682 |
| Applies To | RSA Product Set: RSA Identity Governance & Lifecycle RSA Version/Condition: 7.x Platform (DB): Remote Oracle database |
| Issue | After an RSA Identity Governance & Lifecycle upgrade, the migration of the database has the following errors in the migrate.log file ($AVEKSA_HOME/wildfly/standalone/log/migrate.log): /opt/dap/domains/ap1141/uat1/domain/servers/MS1/tmp/_WL_user/aveksa/iv1b37/aveksa.war/WEB-INF/database/migration/recompileAll.sql(1): Start time [Wed Jan 11 17:35:24 CET 2017] begin AV_Compile_Invalid_Objects; end; End time [Wed Jan 11 17:35:46 CET 2017] Execution time (s): 21 --------------------------- Dbms_Output Begin --------------------------- =========================================================== Error(s) occured while compiling invalid object SRSECTION_SYSTEM: LINE TEXT -------- -------------------------------------------------- 197 - PL/SQL: ORA-00942: table or view does not exist 197 - PL/SQL: SQL Statement ignored 201 - PL/SQL: ORA-00942: table or view does not exist 201 - PL/SQL: SQL Statement ignored 205 - PL/SQL: ORA-00942: table or view does not exist 205 - PL/SQL: SQL Statement ignored 209 - PL/SQL: ORA-00942: table or view does not exist 209 - PL/SQL: SQL Statement ignored 213 - PL/SQL: ORA-00942: table or view does not exist 213 - PL/SQL: SQL Statement ignored ========================================================== Error(s) occured while compiling invalid object SRSECTION_SYSTEM: LINE TEXT -------- -------------------------------------------------- 197 - PL/SQL: ORA-00942: table or view does not exist 197 - PL/SQL: SQL Statement ignored 201 - PL/SQL: ORA-00942: table or view does not exist 201 - PL/SQL: SQL Statement ignored 205 - PL/SQL: ORA-00942: table or view does not exist 205 - PL/SQL: SQL Statement ignored 209 - PL/SQL: ORA-00942: table or view does not exist 209 - PL/SQL: SQL Statement ignored 213 - PL/SQL: ORA-00942: table or view does not exist 213 - PL/SQL: SQL Statement ignored --------------------------- Dbms_Output End --------------------------- Logging into a SQL tool such as SQL*Plus as AVUSER and attempting to compile package SRSECTION_SYSTEM results in a compilation error:
Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the migrate.log file for your specific deployment, if you are on a WildFly cluster or a non-WildFly platform. |
| Cause | The procedure SRSECTION_SYSTEM executes a SQL SELECT statement against system table DBA_FREE_SPACE and AVUSER has not been granted access to that table. This issue occurs when the RSA Identity Governance & Lifecycle Oracle database is being migrated into a new Oracle database and the Oracle database has not been setup properly as per the RSA Identity Governance & Lifecycle Database Setup and Management Guide. |
| Resolution | As the SYSDBA user, GRANT SELECT on table DBA_FREE_SPACE to AVUSER in SQL using this command:
NOTE: Since the above GRANT was not performed on the database, it is possible that other required database setup may not have been completed on the database. Review the RSA Identity Governance & Lifecycle Database Setup and Management Guide for your version and ensure that the database has been properly configured for use with RSA Identity Governance & Lifecycle. In particular, see the section entitled Configure the User Schema Privilege Grants to view what needs to be executed against the Oracle database to ensure AVUSER has appropriate access to Oracle system views. |
| Notes | GRANT SELECT on table DBA_FREE_SPACE to AVUSER is also required to run the Aveksa Statistics Report (ASR). See RSA Knowledge Base Article 000034672 -- ASR fails to generate and the log file has 'ORA-04063: package body "AVUSER.SRSECTION_SYSTEM" has errors' error in RSA Identity Governance & Lifecycle for more information. |