Article Content
Article Number | 000034672 |
Applies To | RSA Product Set: RSA Identity Governance & Lifecycle RSA Version/Condition: 7x Platform (DB): Remote Oracle database |
Issue | The Aveksa Statistics Report (ASR) cannot be generated in RSA Identity Governance & Lifecycle. NOTE: An ASR is generated by going to (Admin > Diagnostics > Create Report) or (Admin > System > Diagnostics tab > Create Report) depending on your version of RSA Identity Governance & Lifecycle. SYMPTOMS:
01/10/2017 03:29:16.509 ERROR (SystemReport) [com.aveksa.server.system.SystemReport] ASR Params: [Lcom.aveksa.server.db.ProcedureParameter;@6a560991 com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-04063: package body "AVUSER.SRSECTION_SYSTEM" has errors ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.SRSECTION_SYSTEM" ORA-06512: at "AVUSER.SYSTEM_REPORT", line 49 ORA-06512: at "AVUSER.SYSTEM_REPORT", line 234 ORA-06512: at line 1 at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1520) at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1378) at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:255) at com.aveksa.server.system.SystemReport.backgroundGenerateReport(SystemReport.java:97) at com.aveksa.server.system.SystemReport.access$000(SystemReport.java:30) at com.aveksa.server.system.SystemReport$1.run(SystemReport.java:42) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-04063: package body "AVUSER.SRSECTION_SYSTEM" has errors ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.SRSECTION_SYSTEM" ORA-06512: at "AVUSER.SYSTEM_REPORT", line 49 ORA-06512: at "AVUSER.SYSTEM_REPORT", line 234 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:205) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1043) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4755) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404) at com.aveksa.server.db.persistence.PersistenceServiceProvider.executeCallableStatement(PersistenceServiceProvider.java:1555) at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1483) ... 6 more 01/10/2017 03:29:16.510 ERROR (SystemReport) [SystemErr] Exception in thread "SystemReport" 01/10/2017 03:29:16.510 ERROR (SystemReport) [SystemErr] java.lang.RuntimeException: com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-04063: package body "AVUSER.SRSECTION_SYSTEM" has errors ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.SRSECTION_SYSTEM" ORA-06512: at "AVUSER.SYSTEM_REPORT", line 49 ORA-06512: at "AVUSER.SYSTEM_REPORT", line 234 ORA-06512: at line 1
Object Name: SRSECTION_SYSTEM Object Type: INVALID Clicking the Recompile Invalid Objects button has no effect.
If you have this issue, the output will look similar to the following:
Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log and migrate.log files for your specific deployment if you are on a WildFly cluster or a non-WildFly platform. The aveksaServer.log may also be downloaded from the RSA Identity Governance & Lifecycle user interface (Admin > System > Server Nodes tab > under Logs.) |
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 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. |