Many timeouts in error log
Problem reported by Aleksey Permyakov - August 3, 2015 at 5:15 AM
Submitted
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.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   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.#Juh()
   at SmarterTrack.HelperClasses.Threads.AutoPurgeDeletedThread.#Iuh()
   at SmarterTrack.HelperClasses.Threads.AutoPurgeDeletedThread.DoWork()
 
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.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   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.TicketTimingEntity.GetMostRecentByTicketID(Int32 ticketID)
   at SmarterTrack.Data.TicketTimingEntity.SetCurrentStatus(IDbConnection& connection, TicketEntity ticket, Boolean CountInResponseTime, Boolean CountInInitialResponseTime)
   at SmarterTrack.Data.TicketEntity.Save(IDbConnection& connection, Int32 userDoingAction, InterfaceUsedTypes interfaceType, Dictionary`2 customFields, Boolean useCache)
   at SmarterTrack.Business.Tickets.TicketAssignments.AssignTicket(IDbConnection& connection, TicketEntity ticket, Int32 departmentId, Int32 groupId, Int32 userId, Int32 userIdDoingAction, InterfaceUsedTypes interfaceType)
   at SmarterTrack.Business.Tickets.TicketAssignments.AssignTicket(TicketEntity ticket, Int32 departmentId, Int32 groupId, Int32 userId, Int32 userIdDoingAction, InterfaceUsedTypes interfaceType)
   at SmarterTrack.HelperClasses.Threads.Processes.TicketWatcherProcess.#1wb()
   at SmarterTrack.HelperClasses.Threads.Processes.TicketWatcherProcess.DoWork()
 
And similar. Is there something wrong with SQL Server?
 

Reply to Thread