RSA Identity Governance and Lifecycle displays error "Failed to save the review components" while signing off reviews
Originally Published: 2017-07-05
Article Number
Applies To
RSA Version/Condition: 6.9.1+
Issue
Error editing the Review:
Failed to save the review components
Error editing the REVIEW
Failed to save the review components
The AveksaServer.log will have the following stack trace:
07/04/2017 14:12:56.040 ERROR (SaveReviewChangesThread3389-1730056) [com.aveksa.gui.pages.review.review.newEdit.SaveReviewChangesThread] Failed to signoff review components
com.aveksa.server.review.ReviewServiceException: Failed to save the review components
at com.aveksa.server.review.Review.signOffrevComponents(Review.java:1677)
at com.aveksa.server.review.Review.signOffInProcessSelectedRevComponents(Review.java:1271)
at com.aveksa.gui.objects.review.GuiReviewBase.signOffSelectedRevComponents(GuiReviewBase.java:336)
at com.aveksa.gui.pages.review.review.newEdit.SaveReviewChangesThread.run(SaveReviewChangesThread.java:273)
Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-20128: Failed to delete the review reports.
ORA-30926: unable to get a stable set of rows in the source tables
Stored Procedure:Update_Review_Data_On_Signoff execution aborted.
Stack:
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 7927
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 8399
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 8856
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 8867
ORA-06512: at line 1
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1473)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1331)
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:240)
at com.aveksa.server.review.Review.signOffrevComponents(Review.java:1661)
... 3 more
Caused by: java.sql.SQLException: ORA-20128: Failed to delete the review reports.
ORA-30926: unable to get a stable set of rows in the source tables
Stored Procedure:Update_Review_Data_On_Signoff execution aborted.
Stack:
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 7927
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 8399
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 8856
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 903
ORA-06512: at "AVUSER.ERROR_HANDLER_PKG", line 917
ORA-06512: at "AVUSER.ENTITLEMENT_REVIEW_PKG", line 8867
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1436)
... 6 moreCause
Resolution
Attachments
If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).
Related Articles
Review items gets auto sign-off in RSA Identity Governance and Lifecycle 52Number of Views Privileges(signoff and review) in coverage files are honored only when the sign off is enabled in review definition for RS… 54Number of Views sign-off button complains that there are no pending changes for Fine grained review where only members and entitlements ar… 23Number of Views Fine grained role review with sign-off option and maintain action for all items of the role is generating a CR and the CR … 39Number of Views Error when logging off the RSA Authentication Manager 8.x Web Tier: 'Error: Internal Server Error. The server encountered … 75Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to Download OTP Token Seed Files from myRSA How to Connect to the RSA Authentication Manager Database Using PostgreSQL (psql)
Don't see what you're looking for?