10:28:14.709 Failed to load grid data of Review Violation Transaction page. could not execute query [ SELECT FTA.ProjectID, FTA.PlazaID, FTA.FastagTransactionNumber, FTA.AVCTransactionNumber, FTA.LaneTransactionNumber, date_format(FTA.DATETIME,'%d/%m/%Y %H:%i:%s') as TrxnDateTime, FTA.CARDID, FTA.PLATENUMBER, FTA.LANEID, FTA.IsVIOLATION, FTA.AuditDATETIME, date_format(FTA.AuditDATETIME,'%d/%m/%Y %H:%i:%s') as AdDateTime, FTA.NoOfAxle, FTA.DoubleWheelDetected, FTA.VehicleLength, FTA.VehicleHeight, FTA.InterAxleDistance, FTA.TcClassID, MPPM.QCLASSSubDesc AS TCClass, FTA.AVCClassID, AV.ShortDescription AS AVCClass FROM FastagAuditTransaction FTA LEFT JOIN mclasses AV ON FTA.AVCClassID = AV.ClassID LEFT JOIN mplazamappingclass MPPM ON FTA.TcClassID = MPPM.NPCIClass WHERE DATETIME BETWEEN '2022-09-30 ' AND '2022-09-30 ' AND FTR.PlazaID=3 ] [SQL: SELECT FTA.ProjectID, FTA.PlazaID, FTA.FastagTransactionNumber, FTA.AVCTransactionNumber, FTA.LaneTransactionNumber, date_format(FTA.DATETIME,'%d/%m/%Y %H:%i:%s') as TrxnDateTime, FTA.CARDID, FTA.PLATENUMBER, FTA.LANEID, FTA.IsVIOLATION, FTA.AuditDATETIME, date_format(FTA.AuditDATETIME,'%d/%m/%Y %H:%i:%s') as AdDateTime, FTA.NoOfAxle, FTA.DoubleWheelDetected, FTA.VehicleLength, FTA.VehicleHeight, FTA.InterAxleDistance, FTA.TcClassID, MPPM.QCLASSSubDesc AS TCClass, FTA.AVCClassID, AV.ShortDescription AS AVCClass FROM FastagAuditTransaction FTA LEFT JOIN mclasses AV ON FTA.AVCClassID = AV.ClassID LEFT JOIN mplazamappingclass MPPM ON FTA.TcClassID = MPPM.NPCIClass WHERE DATETIME BETWEEN '2022-09-30 ' AND '2022-09-30 ' AND FTR.PlazaID=3]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'FTR.PlazaID' in 'where clause' 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 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.FasTag.Controllers.ViolationTransactionController.SearchViolationReview(ReviewViolationTransaction objData, Int32 ddlStatus, String isRealTime, String DateType) [Login Info:: SH00163: Ritesh Shah] 10:28:25.923 Failed to load grid data of Review Violation Transaction page. could not execute query [ SELECT FTA.ProjectID, FTA.PlazaID, FTA.FastagTransactionNumber, FTA.AVCTransactionNumber, FTA.LaneTransactionNumber, date_format(FTA.DATETIME,'%d/%m/%Y %H:%i:%s') as TrxnDateTime, FTA.CARDID, FTA.PLATENUMBER, FTA.LANEID, FTA.IsVIOLATION, FTA.AuditDATETIME, date_format(FTA.AuditDATETIME,'%d/%m/%Y %H:%i:%s') as AdDateTime, FTA.NoOfAxle, FTA.DoubleWheelDetected, FTA.VehicleLength, FTA.VehicleHeight, FTA.InterAxleDistance, FTA.TcClassID, MPPM.QCLASSSubDesc AS TCClass, FTA.AVCClassID, AV.ShortDescription AS AVCClass FROM FastagAuditTransaction FTA LEFT JOIN mclasses AV ON FTA.AVCClassID = AV.ClassID LEFT JOIN mplazamappingclass MPPM ON FTA.TcClassID = MPPM.NPCIClass WHERE DATETIME BETWEEN '2022-09-30 ' AND '2022-09-30 ' AND FTR.PlazaID=3 ] [SQL: SELECT FTA.ProjectID, FTA.PlazaID, FTA.FastagTransactionNumber, FTA.AVCTransactionNumber, FTA.LaneTransactionNumber, date_format(FTA.DATETIME,'%d/%m/%Y %H:%i:%s') as TrxnDateTime, FTA.CARDID, FTA.PLATENUMBER, FTA.LANEID, FTA.IsVIOLATION, FTA.AuditDATETIME, date_format(FTA.AuditDATETIME,'%d/%m/%Y %H:%i:%s') as AdDateTime, FTA.NoOfAxle, FTA.DoubleWheelDetected, FTA.VehicleLength, FTA.VehicleHeight, FTA.InterAxleDistance, FTA.TcClassID, MPPM.QCLASSSubDesc AS TCClass, FTA.AVCClassID, AV.ShortDescription AS AVCClass FROM FastagAuditTransaction FTA LEFT JOIN mclasses AV ON FTA.AVCClassID = AV.ClassID LEFT JOIN mplazamappingclass MPPM ON FTA.TcClassID = MPPM.NPCIClass WHERE DATETIME BETWEEN '2022-09-30 ' AND '2022-09-30 ' AND FTR.PlazaID=3]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'FTR.PlazaID' in 'where clause' 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 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.FasTag.Controllers.ViolationTransactionController.SearchViolationReview(ReviewViolationTransaction objData, Int32 ddlStatus, String isRealTime, String DateType) [Login Info:: SH00163: Ritesh Shah] 15:01:38.227 Failed to load grid data of Helper Controller- rights page. SELECT Active, FormId As PageId FROM MUserRoleDetail WHERE UserRoleID = 1 AND ModuleId = 11 AND Active = 1 AND FormID = 336 [Login Info:: Admin]