Layton ServiceDesk - Troubleshooting - Outgoing Email Stops
(Added section "Bulk Delete") |
(Expanded section) |
||
Line 19: | Line 19: | ||
TRUNCATE TABLE [LaytonServiceDesk].[dbo].[mail] | TRUNCATE TABLE [LaytonServiceDesk].[dbo].[mail] | ||
− | If you are getting many failures, check the [[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|email settings]]. | + | =Many Failures= |
+ | If you are getting many outgoing failures, check the '''[[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|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, '''[[Layton ServiceDesk™ - Installation - Special Notes - Increase Service Startup Timeout|this remedy]]''' should fix it. | ||
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk™]] [[User Guide for Layton ServiceDesk™|<u>Back to Contents</u>]]</p> | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk™]] [[User Guide for Layton ServiceDesk™|<u>Back to Contents</u>]]</p> |
Revision as of 06:47, 3 October 2013
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.
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.