none
Database Mail Error RRS feed

  • Question

  • We are recieving a bunch of database mail failed messages from a job that no longer exists. We had a job set up about a year ago to send blocking alerts but we disabled and deleted that job. However we are still getting failed to send messages logged into sysmail_event_log. Why is this happening? Below is the error message. 

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2018-09-19T18:03:04). Exception Message: Cannot send mails to mail server. (A recipient must be specified.).  )

    A few minutes later we got an exception error that forced the Database Mail to shutdown by itself:

        1) Exception Information  ===================  Exception Type: System.Data.SqlClient.SqlException  Errors: System.Data.SqlClient.SqlErrorCollection  Class: 11  LineNumber: 0  Number: -2  Procedure:   Server: *******  State: 0  Source: .Net SqlClient Data Provider  ErrorCode: -2146232060  Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.  Data: System.Collections.ListDictionaryInternal  TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)  HelpLink: NULL    StackTrace Information  ===================     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.PostResponse(Response r, Guid convHandle)     at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.PostResponseIfNeeded(MailInfo mailInfo, Response response)     at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object obj)

        1) Exception Information  ===================  Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.NoQueueDataException  Message: Database Mail shutting down. Mail queue has been stopped.  Data: System.Collections.ListDictionaryInternal  TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.QueueItem GetQueueItemFromCommand(System.Data.SqlClient.SqlCommand)  HelpLink: NULL  Source: DatabaseMailEngine    StackTrace Information  ===================     at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.QueueDataReader.GetQueueItemFromCommand(SqlCommand c)     at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.QueueDataReader.GetQueueData(Int32 receiveTimeoutSec)     at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.GetDataFromQueue(DataAccessAdapter da, Int32 lifetimeMinimumSec)

    Friday, September 21, 2018 5:45 PM

All replies

  • sorry something doesnt sound right

    May be you've another job cloned from this job which has sent mail step

    Another reason can be an VM image created from your existing server when it had the job and it may still be exeuting within the image copy


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Friday, September 21, 2018 7:22 PM