000036831 - RSA Identity Governance & Lifecycle review generation fails with ORA-20126 and ORA-06508

Document created by RSA Customer Support Employee on Oct 15, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036831
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.1, 7.0.2
 
IssueRSA 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.


 
CauseThis 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. 
ResolutionApply the most recent patch for your version of the product.  This issue has been resolved in recent patches.
WorkaroundIf only a single package is reporting a failure this issue may be resolved by recompiling the problem package.   
  1. 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


  1. Using Oracle SQL Developer, locate the package in the package list. 
  2. Right click on the package name and select Compile.

User-added image
NotesThe 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.

Attachments

    Outcomes