08:40:32.310 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.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] 08:42:47.433 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] 09:43:51.283 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:43:58.934 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:04.477 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:11.635 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:18.521 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:23.242 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:27.644 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:32.660 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:37.943 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:42.784 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:48.406 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:53.991 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:59.890 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:08.263 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:08.360 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:13.393 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:19.380 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:29.577 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:35.822 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:42.137 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:12.305 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:18.997 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:24.686 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:26.226 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:26.248 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:26.678 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:26.701 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:26.727 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:27.006 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:27.031 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:27.159 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:27.824 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:27.863 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:27.914 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:30.119 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.208 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.233 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.257 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.278 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.872 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.885 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.895 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.904 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.913 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.922 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.931 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.939 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.947 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.957 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.966 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.974 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.984 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:31.992 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:32.003 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.035 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.052 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.100 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.109 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.120 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.134 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.590 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.903 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.959 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:34.997 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:36.551 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:36.575 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:36.719 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:37.087 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:37.366 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:37.377 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:37.436 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:37.611 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:38.102 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:38.112 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:38.227 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:41.252 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:41.548 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:41.557 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:46:41.570 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:08.989 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.204 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.217 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.235 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.253 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.621 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.635 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.659 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.668 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.680 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.692 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.704 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.714 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.725 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.735 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.743 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.753 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:47:10.761 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:05.407 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:05.692 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:05.721 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:05.893 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:06.091 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:07.538 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:07.569 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:07.928 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:08.411 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:08.444 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:08.632 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:08.836 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:09.255 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:09.291 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:09.443 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:09.629 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:10.009 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:10.040 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:17.113 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:17.140 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:17.308 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:17.487 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:17.882 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:17.897 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:18.093 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:18.290 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:18.703 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:48:18.732 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:49:31.639 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:49:38.077 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:49:42.597 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:49:47.219 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:49:52.025 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:49:57.581 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:50:04.120 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 12:40:22.148 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 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.ListIgnoreQueryCache(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:: ADMIN1: Qualix ] 12:41:20.264 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 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.ListIgnoreQueryCache(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:: ADMIN1: Qualix ] 15:19:33.068 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 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.ListIgnoreQueryCache(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:: ADMIN1: Qualix ] 15:44:47.820 Failed to load grid data of SI Audit Transactions page. could not execute query [ select ProjectID,PlazaID,ID, HTransactionNumber,LaneTransactionNumber,VehicleNumber VehicleNumber,LaneID,TDateTime,ShiftID,ShiftsType,ClassName,AVCClassName,WimClassName,TcClassID,AVCClassID,PaymentMeansID,PaymentMeans,TotalPaidAmount,WIMPaidAmt,TCUserID,Simulation ,IsOverloaded,CONCAT('Lane ',LaneID ) as Lane,OperationShiftNumber,WimAmount,IsOverloaded,IsSWB ,IsAudited,AuditMode,FastagTransactionNumber,PMethodID,LaneDirectionID,CardID,DateTime, TagClass, TCSubClassID, AVCSubClassID,ManualTxn from vw_ValidateTransactionDetails Where cast(TDateTime as date) BETWEEN cast('2024-09-04 15:41:41' as date) AND cast('2024-09-04 15:41:41' as date) and IFNULL(IsAuditCancel,0)=0 and IFNULL(IsAudited,0)=0 and AuditDateTime is null and IFNULL(IsFakeViolation,0)!=1 and PlazaID=3 and ProjectID=1 And ShiftID IN (2) order by TDateTime desc ] [SQL: select ProjectID,PlazaID,ID, HTransactionNumber,LaneTransactionNumber,VehicleNumber VehicleNumber,LaneID,TDateTime,ShiftID,ShiftsType,ClassName,AVCClassName,WimClassName,TcClassID,AVCClassID,PaymentMeansID,PaymentMeans,TotalPaidAmount,WIMPaidAmt,TCUserID,Simulation ,IsOverloaded,CONCAT('Lane ',LaneID ) as Lane,OperationShiftNumber,WimAmount,IsOverloaded,IsSWB ,IsAudited,AuditMode,FastagTransactionNumber,PMethodID,LaneDirectionID,CardID,DateTime, TagClass, TCSubClassID, AVCSubClassID,ManualTxn from vw_ValidateTransactionDetails Where cast(TDateTime as date) BETWEEN cast('2024-09-04 15:41:41' as date) AND cast('2024-09-04 15:41:41' as date) and IFNULL(IsAuditCancel,0)=0 and IFNULL(IsAudited,0)=0 and AuditDateTime is null and IFNULL(IsFakeViolation,0)!=1 and PlazaID=3 and ProjectID=1 And ShiftID IN (2) order by TDateTime desc]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 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.ListIgnoreQueryCache(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[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List[T]() at QuaLiX.TMS.Web.Areas.Validation.Controllers.SIAuditController.GetGridList(TransactionSearchMultiSelection jsonData, String isRealTime, Int32 isSwb) in F:\WorkingProjects\TMS\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\SIAuditController.cs:line 238 [Login Info:: VALIDATOR: validator validator]