Timeout importing mail
Problem reported by Aleksey Permyakov - October 8, 2015 at 6:19 AM
Submitted
In Errors log I can see a lot of timeouts while importing mail messages:
 
=====================
[2015-10-08 11:21:01 AM]
Agent: N/A

Exception in the Ticket Watcher Thread Process
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at SmarterTrack.Data.EntityBase.GetListFromQueryInternal[T](IDbConnection& connection, String query, IDbDataParameter[] parameters)
   at SmarterTrack.Data.EntityBase.GetListFromQueryInternal[T](String query, IDbDataParameter[] parameters)
   at SmarterTrack.Data.TicketEntity.GetQueuedTickets(Int32 groupid, Boolean includeClosed)
   at SmarterTrack.HelperClasses.Threads.Processes.TicketWatcherProcess.#eMc()
   at SmarterTrack.HelperClasses.Threads.Processes.TicketWatcherProcess.DoWork()
ClientConnectionId:963230cd-97d7-4e41-b65d-eb618d36b541
Error Number:-2,State:0,Class:11


=====================
[2015-10-08 1:26:17 PM]
Agent: N/A

Could not import downloaded message D:\Users\st\App_Data\Spool\IN-1\d10fd62b725846bc8c26d3ab198f5ae0.eml - Moved to In-Failed folder


=====================
[2015-10-08 1:47:39 PM]
Agent: N/A

Auto Purge Deleted Thread error detected
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelperInternal.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at SmarterTrack.Data.DataLayerShortcut.ExecuteNonQuery(IDbConnection& conn, String query, SqlParameter[] parameters)
   at SmarterTrack.HelperClasses.Threads.AutoPurgeDeletedThread.#0zc()
   at SmarterTrack.HelperClasses.Threads.AutoPurgeDeletedThread.#Zzc()
   at SmarterTrack.HelperClasses.Threads.AutoPurgeDeletedThread.DoWork()
ClientConnectionId:e012fe33-bf15-40ca-a7a3-1f397a272a97
Error Number:-2,State:0,Class:11
Using SmarterTrack 9.5 (latest version) with SQL Server 2012.
 
What can be a reason?

Reply to Thread