RSA Identity Governance & Lifecycle ORA-20126, ORA-00942 and ORA-06512 errors when generating a multi-step User Review
Originally Published: 2019-08-26
Article Number
Applies To
RSA Version/Condition: 7.0.2, 7.1.0, 7.1.1
Issue
EC[83001] Context[RunID=19390, Review Def Id =66, Review Def Name =MyMultistep2] Message[Failed to create report from review definition]
The aveksaServer.log file shows the following exception:
02/11/2019 12:01:22.509 ERROR (Exec Task Consumer#0 - Sequence) [com.aveksa.server.review.ReviewDefinitionVersion] FAILED method=generateReport subTask=Get entitlements for review 55 02/11/2019 12:01:22.509 ERROR (Exec Task Consumer#0 - Sequence) [com.aveksa.server.review.ReviewDefinitionVersion] FAILED method=generateReport subTask=Get entitlements for review 55 com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-20126: The creation of reviews failed. ORA-20126: The creation of reviews failed. Stored Procedure:Parse_User_Review execution aborted.ORA-20126: The creation of reviews failed. Stored Procedure:Parse_Users_In_User_Review execution aborted.ORA-00942: table or view does not existORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 3361ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 6803 Stack:ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 3361ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 6803ORA-06512: at "AVUSER.EStored Procedure:Generate_Review execution aborted.Stack:ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 373ORA-06512: at "AVUSER.REVIEW_DEFINITION_PARSER", line 274ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 632ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1753ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1914ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1563ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 1501ORA-06512: at line 1 at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1548) at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1480) at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:245) at com.aveksa.server.review.ReviewDefinitionVersion.generateReport(ReviewDefinitionVersion.java:792) at com.aveksa.server.review.ReviewDefinitionVersion.generateReport(ReviewDefinitionVersion.java:447) 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:748)Caused by: java.sql.SQLException: ORA-20126: The creation of reviews failed.
Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the log files for your specific deployment.
Cause
This issue occurs because the user filter is incorrectly passed to the second part of the Review. This is a known issue reported in engineering ticket ACM-95533.
Resolution
- RSA Identity Governance & Lifecycle 7.0.2 P14
- RSA Identity Governance & Lifecycle 7.1.0 P07
- RSA Identity Governance & Lifecycle 7.1.1 P02
Notes
Related Articles
RSA Identity Governance and Lifecycle review shows members with dashes for Maintain/Revoke action buttons Number of Views Looping fulfillment workflows cause multiple issues in SecurID Governance & Lifecycle Number of Views Multi-App Entitlement Data Collector (MAEDC) fails with ORA-30926 if two MAEDCs overlap in Application Name and Internal I… Number of Views "Request could not be handled" error seen when clicking on submitted form tab for request raised via Webservices in RSA Id… Number of Views Multiple roles stuck in applied state after applying bulk change on multiple roles in RSA Governance & Lifecycle Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records Unable to login to RSA Authentication Manager Security Console as super admin RSA Authentication Manager 8.9 Release Notes (January 2026) How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Connection fails to Cloud Authentication Service when connecting through a proxy server from RSA Authentication Manager to…
Don't see what you're looking for?
