00:17:48.112	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
                            from vw_ValidateTransactionDetails Where  cast(TDateTime as date) BETWEEN cast('2023-01-22 00:14:35' as date)  AND cast('2023-01-22 00:14:35' as date) and IsAuditCancel=0 and IsAudited=0 and AuditDateTime is  null and IsFakeViolation!=1 and PlazaID=3 and ProjectID=1   And IsTCCancel =1 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
                            from vw_ValidateTransactionDetails Where  cast(TDateTime as date) BETWEEN cast('2023-01-22 00:14:35' as date)  AND cast('2023-01-22 00:14:35' as date) and IsAuditCancel=0 and IsAudited=0 and AuditDateTime is  null and IsFakeViolation!=1 and PlazaID=3 and ProjectID=1   And IsTCCancel =1 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) 	[Login Info:: ADMIN: Administrator User]