DatabaseMail90.exe closes after error

• robert 90370

  SSC Rookie

  Points: 37

  More actions

  April 8, 2014 at 4:03 pm

  #285543

  We have been using databasemail now for a few weeks, everything has been running well until 2am on the 5th April when we got an error logged that stopped our mail being sent. We had 85,000 emails in the queue but were not being sent. I was able to find that DatabaseMail90.exe had ceased to run so I had to open the program manually mail then started to be sent again. The problem I have now is that the DatabaseMail90.exe is being closed on a regular basis with the following error, can anyone help in what I need to do to fix it.

  Thanks in advance, Robert

  1) Exception Information

  ===================

  Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

  Message: There was an error on the connection. Reason: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

  Data: System.Collections.ListDictionaryInternal

  TargetSite: Void OpenConnection(Microsoft.SqlServer.Management.Common.SqlConnectionInfo)

  HelpLink: NULL

  Source: DatabaseMailEngine

  StackTrace Information

  ===================

  at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.OpenConnection(SqlConnectionInfo ci)

  at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.OpenConnection(String dbServerName, String dbName, String userName, String password)

  at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.ProcessQueueItems(String dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel loggingLevel)

  2) Exception Information

  ===================

  Exception Type: System.Data.SqlClient.SqlException

  Errors: System.Data.SqlClient.SqlErrorCollection

  Class: 11

  LineNumber: 0

  Number: -2

  Procedure:

  Server: xxxx

  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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

  at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

  at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)

  at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()

  at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)

  at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

  at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

  at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

  at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

  at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

  at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

  at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

  at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

  at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

  at System.Data.SqlClient.SqlConnection.Open()

  at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.OpenConnection(SqlConnectionInfo ci)