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

[#1]

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.   

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

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

Image description

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.