03:05:40.197 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 1449 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:: ADMIN1: Qualix ] 11:52:20.691 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:20.820 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:20.988 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:21.148 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:21.308 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:21.436 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:21.597 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:21.765 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:21.916 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:22.084 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:22.228 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:22.412 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:22.564 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:22.668 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:22.812 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:22.980 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:23.123 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:23.324 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:23.677 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:23.860 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:24.012 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:24.181 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:24.349 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:24.508 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:24.660 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:24.820 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:24.988 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:25.156 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:25.324 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:25.484 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:25.644 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:25.892 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:25.982 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:26.141 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:26.431 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:26.462 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:26.636 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:26.804 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:26.940 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:27.100 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:27.260 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:27.477 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:27.606 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:27.772 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:27.916 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:28.076 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:28.245 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:28.421 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:28.604 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:28.780 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:29.106 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:29.127 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:29.268 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:29.436 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:29.604 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:29.780 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:29.961 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:30.118 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 11:52:30.285 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:04:50.709 Failed to load grid data of Upload Fastag Exit Trxn page. could not execute native bulk manipulation query: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(1030630310241719087,1030630310241736351,1030630310241942414,1030630310242013182,1030520410240800553,1030520410240854044,1030520410240959066,1030520410241117554,1030520410241150216,1030520410241154205,1030520410241230236,1030520410241232035,1030520410241313189,1030520410241313350,1030520410241439232,1030520410241519343,1030820410241247504,1030720410240840564,1030720410240848018,1030720410241013479,1030620410240806298,1030720410241147285,1030720410241507169,1030720410241555583,1030730410241800043,1030730410241813584,1030730410241858458,1030730410242013271,1030630410241741553,1030630410241944163,1030630410242007143,1030630410242025543,1030630410242127574,1030530410241804527,1030530410241824323,1030530410241910366,1030530410242049510,1030830410242317518,1030710510240302013,1030720510241027115,1030720510241104325,1030720510241109423,1030720510241230410,1030620510241403581,1030520510240926253,1030520510241047305,1030520510241221275,1030520510241226002,1030820510241051533)[SQL: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(1030630310241719087,1030630310241736351,1030630310241942414,1030630310242013182,1030520410240800553,1030520410240854044,1030520410240959066,1030520410241117554,1030520410241150216,1030520410241154205,1030520410241230236,1030520410241232035,1030520410241313189,1030520410241313350,1030520410241439232,1030520410241519343,1030820410241247504,1030720410240840564,1030720410240848018,1030720410241013479,1030620410240806298,1030720410241147285,1030720410241507169,1030720410241555583,1030730410241800043,1030730410241813584,1030730410241858458,1030730410242013271,1030630410241741553,1030630410241944163,1030630410242007143,1030630410242025543,1030630410242127574,1030530410241804527,1030530410241824323,1030530410241910366,1030530410242049510,1030830410242317518,1030710510240302013,1030720510241027115,1030720510241104325,1030720510241109423,1030720510241230410,1030620510241403581,1030520510240926253,1030520510241047305,1030520510241221275,1030520510241226002,1030820510241051533)]MySql.Data.MySqlClient.MySqlException (0x80004005): Deadlock found when trying to get lock; try restarting transaction 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.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() at QuaLiX.TMS.Web.Areas.Validation.Controllers.UploadFastagExitTrxnController.UpdateFastagTransaction(String LTNumber, String newTransList, Int32 uploadAll) in F:\WorkingProjects\TMS\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadFastagExitTrxnController.cs:line 149 [Login Info:: ADMIN1: Qualix ] 14:06:14.948 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:15.096 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:15.257 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:15.424 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:15.593 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:15.761 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:15.921 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:16.089 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:16.249 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:16.400 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:16.585 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:16.745 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:16.930 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:17.096 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:17.272 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:17.441 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:17.608 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 14:06:17.776 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:42.159 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:42.310 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:42.454 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:42.611 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:42.763 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:42.909 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:43.061 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:43.194 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:43.342 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:43.499 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:43.642 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:43.803 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:43.947 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:44.116 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:44.265 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:44.434 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:44.594 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:44.760 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:44.909 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:56:45.077 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:07.988 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:08.145 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:08.318 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:08.475 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:08.628 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:08.788 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:08.941 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:09.108 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:09.260 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:09.428 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:09.587 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:09.772 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:09.917 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:10.088 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:10.250 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:10.419 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:10.577 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:10.738 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:10.905 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:11.099 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:11.241 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:11.441 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:11.834 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:12.005 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:12.422 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:12.826 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 17:57:13.123 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ]