11:52:53.748 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-28 ' AND '2022-09-28 ' 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-28 ' AND '2022-09-28 ' 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:27:32.669 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.850 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.859 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.865 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.871 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.877 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.907 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.913 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.919 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.925 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.931 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.937 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.944 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.950 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.956 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.962 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.968 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.975 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.981 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.987 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.993 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:32.999 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.005 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.011 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.018 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.026 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.032 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.038 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.044 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.050 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.056 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.185 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.194 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.200 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.324 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.334 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.342 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.351 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.360 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah] 15:27:33.372 Failed to load grid data of GetClassConfig page. Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') [Login Info:: SH00163: Ritesh Shah]