000033043 - Users receiving emails for a deleted review result in RSA Via Lifecycle and Governance

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033043
Applies ToRSA Product Set:  Via Lifecycle and Governance
RSA Version/Condition: All
IssueEmails 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.
User-added image
CauseThe review result may not have been deleted properly and become stuck in the In Delete state.  The cause may be unknown.
  1. Execute the query below as avuser [database user]. Login using SQL Developer or execute through the sqlplus utility with the command sqlplus username/password.
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.

  1. Copy the value of the name column from the resulted output then execute the following:
UPDATE t_av_reviews SET state ='I' WHERE name ='<name column value copied in previous step>';

  1. State=I will put the the review result in the On Hold state so it will appear in the UI.
  2. Once the review result is available in UI, you can delete it gracefully from UI.
  3. Check Admin > Monitoring tab to see if the review is deleted.