0 : System.Data.SqlClient.SqlException (0x80131904): Execution 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadUInt32(UInt32& value) at System.Data.SqlClient.TdsParserStateObject.TryReadPlpLength(Boolean returnPlpNullIfNull, UInt64& lengthLeft) at System.Data.SqlClient.TdsParser.TryReadPlpUnicodeChars(Char[]& buff, Int32 offst, Int32 len, TdsParserStateObject stateObj, Int32& totalCharsRead) at System.Data.SqlClient.TdsParser.TryReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TryReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj, SqlCommandColumnEncryptionSetting columnEncryptionOverride, String columnName) at System.Data.SqlClient.SqlDataReader.TryReadColumnData() at System.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly) at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn) at System.Data.SqlClient.SqlDataReader.GetString(Int32 i) at lambda_method(Closure , Shaper ) at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.HandleEntityAppendOnly[TEntity](Func`2 constructEntityDelegate, EntityKey entityKey, EntitySet entitySet) at lambda_method(Closure , Shaper ) at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper) at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext() at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at RetailCamControlPanel.Infrastructure.RepositoryBase`1.GetMany(Expression`1 where) in D:\Project\FFC-RCCP\RetailCamControlPanel\Infrastructure\RepositoryBase.cs:line 86 at RetailCamControlPanel.Services.SingularService.FFServerService.GetFFServers(Expression`1 where) in D:\Project\FFC-RCCP\RetailCamControlPanel\Services\SingularService\FFServerService.cs:line 80 at RetailCamControlPanel.Controllers.FootfallCamController.GetCounterHealthCheckAnalytic(FPAPFilterObject fpapObject, CounterHealthCheckFilterObject counterHealthCheckFilterObj, VerificationFilterObject selectedVerificationFilter, VerificationToDoObject selectedVerificationToDoFilter, String reportToView, String sDate, String searchTerm, Int32 nDays, String server, String sort, String order, String sort2, String order2, Boolean isAPI, Boolean getLite, Int32 page, Boolean isShowAllCounter, String serial) in D:\Project\FFC-RCCP\RetailCamControlPanel\Controllers\FootfallCamController.cs:line 20419 ClientConnectionId:1f442776-135a-4a5d-8bda-fd88d8093f39 Error Number:-2,State:0,Class:11 { "Errors": [ { "Source": ".Net SqlClient Data Provider", "Number": -2, "State": 0, "Class": 11, "Server": "51.255.82.36", "Message": "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.", "Procedure": "", "LineNumber": 0 } ], "ClientConnectionId": "1f442776-135a-4a5d-8bda-fd88d8093f39", "ClassName": "System.Data.SqlClient.SqlException", "Message": "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.", "Data": { "HelpLink.ProdName": "Microsoft SQL Server", "HelpLink.EvtSrc": "MSSQLServer", "HelpLink.EvtID": "-2", "HelpLink.BaseHelpUrl": "http://go.microsoft.com/fwlink", "HelpLink.LinkId": "20476" }, "InnerException": { "NativeErrorCode": 258, "ClassName": "System.ComponentModel.Win32Exception", "Message": "The wait operation timed out", "Data": null, "InnerException": null, "HelpURL": null, "StackTraceString": null, "RemoteStackTraceString": null, "RemoteStackIndex": 0, "ExceptionMethod": null, "HResult": -2147467259, "Source": null, "WatsonBuckets": null }, "HelpURL": null, "StackTraceString": " at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)\r\n at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()\r\n at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()\r\n at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()\r\n at System.Data.SqlClient.TdsParserStateObject.TryReadUInt32(UInt32& value)\r\n at System.Data.SqlClient.TdsParserStateObject.TryReadPlpLength(Boolean returnPlpNullIfNull, UInt64& lengthLeft)\r\n at System.Data.SqlClient.TdsParser.TryReadPlpUnicodeChars(Char[]& buff, Int32 offst, Int32 len, TdsParserStateObject stateObj, Int32& totalCharsRead)\r\n at System.Data.SqlClient.TdsParser.TryReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)\r\n at System.Data.SqlClient.TdsParser.TryReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj, SqlCommandColumnEncryptionSetting columnEncryptionOverride, String columnName)\r\n at System.Data.SqlClient.SqlDataReader.TryReadColumnData()\r\n at System.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly)\r\n at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)\r\n at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)\r\n at lambda_method(Closure , Shaper )\r\n at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.HandleEntityAppendOnly[TEntity](Func`2 constructEntityDelegate, EntityKey entityKey, EntitySet entitySet)\r\n at lambda_method(Closure , Shaper )\r\n at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)\r\n at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()\r\n at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()\r\n at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n at RetailCamControlPanel.Infrastructure.RepositoryBase`1.GetMany(Expression`1 where) in D:\\Project\\FFC-RCCP\\RetailCamControlPanel\\Infrastructure\\RepositoryBase.cs:line 86\r\n at RetailCamControlPanel.Services.SingularService.FFServerService.GetFFServers(Expression`1 where) in D:\\Project\\FFC-RCCP\\RetailCamControlPanel\\Services\\SingularService\\FFServerService.cs:line 80\r\n at RetailCamControlPanel.Controllers.FootfallCamController.GetCounterHealthCheckAnalytic(FPAPFilterObject fpapObject, CounterHealthCheckFilterObject counterHealthCheckFilterObj, VerificationFilterObject selectedVerificationFilter, VerificationToDoObject selectedVerificationToDoFilter, String reportToView, String sDate, String searchTerm, Int32 nDays, String server, String sort, String order, String sort2, String order2, Boolean isAPI, Boolean getLite, Int32 page, Boolean isShowAllCounter, String serial) in D:\\Project\\FFC-RCCP\\RetailCamControlPanel\\Controllers\\FootfallCamController.cs:line 20419", "RemoteStackTraceString": null, "RemoteStackIndex": 0, "ExceptionMethod": "8\nOnError\nSystem.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\nSystem.Data.SqlClient.SqlInternalConnection\nVoid OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])", "HResult": -2146232060, "Source": ".Net SqlClient Data Provider", "WatsonBuckets": null }