Article Number | 000036831 |
Applies To | RSA Product Set: Identity Governance & Lifecycle RSA Version/Condition: 7.0.1, 7.0.2 |
Issue | RSA Identity Governance & Lifecycle Review generation fails fail with the following error message in the task list.
Error ID: 592 EC[83001] Context[RunID=20, Review Def Id=2, Review Def Name = My Review] Message [Failed to create report from review definition]
The following error level log message is logged in the /home/oracle/wildfly-8.2.0.Final/standalone/log/aveksaServer.log:
10/11/2018 12:35:14.564 ERROR (Exec Task Consumer#0) [com.aveksa.server.review.ReviewDefinitionVersion] FAILED method=generateReport subTask=Get entitlements for review 169 com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-20126: The creation of reviews failed.
ORA-06508: PL/SQL: could not find program unit being called Stored Procedure:Generate_Review execution aborted. Stack: ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1807 ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903 ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917 ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1895 ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1537 ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1502 ORA-06512: at line 1
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1601) at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1459) at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:267) at com.aveksa.server.review.ReviewDefinitionVersion.generateReport(ReviewDefinitionVersion.java:797) at com.aveksa.server.review.ReviewDefinitionVersion.generateReport(ReviewDefinitionVersion.java:452) at com.aveksa.server.xfw.EntitlementReviewExecutor.executeTask(EntitlementReviewExecutor.java:70) at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99) at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-20126: The creation of reviews failed.
|
Cause | This issue may occur if the Oracle package has been updated, but not compiled correctly. This issue was known to occur in some instances if there were problems during the application of patches. |
Resolution | Apply the most recent patch for your version of the product. This issue has been resolved in recent patches. |
Workaround | If only a single package is reporting a failure this issue may be resolved by recompiling the problem package.
- From the error level log message identify the oracle package that has not been compiled correctly, shown here in bold:
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1807
- Using Oracle SQL Developer, locate the package in the package list.
- Right click on the package name and select Compile.
|
Notes | The error message ORA-20126: The creation of reviews failed is a generic error message for any review failure. There may be different failures that cause this message. For information about the specific failure, review the secondary error message in the stack trace. For example, in this instance the secondary error message is ORA-06508: PL/SQL: could not find program unit being called. |