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
Change Requests cancelled by Escalation Workflows progress to Fulfillment instead of getting cancelled in RSA Identity Gov… Number of Views Looping fulfillment workflows cause multiple issues in SecurID Governance & Lifecycle Number of Views L&G: New review appears stuck in parsing users task during review generation Number of Views RSA Identity Governance & Lifecycle aveksaServer.log file filling with warning messages "Logging event having message" and… Number of Views Oracle Collector Error "Non supported character set (add orai18n.jar)" in SecurID Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA Authentication Manager 8.9 Patches and Hotfixes Readme Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
