|Applies To||RSA Product Set: Via Lifecycle and Governance (Via L&G)|
RSA Product/Service Type: All
|Issue||After maintaining or revoking the review item, when you try to save or sign off the changes, it will fail to save the changes with the error shown below:|
Error editing the Review
Failed to save the review components.
You will observe the error below in the aveksaServer.log Accessing the aveksaServer.log file for RSA Lifecycle and Governance (L&G):
ERROR (SaveReviewChangesThread11757-14313266) [com.aveksa.gui.pages.review.review.newEdit.SaveReviewChangesThread]
|Cause||Execute the following queries on the database with the avuser[database user] login using SQL Developer or through a remote connection and using the “sqlplus username/password” command.|
SELECT max(id) FROM t_av_review_comp_changes;
You will find the value returned from the second query is smaller than the value from first one. The value from second query should be ideally greater than or equal to the value from the first. The max IDs need to be in sync with the sequence.
ALTER SEQUENCE REVIEW_COMP_CHANGE_SEQUENCE INCREMENT BY <value>;
Increment the REVIEW_COMP_CHANGE_SEQUENCE by a value so that it becomes more than value shown from the first query. For example,
ALTER SEQUENCE REVIEW_COMP_CHANGE_SEQUENCE INCREMENT BY 100;