RSA Identity Governance and Lifecycle displays error "Failed to save the review components" while signing off reviews
Originally Published: 2017-07-05
Last Modified: 2023-10-06
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
RSA Identity Governance & Lifecycle Access Fulfillment Express (AFX) failure java.lang.NoClassDefFoundError: sun/net/www/p… 86Number of Views ORA-01840: Input value not long enough for date format error while setting the date type attribute filter in the review in… 27Number of Views Role Review showing incorrect entitlement count in RSA Governance & Lifecycle 145Number of Views Unable to complete Role Reviews because the entitlement counts are incorrect in RSA Identity Governance & Lifecycle 81Number of Views Review results are removed from the system after deleting a review definition in RSA Identity Governance & Lifecycle 30Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Reporting on RSA Authentication Manager 8.x users with On-Demand Token, a fixed passcode or a hardware/software token assi… How to Download OTP Token Seed Files from myRSA Anomalix idGenius - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?