1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Database Mail - Queued but not delivered

Monday, 01 October 2012 22:00

Written by Prakash Palani

Print E-mail

Database Mail was not getting delivered after applying service pack 4 in MS SQL Server

Step 1 :

select * from dbo.sysmail_event_log

Step 2 :

Check description field for the error Text

Step 3 :

Below error message was thrown in our case.

1) Exception Information  ===================  Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException  Message: Mail configuration information could not be read from the database.  Data: System.Collections.ListDictionaryInternal  TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)  HelpLink: NULL  Source: DatabaseMailEngine    StackTrace Information  ===================     at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)     at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)     at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)     at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)    2) Exception Information  ===================  Exception Type: System.IndexOutOfRangeException  Message: timeout  Data: System.Collections.ListDictionaryInternal  TargetSite: Int32 GetOrdinal(System.String)  HelpLink: NULL  Source: System.Data    StackTrace Information  ===================     at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)     at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)     at System.Data.SqlClient.SqlDataReader.get_Item(String name)     at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)

Solution :

Option 1 : http://support.microsoft.com/kb/2008286

Option 2: If your SQL server version is of advanced version than the one mentioned in KB article, then please follow the

Follow this URL and create the stored procedure as mentioned in the note.

http://sistemas-microsoft.blogspot.nl/2011/12/database-mail-stopped-working-after.html

 

Database Mail - Queued but not delivered