Layton ServiceDesk - Troubleshooting - Outgoing Email Stops

From Layton Support
(Difference between revisions)
Jump to: navigation, search
(New page)
 
(Added section "Bulk Delete")
Line 1: Line 1:
 +
=Basic Remedy=
 
Usually this is due to unusual characters in an email. If outgoing mail ever stops, here is the immediate remedy:
 
Usually this is due to unusual characters in an email. If outgoing mail ever stops, here is the immediate remedy:
  
Line 12: 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]].
 +
 +
=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]
 +
 +
If you are getting many failures, check the [[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|email settings]].
 
<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 05:32, 30 September 2013

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:


Lsd email outgoing failure.png


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]

If you are getting many failures, check the email settings.

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox