11:41:17.411 Login 11:41:16.909 process : User login 11:41:16.912 project running for close toll process [Login Info:: ] 11:41:17.499 Login successfully 11:41:16.909 process : User login 11:41:16.912 project running for close toll process [Login Info:: ADMIN: Administrator User] 11:41:32.701 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 11:41:37.680 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310310017 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310310017 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:41:55.718 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:42:05.609 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310089 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310089 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:42:06.089 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310310015 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310310015 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:42:24.495 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310310014 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310310014 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:42:31.296 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310310013 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310310013 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:42:32.363 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=308314199 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=308314199 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:42:33.278 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=306312296 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=306312296 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:42:33.822 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310088 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310088 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:42:33.978 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=306312295 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=306312295 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:43:42.379 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 11:43:46.014 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=302310099 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=302310099 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.ExecuteDbDataReader(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.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:44:01.243 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 11:44:04.564 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=302310099 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=302310099 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:47:51.350 Login 11:47:51.322 process : User login 11:47:51.324 project running for close toll process [Login Info:: ] 11:47:51.362 Login successfully 11:47:51.322 process : User login 11:47:51.324 project running for close toll process [Login Info:: ADMIN: Administrator User] 11:48:01.273 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 11:48:06.031 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210112 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210112 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 11:48:38.098 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 11:48:43.281 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 12:52:07.564 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:52:12.898 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:52:18.821 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210112 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210112 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 12:52:34.587 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:53:00.174 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 12:53:13.605 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310088 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310088 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 12:53:25.852 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:53:42.605 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310210012 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310210012 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 12:53:56.859 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=307210032 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=307210032 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 12:54:22.765 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=307210032 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=307210032 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 14:29:38.313 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:29:41.053 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210113 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210113 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 14:31:24.193 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:31:30.771 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:31:33.358 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210111 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210111 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 14:31:33.450 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210111 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210111 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.Validation.Controllers.SIAuditController.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 14:42:14.755 Login 14:42:14.409 process : User login 14:42:14.412 project running for close toll process [Login Info:: ] 14:42:14.800 Login successfully 14:42:14.409 process : User login 14:42:14.412 project running for close toll process [Login Info:: ADMIN: Administrator User] 14:42:27.181 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:42:30.182 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210114 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210114 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 14:45:39.966 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:45:42.900 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210113 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210113 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 14:47:18.404 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:47:20.952 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210113 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210113 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 14:49:40.309 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210113 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210113 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaCardID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 14:49:46.704 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:49:49.240 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210112 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=303210112 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaCardID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 15:06:12.505 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:06:16.630 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 15:07:19.195 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:07:32.698 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=307310078 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=307310078 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 15:07:46.029 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310210012 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=310210012 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 15:10:25.126 Login 15:10:24.747 process : User login 15:10:24.750 project running for close toll process [Login Info:: ] 15:10:25.190 Login successfully 15:10:24.747 process : User login 15:10:24.750 project running for close toll process [Login Info:: ADMIN: Administrator User] 15:10:42.281 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:10:45.395 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210112. [Login Info:: ADMIN: Administrator User] 15:12:23.042 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:12:26.181 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310090. [Login Info:: ADMIN: Administrator User] 15:36:47.163 Login 15:36:46.808 process : User login 15:36:46.811 project running for close toll process [Login Info:: ] 15:36:47.217 Login successfully 15:36:46.808 process : User login 15:36:46.811 project running for close toll process [Login Info:: ADMIN: Administrator User] 15:37:06.550 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:37:12.234 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 15:44:12.405 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:44:17.076 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 15:46:23.015 Login 15:46:22.670 process : User login 15:46:22.673 project running for close toll process [Login Info:: ] 15:46:23.078 Login successfully 15:46:22.670 process : User login 15:46:22.673 project running for close toll process [Login Info:: ADMIN: Administrator User] 15:46:38.157 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:46:41.192 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'EntryPlazaID' in 'field list' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User] 16:16:00.876 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:17:15.780 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:46:15.630 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:46:19.904 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:46:24.528 Failed to get SI Audit Transactions Data could not execute query [ select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0 ] [SQL: select ProjectID,PlazaID,HTransactionNumber,LaneTransactionNumber,AVCTransactionNumber,VehicleNumber,LaneName,TDateTime,TCUserID,ClassName,SubClassName,ReceiptNumber , AccountID, OperationPaymentMeansTypeID, CardID, Amount, FareID, ExemptionID, TransactionMode, DestinationPlazaID, Simulation, IsManualPayment, IsViolation, IsReceiptPrinted, ManualBookNumber, ManualReceiptNumber, IsAudited, IsTowVehicle, WimAmount, WIMPaidAmt, DataProcessMode, WIMSubClass, AVCAxleCount , OperationShiftNumber, SubClassID, TcClassID, LaneID, AVCClassID, WIMClassID, WimClassName, WIMPaidStatus, AVCClassName, PaymentMethod, MOP, ExemptionName, ExemptionDesp, WIMPaidAmount , WIMRefundAmount, SSWIMWt, RunThrough, Penalty, SSWIMClass, TcCancel, FAmount, IsTCCancel,PaymentMeansID,FastagTransactionNumber,IsOverloaded,IsSWB,IsHandheld,WalletName,IsFastagPenalty, FastagpenaltyPaidAmt,WimPaymentMethod,PenaltyWOVMValue,WIMPenaltyType,TagStatus,TidNo,EntryPlazaCardID, IsTagTfd, SWBSubClass, SWBTransactionNumber, WIMWeight, AVCSubClassID, ATTRIBUTE_1 ,SWBHTransactionNumber, SWBUserID, LaneDirectionID, EntryPlazaID from vw_siaudittrxndetails where HTransactionNumber=304310090 and PlazaID=3 and IsAuditCancel=0]MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'trha_pkg2.vw_siaudittrxndetails' doesn't exist at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() in /_/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:line 110 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces) at NHibernate.Loader.Custom.CustomLoader.List(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.GetTrxnDtlByNo(String jsondata) [Login Info:: ADMIN: Administrator User]