02:27:18.534 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] 02:27:54.823 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] 05:58:56.870 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 05:59:04.913 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 05:59:11.570 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 05:59:18.919 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 05:59:26.236 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 05:59:34.563 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 05:59:42.695 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 05:59:49.640 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 05:59:55.286 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:00:03.917 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:00:10.521 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:00:17.245 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:00:24.688 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:00:30.953 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:00:38.555 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:00:44.803 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:00:51.210 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:01:12.899 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:01:19.885 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:01:27.850 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:01:34.123 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:01:40.760 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:01:49.599 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:01:57.948 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:02:31.096 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:02:38.617 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:02:45.039 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:02:51.917 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:02:58.102 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:03:05.703 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:03:11.972 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:03:19.147 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:03:38.008 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:03:51.247 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:03:58.278 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:04:05.210 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:04:12.860 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:04:19.191 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:04:25.273 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:04:37.705 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:04:44.246 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:04:50.249 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:04:56.031 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:05:01.683 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:05:07.581 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:05:12.722 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:05:20.276 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:05:25.389 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:05:33.135 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:05:38.517 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:05:43.321 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 06:06:12.635 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:21:26.279 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:21:31.224 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:21:38.912 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:21:54.796 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:00.431 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:07.072 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:12.161 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:16.442 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:20.800 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:25.348 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:30.249 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:34.578 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:38.780 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:44.748 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:50.488 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:22:54.722 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:00.444 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:05.784 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:10.786 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:15.235 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:20.435 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:38.812 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:46.362 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:51.620 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:23:56.424 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:01.293 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:05.911 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:10.766 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:17.135 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:23.836 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:29.736 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:34.234 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:39.863 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:47.281 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:51.375 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:24:56.097 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:00.173 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:04.305 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:08.435 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:14.842 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:21.196 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:25.442 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:30.009 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:35.921 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:41.149 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:47.032 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:51.968 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 07:25:57.289 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:05:02.668 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:10:25.868 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:10:33.831 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:10:41.601 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:10:47.133 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:10:52.767 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:10:58.551 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:11:09.049 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:11:15.808 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:11:22.859 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:11:29.366 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:11:36.412 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:11:43.150 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:11:52.212 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:11:58.374 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:03.279 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:08.299 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:14.545 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:20.392 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:25.656 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:35.331 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:41.316 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:51.086 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:12:58.961 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:05.045 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:11.153 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:17.409 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:22.633 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:28.451 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:32.761 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:38.527 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:44.567 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:50.119 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:13:54.983 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:14:01.274 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:14:06.381 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:14:12.370 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:14:19.617 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:14:37.820 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:14:43.375 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:14:49.664 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:14:55.143 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:15:00.284 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:15:09.393 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:15:11.246 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:15:17.169 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:15:24.218 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:15:29.178 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:15:35.217 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:15:41.426 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 20:43:39.015 Failed to load grid data of Failed to Get Grid Data of Review Transactions page. could not execute query [ select ProjectID,PlazaID,ID, HTransactionNumber,LaneTransactionNumber,VehicleNumber,LaneID,TDateTime,ShiftID, ShiftsType,ClassName,AVCClassName,AuditClass,WimClassName,TcClassID,AVCClassID,PaymentMeansID,PaymentMeans,TotalPaidAmount,WIMPaidAmt,TCUserID,Simulation,IsOverloaded, CONCAT('Lane ',LaneID ) as Lane,OperationShiftNumber,WimAmount,IsOverloaded,IsSWB,IsAudited,AuditMode,IsFakeViolation,FastagTransactionNumber,PMethodID,AuditDateTime, LaneDirectionID,CardID,DateTime,ADateTime,AuditUser, TagClass, AuditPaymentMeans,IsAuditorAccepted,IsSI,ISRevertTrue from vw_ValidateTransactionDetails Where cast(TDateTime as date) BETWEEN cast('2024-09-03' as date) AND cast('2024-09-03' as date) and IFNULL(IsAudited,0)=1 and AuditDateTime is not null and PlazaID=3 and ProjectID=1 And VehicleNumber ='HR33BK2156' order by DateTime desc ] [SQL: select ProjectID,PlazaID,ID, HTransactionNumber,LaneTransactionNumber,VehicleNumber,LaneID,TDateTime,ShiftID, ShiftsType,ClassName,AVCClassName,AuditClass,WimClassName,TcClassID,AVCClassID,PaymentMeansID,PaymentMeans,TotalPaidAmount,WIMPaidAmt,TCUserID,Simulation,IsOverloaded, CONCAT('Lane ',LaneID ) as Lane,OperationShiftNumber,WimAmount,IsOverloaded,IsSWB,IsAudited,AuditMode,IsFakeViolation,FastagTransactionNumber,PMethodID,AuditDateTime, LaneDirectionID,CardID,DateTime,ADateTime,AuditUser, TagClass, AuditPaymentMeans,IsAuditorAccepted,IsSI,ISRevertTrue from vw_ValidateTransactionDetails Where cast(TDateTime as date) BETWEEN cast('2024-09-03' as date) AND cast('2024-09-03' as date) and IFNULL(IsAudited,0)=1 and AuditDateTime is not null and PlazaID=3 and ProjectID=1 And VehicleNumber ='HR33BK2156' order by DateTime 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.SIReviewController.GetReviewGridList(TransactionSearch jsonData, String isRealTime, String DateType, Int32 isSwb) in F:\WorkingProjects\TMS\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\SIReviewController.cs:line 307 [Login Info:: VALIDATOR: validator validator] 20:46:38.275 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-03 20:43:32' as date) AND cast('2024-09-03 20:43:32' 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 (3) And PaymentMeansID in('14') 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-03 20:43:32' as date) AND cast('2024-09-03 20:43:32' 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 (3) And PaymentMeansID in('14') 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]