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

Document created by RSA Customer Support Employee on Jan 16, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034682
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.0, 7.0.1
Issue
  • Migrating a database from 6.* to 7.0 or 7.0.1 has the following errors in the migrate.log during the execution of recompileAll.sql:
/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 SQL Developer as the avuser and attempting to compile package SRSECTION_SYSTEM results in the same error.
CauseThe procedure AVUSER.SRSECTION_SYSTEM executes a SQL select statement against system table dba_free_space and the AVUSER has not been granted access to that table as per the RSA Via Lifecycle and Governance 7.0 Database Setup and Management Guide or the RSA Identity Governance and Lifecycle V7.0.1 Database Setup and Management Guide, depending on your installation.

 



 
ResolutionAs sysdba, grant select on table dba_free_space to the avuser in SQL using this command:
GRANT SELECT ON dba_free_space TO AVUSER;

Please see the RSA Via Lifecycle and Governance 7.0 Database Setup and Management Guide or the RSA Identity Governance and Lifecycle V7.0.1 Database Setup and Management Guide for more information.
 

Attachments

    Outcomes