| Article Number | 000034682 |
| Applies To | RSA 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.
|
| Cause | The 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.
|
| Resolution | As 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.
|
on Jan 16, 2017