Answers
Subject Date - DESC Rating Viewed Topic
Email not received by iService 1/16/2014 9:28:58 AM 4.0 2790 Email Processing
Changing the mailbox specified for messages in SMTPout 9/5/2013 10:53:53 AM None 3015 Email Processing
Setting message in SMTPOut for immediate delivery 2/25/2013 1:27:09 PM None 3632 Email Processing
Forward Email to External Email Address - Exchange 2003 2/7/2011 4:03:12 PM None 2305 Email Processing
Testing your SMTP connection 12/10/2010 4:43:56 PM 4.0 2300 Email Processing
Article Selected >> Setting pending messages as Sent within iService
Question:
How can I mark messages that are pending to be sent by iService to be ignored. For instance, if we have created a reply to a customer but it has an issue and can't be processed, how do we get rid of it?
Answer:
iService has an SMTPOut table that holds all messages waiting to be delivered. Each outbound message has an isSent attribute that tells you whether it has been passed on to an SMTP server for delivery to the end user. If the isSent value is 0 or False, then it is waiting to be processed. Once the message is processed the value will be set to 1 or True.

Because of the transactional nature of the iService database, messages which fail to send that cause crashes fail to have their isSent or TimeSent flags set. This means that some types of failures will continue to be repeated because they continue to be considered the "Next" message to be sent for each iteration of the SMTP Processing cycle. Because of this, most often it is the SMTPOUT entry with the lowest ID number that has an isSent flag equal to 0 and a TimeSent of NULL.

**UPDATE: Version 5.10 and Later**
You can now resolve these messages from the Admin Tools>SMTPOut tab within iService.



You can manually update these records using the following query. Please note, this should only be done by a systems administrator and only in extreme cases when you need to override the processing of a message.

You can get a list of all pending message IDs that have not been processed by using the following query.

Select * from SmtpOut where isSent=0 and TimeSent is NULL order by ID

To update the pending message from unsent to sent, use the following query.

Update SmtpOut Set isSent=1 Where ID = #

If you know the InteractionID of the agent response, you can use the following query to update the corresponding SMTPOut record from a single query.

UPDATE SmtpOut SET isSent=1
WHERE ID IN (SELECT smtpMessageID FROM InteractionsResponses WHERE interactionID=123)

In the above example, replace the 123 with the InteractionID of the agent response.

Article DetailsSubscribe and Rate this article
Article ID:61272
Date Updated:9/7/2010 1:17:41 PM
# Views:2403
Article Creator:Scott Whitsitt
Article Topic:Email Processing
Attachments:-- None --
Message received with a blank body 7/27/2010 3:27:17 PM 5.0 2166 Email Processing
Techniques for minimizing bounced emails 7/1/2010 9:55:45 PM 5.0 2522 Email Processing
Capturing the bounce reason from undeliverable messages 7/1/2010 5:06:59 PM None 2204 Email Processing
Options for the From email address 5/26/2010 12:38:19 PM None 2135 Email Processing
Email not leaving iService 5/19/2010 8:11:26 AM None 2065 Email Processing
Please Wait...