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
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 Looping fulfillment workflows cause multiple issues in SecurID 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 Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
