How to purge the outgoing email queue on RSA Via Lifecycle and Governance
2 years ago
Originally Published: 2016-04-20
Article Number
000067518
Applies To
RSA Product Set: Via Lifecycle & Governance
RSA Product/Service Type: Any
RSA Version/Condition: 6.9.1/7.0.0
Platform: Any
Issue
Many emails piled up in the outgoing email queue of the application due to any problem
Resolution
delete from T_EMAIL_LOG where PROCESS_ACTION IS NULL AND COMPLETED_TIME IS NULL;
commit;

delete from T_EMAIL_LOG where PROCESS_ACTION IS NULL AND COMPLETED_TIME IS NULL AND MESSAGE_DATA like '%<unique text in the email message>%';
Notes
From: ACM 691 P12 <acm691p12@vcloud.local>
To: test.user@vcloud.local
Message-ID: <AV-11-REF.1789840466.181461176392766.JavaMail.oracle@acm-691-p12.vcloud.local>
Subject: Test
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-Aveksa-Message-Reference: AV-11-REF

<html>
  <head>

  </head>
  <body>
    <p style="margin-top: 0">
      This is a test email
    </p>
  </body>
</html>