08:33:36.010 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-12' as date) AND cast('2024-02-12' 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-12' as date) AND cast('2024-02-12' 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] 10:31:01.831 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(130521002241538117,130521002241538599,130621002241032002,130621002241032462,130621002241114273,130621002241115209,130621002241124194,130621002241347251,130621002241457166,130921002241418103,130531002241852505,130531002241947262,130531002242016490,130531002242143508,130531002242227283,130631002241706189,130631002241730412,130631002241755041,130631002241909518,130631002241918459,130631002241942135,130631002242002533,130631002242203515)[SQL: UPDATE lanetransactions SET ATTRIBUTE_4='' WHERE LaneTransactionNumber in(130521002241538117,130521002241538599,130621002241032002,130621002241032462,130621002241114273,130621002241115209,130621002241124194,130621002241347251,130621002241457166,130921002241418103,130531002241852505,130531002241947262,130531002242016490,130531002242143508,130531002242227283,130631002241706189,130631002241730412,130631002241755041,130631002241909518,130631002241918459,130631002241942135,130631002242002533,130631002242203515)]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] 16:28:24.333 Failed to load grid data of Re Cashup Declaration Check Validation page. Invalid user id of autorized person for re cashup [Login Info:: SH00397: Abdul Bodiyat] 16:28:35.304 Failed to load grid data of Re Cashup Declaration Check Validation page. Invalid user id of autorized person for re cashup [Login Info:: SH00397: Abdul Bodiyat]