Email Stuck in Outbox

Email Stuck in Outbox

Issue:

I have an email stuck in my outbox

Resolution:

If you want to close out a pending email that is being sent but is stuck due to SMTP errors, you need to execute this script in SQL and delete it in the user's outbox in redis.

 update CTEmail.dbo.Email
 set InProcess = 0
 where emailid = 1038239

It should synchronize with redis eventually, but to force the issue you can remove the CTS.email.outbox.1.<userID> 



If the customer had an smtp issue and emails were needing to be sent out after their fix of SMTP side, you would need to run the below query. This script will set the sent count to 0 which means the email service will try to send it out again. The email service has a max send attempt config so if it reaches that max amount, that is the reason for needing to reinitialize the email send process. 

 update CTEmail.dbo.Email
 set sentcount =0 
 where inprocess = 1

    • Related Articles

    • Release notes v3.2

      Upgrade Path Based on the version currently installed, your system may need incremental upgrades to your system before you finalize on version 3.2.67 The following table illustrates the upgrade path required, depending on your current version. If you ...

    • Release notes v3.2 SP1

      The CTS 3.2 SP1 is a cumulative release that includes fixes, enhancements and updates:   Fixes: 1465  - Outbound Call List Contacts Loaded redis entry not showing correct loaded contacts 1405 - Issue with Attachments getting corrupted 1468 - Email ...

    • Auto-Close configuration is not working

      Problem:  A customer configured auto-close criteria but does not appear to be working. The issue was due to the leading spaces in the configuration that makes the subject not match and never closed the email. Resolution: In the older version of CT ...

    • Release notes v3.3

      Upgrade Path Based on the version currently installed, your system may need incremental upgrades to your system before you finalize on version 3.3.0 The following table illustrates the upgrade path required, depending on your current version. If you ...

    • CT Suite for Amazon Connect V 4.0.5

      These changes are not service impacting to agents. The planned installation date is 2/3/2021. Issues addressed in this version: Issue Number Issue Title Description 3T1-I380 No DTMF tone feedback The CT Suite softphone doesn't play the DTMF tones ...