|Applies To||RSA Product Set: Via Lifecycle and Governance|
RSA Version/Condition: All
|Issue||Emails are being sent for a deleted review result .The review result is not available in UI. When you check the database table t_av_reviews you will find the review result as active. When you click on the one of the emails sent from the deleted review in Admin > Email, you will find the review state marked as In Delete.|
|Cause||The review result may not have been deleted properly and become stuck in the In Delete state. The cause may be unknown.|
SELECT * FROM t_av_reviews WHERE state ='A';
This query will output the review result which is stuck in the In Delete state. State A corresponds to the review being in the In Delete state.
UPDATE t_av_reviews SET state ='I' WHERE name ='<name column value copied in previous step>';