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
Privileges(signoff and review) in coverage files are honored only when the sign off is enabled in review definition for RS… 47Number 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 … 36Number of Views Review items gets auto sign-off in RSA Identity Governance and Lifecycle 50Number of Views Rule doesnt kick off after unification using RSA Identity Governance and Lifecycle 33Number of Views Error while accessingthe IWA connector site http : error system.web/identity@impersonate is set to true. ADP turned off. 6Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?