02:22:26.281 Failed to load grid data of GetLastUploadTrxnTime() Uploaded SI Transaction page. could not execute query [ Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1; ] [SQL: Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1;]MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: Connection timed out. ---> System.Net.Sockets.SocketException (110): Connection timed out at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) in /_/src/System.Net.Sockets/src/System/Net/Sockets/NetworkStream.cs:line 292 --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) in /_/src/System.Net.Sockets/src/System/Net/Sockets/NetworkStream.cs:line 298 at System.Net.Security.SslStream.FillBufferAsync[TReadAdapter](TReadAdapter adapter, Int32 minSize) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.Implementation.cs:line 1463 at System.Net.Security.SslStream.ReadAsyncInternal[TReadAdapter](TReadAdapter adapter, Memory`1 buffer) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.Implementation.cs:line 1439 at System.Net.Security.SslStream.Read(Byte[] buffer, Int32 offset, Int32 count) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.cs:line 753 at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at QuaLiX.TMS.Web.Areas.Validation.Controllers.UploadSITrxnController.GetLastUploadTrxnTime() in F:\WorkingProjects\TMS\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 563 [Login Info:: VALIDATOR: validator validator] 02:25:57.129 Failed to load grid data of GetLastUploadTrxnTime() Uploaded SI Transaction page. could not execute query [ Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1; ] [SQL: Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1;]MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: Connection timed out. ---> System.Net.Sockets.SocketException (110): Connection timed out at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) in /_/src/System.Net.Sockets/src/System/Net/Sockets/NetworkStream.cs:line 298 --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) in /_/src/System.Net.Sockets/src/System/Net/Sockets/NetworkStream.cs:line 298 at System.Net.Security.SslStream.FillBufferAsync[TReadAdapter](TReadAdapter adapter, Int32 minSize) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.Implementation.cs:line 1463 at System.Net.Security.SslStream.ReadAsyncInternal[TReadAdapter](TReadAdapter adapter, Memory`1 buffer) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.Implementation.cs:line 1439 at System.Net.Security.SslStream.Read(Byte[] buffer, Int32 offset, Int32 count) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.cs:line 753 at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at QuaLiX.TMS.Web.Areas.Validation.Controllers.UploadSITrxnController.GetLastUploadTrxnTime() in F:\WorkingProjects\TMS\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 563 [Login Info:: VALIDATOR: validator validator] 19:21:02.520 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:05.720 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:08.176 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:27.762 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:32.849 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:35.869 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:38.771 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:42.124 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:46.103 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:48.906 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:51.336 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:53.256 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:55.122 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:56.790 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:21:58.466 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:22:00.063 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:22:17.354 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:22:29.922 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:22:36.946 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:23:23.786 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:23:26.753 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:23:30.699 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:23:34.982 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:23:37.804 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:24:36.746 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:24:41.320 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:24:44.802 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:24:48.467 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:24:51.353 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:24:53.881 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:24:56.796 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:25:35.602 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:25:40.271 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:02.277 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:05.367 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:13.917 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:17.600 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:20.714 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:26.781 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:29.953 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:33.541 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:37.549 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:26:40.979 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:27:13.340 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:27:19.204 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:27:22.202 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:27:25.817 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:27:28.901 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:27:31.772 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:27:54.255 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:28:08.038 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:28:13.838 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:28:19.008 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:28:22.124 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:28:25.124 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 19:28:27.993 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ]