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… 48Number of Views How to turn on/off verbose offline authentication logging 136Number of Views Review items gets auto sign-off in RSA Identity Governance and Lifecycle 50Number of Views UI shows duplicate entries for the same comment on Review Item Comments and History page in RSA Governance & Lifecycle 3Number of Views How to turn off or disable the RSA SecurID Access Portal 40Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide How to Download OTP Token Seed Files from myRSA RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?