000037883 - RSA Identity Governance & Lifecycle ORA-20126, ORA-00942 and ORA-06512 errors when generating a multi-step User Review

Document created by RSA Customer Support Employee on Aug 29, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037883
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0, 7.1.1
 
IssueWhen creating a multi-step Review with User Selection set to 'By selecting supervisors and using their subordinate users', the following error is generated in the Review:
 
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.
 

ResolutionThis issue is resolved in the following RSA Identity Governance & Lifecycle patches:
  • RSA Identity Governance & Lifecycle 7.0.2 P14
  • RSA Identity Governance & Lifecycle 7.1.0 P07
  • RSA Identity Governance & Lifecycle 7.1.1 P02
NotesNote that ORA-20126 is a generic error message generated for any type of error in a Review. Examine the full stack trace to confirm this issue matches your problem. 

Attachments

    Outcomes