Answers
Subject Date - DESC Rating Viewed Topic
How do I configure IIS to forward all HTTP requests to HTTPS? 10/26/2016 11:29:17 AM None 1351 Site configuration
simple user login check for iService forms 2/4/2016 8:58:06 AM None 1310 Technical Support
Changing the Message Queue actions to the custom portal form 1/22/2016 5:40:23 PM None 1299 Technical Support
Updating the Message Queue page to the new version in 7.4 1/22/2016 5:24:29 PM None 1797 Site configuration
Making a form to display an interaction body or other details 8/27/2015 1:32:18 PM None 1421 Technical Support
Considerations when setting up a service account to run utilities 7/3/2015 4:51:20 PM None 2007 Batch Utility
Customer did not receive an iService email 8/7/2014 9:12:48 AM 4.0 1743 Technical Support
Updating agent count for on-premise installations 7/7/2014 11:59:40 AM 4.5 2349 Site configuration
How do I create a report subscription? 6/23/2014 11:26:47 AM None 2205 Reports
Disabling browser cache to force current data into your screen 6/13/2014 10:26:28 AM None 886 All Topics
Setting mailbox for reuse later 4/10/2014 9:57:12 AM None 1619 Technical Support
Chat interface is mistakenly displayed when I login using Internet Explorer 3/11/2014 9:57:20 AM None 1749 Technical Support
When I log in, I don't see the Message Queue tab 2/24/2014 11:56:11 AM 4.0 1792 Technical Support
Email not received by iService 1/16/2014 9:28:58 AM 4.0 2343 Email Processing
Article Selected >> Changing the mailbox specified for messages in SMTPout
Question:
I have messages sent via iService, but the mailbox they used is unavailable. As a result, the messages are going to retry and fail to be delivered. How can I change the mailbox that it will use after it has been marked as sent?
Answer:
Messages in the SMTPout table have a mailboxID that specifies the mail server to which they will be sent. You can run a SQL script to update this as follows.

Syntax:
update SmtpOut set mailboxID = NewMailboxID, timeSent = NULL where isSent = 0 and mailboxID = OldMailboxID

Example:
update SmtpOut set mailboxID = 22, timeSent = NULL where isSent = 0 and mailboxID = 1

In the example above, all messages that are not yet sent (isSent=0) that have a mailboxID of 1 will be changed to use mailboxID 22 instead.
Article DetailsSubscribe and Rate this article
Article ID:220542
Date Updated:9/5/2013 10:53:53 AM
# Views:2608
Article Creator:Scott Whitsitt
Article Topic:Email Processing
Attachments:-- None --
iService 5.x fails to load with the error "Unrecognized configuration section system.serviceModel in machine.config" 6/18/2013 3:31:05 PM None 1270 All Topics
Impact of iService On-demand on your IT department 5/21/2013 9:51:43 AM None 2641 Security
Creating an agent from an existing contact 3/26/2013 2:36:46 PM 4.0 2741 Security
Ensuring that SPAM contacts are not mislabeled and steps to correct 3/19/2013 3:22:32 PM None 1954 Technical Support
Setting message in SMTPOut for immediate delivery 2/25/2013 1:27:09 PM None 2812 Email Processing
JQuery Mobile and iService Forms 1/13/2013 1:24:26 PM None 2912 Customizing iService
Simple example for filtering messages to a new topic 12/18/2012 3:39:34 PM 5.0 2889 Site configuration
Lost password, administrator forwarding link 12/4/2012 8:48:19 AM 5.0 2004 Technical Support
iService Business Intelligence and Reports Documentation 8/1/2012 10:52:21 AM 4.0 2823 Reports
List of bookmarks/favorites to common tasks 4/7/2012 10:24:15 AM 4.0 2057 Technical Support
Please Wait...