Layton ServiceDesk - Troubleshooting - Outgoing Email Stops
m (Minor formatting changes) |
(Added section "Re-sending Failed Emails") |
||
| Line 13: | Line 13: | ||
4. Here you can see that the earliest email could not be sent. Click the Delete button for that email and confirm. The rest of the emails should now be sent. If not, you can delete the now-earliest. Don't delete more than three emails, as this could indicate a different issue, most likely a misconfiguration of '''[[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|email settings]]'''. | 4. Here you can see that the earliest email could not be sent. Click the Delete button for that email and confirm. The rest of the emails should now be sent. If not, you can delete the now-earliest. Don't delete more than three emails, as this could indicate a different issue, most likely a misconfiguration of '''[[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|email settings]]'''. | ||
| + | |||
| + | =Re-sending Failed Emails= | ||
| + | If your email server goes offline, once recovered, you may find that your Pending list contains failed emails. You can delete these or use this SQL query to change the status back to ''Pending'': | ||
| + | |||
| + | UPDATE [LaytonServiceDesk].[dbo].[mail]<br /> | ||
| + | SET sys_mail_tried = 0 | ||
| + | ,sys_mail_status = 'Pending' | ||
| + | ,sys_mail_lasttrytime = NULL | ||
=Bulk Delete= | =Bulk Delete= | ||
Revision as of 04:11, 16 January 2014
Contents |
Basic Remedy
Usually this is due to unusual characters in an email. If outgoing mail ever stops, here is the immediate remedy:
1. Go to Administration > System Settings > Email Server Settings.
2. Click the View Pending Outgoing Emails link.
3. A list of outgoing emails will appear:
4. Here you can see that the earliest email could not be sent. Click the Delete button for that email and confirm. The rest of the emails should now be sent. If not, you can delete the now-earliest. Don't delete more than three emails, as this could indicate a different issue, most likely a misconfiguration of email settings.
Re-sending Failed Emails
If your email server goes offline, once recovered, you may find that your Pending list contains failed emails. You can delete these or use this SQL query to change the status back to Pending:
UPDATE [LaytonServiceDesk].[dbo].[mail]
SET sys_mail_tried = 0 ,sys_mail_status = 'Pending' ,sys_mail_lasttrytime = NULL
Bulk Delete
If the list is full of failed emails, you can quickly eliminate all email with this SQL query:
TRUNCATE TABLE [LaytonServiceDesk].[dbo].[mail]
Many Failures
If you are getting many outgoing failures, check the email settings.
All Mail in Pending Status
If all or most of the outgoing emails have the status Pending, then most likely the LaytonServiceDesk service is not running, and if it's not running, you will probably find that you can't start it. If you get an error message related to a startup timeout, this remedy should fix it.
Microsoft Office 365
A Microsoft Office 365 user found that email was not being sent out when configured to use a third-party email server. Microsoft instructed him to use these settings:
