RSA Identity Governance and Lifecycle displays error "Failed to save the review components" while signing off reviews
2 years ago
Originally Published: 2017-07-05
Article Number
000063673
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle 
RSA Version/Condition: 6.9.1+
 
Issue
Reviewers and Admins will not the able to sign off the reviews due to the following error seen when they sign off the review:

Error editing the Review:
Failed to save the review components
 
User-added image

Error editing the REVIEW
Failed to save the review components
 
User-added image

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 more
Cause
This is a known defect reported in ACM-73900.
 
Resolution
Upgrade to V6.9.2 P24, V7.0.1 P04, or V7.0.2 P02 to fix the issue. 
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).