RSA Identity Governance & Lifecycle ORA-20126, ORA-00942 and ORA-06512 errors when generating a multi-step User Review
Originally Published: 2019-08-26
Last Modified: 2022-06-20
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
Looping fulfillment workflows cause multiple issues in SecurID Governance & Lifecycle Number of Views What is the purpose of the Java node 'Calculate Items To Work On' in the Access Fulfilment Express (AFX) Default Fulfillme… Number of Views Data Archiving fails in Data Purging step in RSA Identity Governance & Lifecycle Number of Views Change Requests cancelled by Escalation Workflows progress to Fulfillment instead of getting cancelled in RSA Identity Gov… Number of Views Revert Changes calling out of the box Manual Activities workflow instead of the processing workflow used to fulfill the ch… Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
