00:14:46.072 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 594 [Login Info:: SH00554: Kiran Ahire] 09:43:56.272 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:43:58.826 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:01.213 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:05.219 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:06.667 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:08.250 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:10.306 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:11.754 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:13.442 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:14.650 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:15.592 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:16.718 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:18.417 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:30.067 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:32.898 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:36.419 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:37.946 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:39.275 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:40.579 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:42.147 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:43.539 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:44.642 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:45.962 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:46.818 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:47.963 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:49.202 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:50.066 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:50.955 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:51.843 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:52.827 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:54.011 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:44:57.388 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:01.587 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:03.894 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:03.979 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:05.635 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:06.804 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:08.082 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:09.387 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:10.779 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:12.291 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:13.651 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:14.795 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:16.092 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:17.283 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:18.307 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:19.771 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:20.795 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:21.771 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:22.691 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:23.803 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:25.747 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:27.300 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:28.563 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:29.476 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:30.403 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:31.379 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:32.627 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:35.267 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:37.011 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:40.379 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:41.667 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:42.667 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:43.707 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:45:45.132 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 09:49:12.000 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(1030620309241033079,1030620309241546595,1030620309241553409,1030520309241001461,1030520309241036441,1030520309241314310,1030520309241523237,1030520309241532400,1030720309241148222,1030720309241245152,1030630309241631083,1030630309241942293,1030630309241944425,1030630309242021566,1030630309242202189,1030630309242230485,1030530309242012106,1030530309242109116,1030730309241711489,1030510409240749390,1030620409240819148,1030620409240857246,1030620409240959122,1030620409241015350,1030520409241141468,1030620409241536364,1030520409241430171,1030630409242043103,1030630409242148019,1030630409242259388,1030530409241811457,1030530409241842458)[SQL: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(1030620309241033079,1030620309241546595,1030620309241553409,1030520309241001461,1030520309241036441,1030520309241314310,1030520309241523237,1030520309241532400,1030720309241148222,1030720309241245152,1030630309241631083,1030630309241942293,1030630309241944425,1030630309242021566,1030630309242202189,1030630309242230485,1030530309242012106,1030530309242109116,1030730309241711489,1030510409240749390,1030620409240819148,1030620409240857246,1030620409240959122,1030620409241015350,1030520409241141468,1030620409241536364,1030520409241430171,1030630409242043103,1030630409242148019,1030630409242259388,1030530409241811457,1030530409241842458)]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 ] 16:30:09.685 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:30:17.305 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:30:24.111 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:30:29.914 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:30:35.589 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:30:44.310 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:30:53.648 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:30:59.729 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:31:05.520 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:31:10.998 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:31:16.250 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:31:21.646 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:31:26.838 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:31:48.450 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:32:04.895 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:32:10.925 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:32:20.155 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:32:26.601 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:10.504 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:21.063 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:26.034 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:33.667 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:41.479 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:41.672 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:41.931 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:53.611 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:33:58.929 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:34:03.996 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:34:09.694 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:34:15.288 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:34:21.749 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:00.737 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:06.341 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:12.569 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:22.014 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:26.957 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:31.851 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:40.697 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:46.568 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:35:55.400 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:36:00.813 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:36:07.327 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:36:12.537 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:36:18.083 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:36:23.674 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:36:28.996 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ] 16:36:36.562 Failed to load grid data of Save successfully. page. [Login Info:: ADMIN1: Qualix ]