08:14:41.964	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(130512302240035064,130622302240852014,130622302241015548,130622302241022294,130622302241110465,130622302241111267,130622302241407456,130622302241443570,130622302241445479,130622302241519007,130622302241541596,130722302240945136,130722302241014448,130722302241022233,130722302241212253,130722302241226328,130722302241232356,130922302241049218,130922302241057382,131022302241101593,130522302241310086,130522302241334318,130522302241338394,130522302241415001,130522302241512398,130532302241629355,130532302241737572,130532302241901527,130532302241959325,130532302242014187,130532302242207192,130632302241646185,130632302241708213,130632302241708463,130632302241714127,130632302241737011,130632302241755306,130632302241859570,130632302242031339,130632302242036384,130632302242203491,130632302242235549)[SQL: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(130512302240035064,130622302240852014,130622302241015548,130622302241022294,130622302241110465,130622302241111267,130622302241407456,130622302241443570,130622302241445479,130622302241519007,130622302241541596,130722302240945136,130722302241014448,130722302241022233,130722302241212253,130722302241226328,130722302241232356,130922302241049218,130922302241057382,131022302241101593,130522302241310086,130522302241334318,130522302241338394,130522302241415001,130522302241512398,130532302241629355,130532302241737572,130532302241901527,130532302241959325,130532302242014187,130532302242207192,130632302241646185,130632302241708213,130632302241708463,130632302241714127,130632302241737011,130632302241755306,130632302241859570,130632302242031339,130632302242036384,130632302242203491,130632302242235549)]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 D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadFastagExitTrxnController.cs:line 149 	[Login Info:: ADMIN: Administrator User]
18:19:04.235	Failed to load grid data of Uploaded SI Transaction page.  could not execute query
[ select  PaymentMeansID,  Description as PaymentMeans, sum(NotUploaded) as NotUploaded, sum(Uploaded) as Uploaded
                                                   from (
                                                   Select LT.PaymentMeansID, mppm.Description, CASE WHEN IFNULL(LT.LaneTransactionNumber,0)=LTU.LaneTransactionNumber THEN 0 ELSE 1 END as NotUploaded, (CASE WHEN IFNULL(LTU.LaneTransactionNumber,0)>0 THEN 1 ELSE 0 END) AS Uploaded
                                                   from lanetransactions LT
                                                   left join lanetransactionuploaded LTU on LT.LaneTransactionNumber=LTU.LaneTransactionNumber
                                                   LEFT JOIN mplazapaymentmeans mppm ON LT.PaymentMeansID = mppm.PaymentMeansID AND  mppm.ProjectTypeID = 2
                                                    Where  cast(LT.TDateTime as date) BETWEEN cast('2024-02-24' as date)  AND cast('2024-02-24' as date)  and (IFNULL(LT.AVCClassID,0) >0 or IFNULL(LT.TcClassID,0)>0) and LT.IsTCCancel=0 )temp group by PaymentMeansID,  Description order by PaymentMeansID asc ]
[SQL: select  PaymentMeansID,  Description as PaymentMeans, sum(NotUploaded) as NotUploaded, sum(Uploaded) as Uploaded
                                                   from (
                                                   Select LT.PaymentMeansID, mppm.Description, CASE WHEN IFNULL(LT.LaneTransactionNumber,0)=LTU.LaneTransactionNumber THEN 0 ELSE 1 END as NotUploaded, (CASE WHEN IFNULL(LTU.LaneTransactionNumber,0)>0 THEN 1 ELSE 0 END) AS Uploaded
                                                   from lanetransactions LT
                                                   left join lanetransactionuploaded LTU on LT.LaneTransactionNumber=LTU.LaneTransactionNumber
                                                   LEFT JOIN mplazapaymentmeans mppm ON LT.PaymentMeansID = mppm.PaymentMeansID AND  mppm.ProjectTypeID = 2
                                                    Where  cast(LT.TDateTime as date) BETWEEN cast('2024-02-24' as date)  AND cast('2024-02-24' as date)  and (IFNULL(LT.AVCClassID,0) >0 or IFNULL(LT.TcClassID,0)>0) and LT.IsTCCancel=0 )temp group by PaymentMeansID,  Description order by PaymentMeansID asc]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.EndOfStreamException: Attempted to read past the end of the stream.
   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.UploadSITrxnController.GetTrxnSummary(SearchTrxnSummry jsonData, String isRealTime, Int32 type) in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 143 	[Login Info:: ADMIN: Administrator User]