000034682 - 'Error(s) occured while compiling invalid object SRSECTION_SYSTEM:' during database migration in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jan 16, 2017Last modified by RSA Customer Support on Jul 31, 2020
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034682
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 7.x
Platform (DB): Remote Oracle database
 
IssueAfter 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:  


SQL> alter package SRSECTION_SYSTEM compile body;
Warning: Package Body altered with compilation errors.


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.
 
CauseThe 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.
 
ResolutionAs the SYSDBA user, GRANT SELECT on table DBA_FREE_SPACE to AVUSER in SQL using this command:

SQL> GRANT SELECT on DBA_FREE_SPACE to AVUSER;


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. 

NotesGRANT 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.
 

Attachments

    Outcomes