10:28:15.197 Login 10:28:14.590 process : User login 10:28:14.593 project running for close toll process [Login Info:: ] 10:28:15.260 Login successfully 10:28:14.590 process : User login 10:28:14.593 project running for close toll process [Login Info:: ADMIN: Administrator User] 10:29:16.407 10:29:16.3475 report parameters added : 5 10:29:16.3480 Call procedure : USP_Reporting_TrafficMOPWise 10:29:16:4076 Data return from database. table count : 3 [Login Info:: ] 10:31:22.605 10:31:22.5267 report parameters added : 4 10:31:22.5268 Call procedure : USP_Reporting_TrafficRevenueReport_ExcelExport 10:31:22:6048 Data return from database. table count : 2 [Login Info:: ] 10:31:22.649 Get header report detail page loaded successfully. Company name : Trans-Haryana Expressways and Plaza name : Mohna Ch 32+464 [Login Info:: ADMIN: Administrator User] 11:57:35.336 Login 11:57:34.639 process : User login 11:57:34.642 project running for close toll process [Login Info:: ] 11:57:35.403 Login successfully 11:57:34.639 process : User login 11:57:34.642 project running for close toll process [Login Info:: ADMIN: Administrator User] 11:57:51.815 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 11:58:00.423 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 11:58:03.555 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): 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] 11:59:40.843 Login 11:59:40.481 process : User login 11:59:40.484 project running for close toll process [Login Info:: ] 11:59:40.898 Login successfully 11:59:40.481 process : User login 11:59:40.484 project running for close toll process [Login Info:: ADMIN: Administrator User] 11:59:51.698 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 11:59:54.702 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): 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] 12:01:15.849 Login 12:01:15.473 process : User login 12:01:15.476 project running for close toll process [Login Info:: ] 12:01:15.904 Login successfully 12:01:15.473 process : User login 12:01:15.476 project running for close toll process [Login Info:: ADMIN: Administrator User] 12:01:26.118 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:01:28.949 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210114 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] 12:01:41.790 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210112 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] 12:03:14.072 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:03:16.644 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210114 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] 12:03:20.658 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210113 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] 12:03:21.326 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210112 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] 12:03:21.677 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210111 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] 12:03:21.981 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 from vw_siaudittrxndetails where HTransactionNumber=303210110 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 from vw_siaudittrxndetails where HTransactionNumber=303210110 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.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] 12:03:33.358 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:03:37.046 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 from vw_siaudittrxndetails where HTransactionNumber=310310018 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 from vw_siaudittrxndetails where HTransactionNumber=310310018 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.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] 12:06:04.996 Login 12:06:04.645 process : User login 12:06:04.648 project running for close toll process [Login Info:: ] 12:06:05.059 Login successfully 12:06:04.645 process : User login 12:06:04.648 project running for close toll process [Login Info:: ADMIN: Administrator User] 12:06:17.816 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:06:21.225 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 from vw_siaudittrxndetails where HTransactionNumber=304310092 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 from vw_siaudittrxndetails where HTransactionNumber=304310092 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] 12:06:38.673 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:06:41.546 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210114 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] 12:06:54.769 User roll page loaded successfully. Roll total = 12 [Login Info:: ADMIN: Administrator User] 12:06:55.163 User roll detail page loaded successfully. [Login Info:: ADMIN: Administrator User] 12:07:23.541 User Roll page saved successfully. User roll updated. roll name = Admin [Login Info:: ADMIN: Administrator User] 12:07:23.952 Uesr Roll Detail page saved successfully. save or update role detail. role id : 1 name:Admin [Login Info:: ADMIN: Administrator User] 12:07:36.204 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:07:39.487 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 from vw_siaudittrxndetails where HTransactionNumber=303210110 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 from vw_siaudittrxndetails where HTransactionNumber=303210110 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.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:07:47.289 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210111 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.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:07:48.109 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210112 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.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:07:48.971 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210113 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.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:07:49.292 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 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 from vw_siaudittrxndetails where HTransactionNumber=303210114 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.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:08:00.721 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:08:05.180 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 from vw_siaudittrxndetails where HTransactionNumber=301210833 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 from vw_siaudittrxndetails where HTransactionNumber=301210833 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.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:10:12.610 Login 12:10:12.251 process : User login 12:10:12.254 project running for close toll process [Login Info:: ] 12:10:12.665 Login successfully 12:10:12.251 process : User login 12:10:12.254 project running for close toll process [Login Info:: ADMIN: Administrator User] 12:10:25.056 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:10:29.068 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): 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] 12:13:34.534 Login 12:13:34.500 process : User login 12:13:34.503 project running for close toll process [Login Info:: ] 12:13:34.554 Login successfully 12:13:34.500 process : User login 12:13:34.503 project running for close toll process [Login Info:: ADMIN: Administrator User] 12:18:54.269 Login 12:18:54.251 process : User login 12:18:54.253 project running for close toll process [Login Info:: ] 12:18:54.280 Login successfully 12:18:54.251 process : User login 12:18:54.253 project running for close toll process [Login Info:: ADMIN: Administrator User] 12:20:09.115 12:20:08.8347 report parameters added : 10 12:20:08.8353 Call procedure : USP_Reporting_MIS_SubClassBy 12:20:09:1151 Data return from database. table count : 20 [Login Info:: ] 12:22:37.907 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:22:45.079 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): 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.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:23:01.933 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): 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.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:23:24.013 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 12:23:28.943 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.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:33:03.736 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:33:57.941 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:34:08.623 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): 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.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:34:43.266 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): 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.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:34:45.717 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): 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.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:35:17.082 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.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:35:49.919 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:36:14.485 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:36:29.297 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:36:41.158 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=310310011 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=310310011 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.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:37:01.098 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:37:13.475 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): 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.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:37:20.739 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:37:36.251 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=305310013 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=305310013 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.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:37:42.769 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:37:50.914 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=304310084 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=304310084 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.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:38:54.507 Logout successfully [Login Info:: ADMIN: Administrator User] 14:39:04.829 Login 14:39:04.823 process : User login 14:39:04.824 project running for close toll process 14:39:04.828 Invalid password for user: admin [Login Info:: ] 14:39:10.733 Login 14:39:10.720 process : User login 14:39:10.720 project running for close toll process [Login Info:: ] 14:39:10.743 Login successfully 14:39:10.720 process : User login 14:39:10.720 project running for close toll process [Login Info:: ADMIN: Administrator User] 14:39:34.948 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:39:40.684 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=302210124 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=302210124 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.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:39:52.288 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:40:05.577 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=302210110 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=302210110 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.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:40:14.156 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:40:24.124 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=302210100 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=302210100 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.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:40:30.754 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:40:41.932 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:40:53.403 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=303210087 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=303210087 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.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:43:11.004 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 14:43:14.906 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=303210087 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=303210087 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.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] 15:13:08.770 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:14:09.199 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:14:14.287 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:14:16.860 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:14:18.042 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:14:21.656 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:14:24.633 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.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] 15:18:57.780 Logout successfully [Login Info:: ADMIN: Administrator User] 15:19:05.544 Login 15:19:05.533 process : User login 15:19:05.534 project running for close toll process [Login Info:: ] 15:19:05.559 Login successfully 15:19:05.533 process : User login 15:19:05.534 project running for close toll process [Login Info:: ADMIN: Administrator User] 15:19:17.350 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:19:21.746 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.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] 15:20:26.785 Login 15:20:26.775 process : User login 15:20:26.776 project running for close toll process [Login Info:: ] 15:20:26.795 Login successfully 15:20:26.775 process : User login 15:20:26.776 project running for close toll process [Login Info:: ADMIN: Administrator User] 15:20:28.385 Failed to begin POS operation. could not execute native bulk manipulation query: update laneoperationshift set ShiftEndDateTime='2022-07-08 15:20:28.381' where OperationShiftNumber= [SQL: update laneoperationshift set ShiftEndDateTime='2022-07-08 15:20:28.381' where OperationShiftNumber=]MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() at QuaLiX.TMS.Web.Areas.POS.Controllers.AccountVehicleListController.InsertOperationNo(Int32 isShiftEnd, String operationShiftNo) [Login Info:: ADMIN: Administrator User] 15:20:41.441 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:20:44.611 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.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] 15:25:20.724 Login 15:25:20.379 process : User login 15:25:20.382 project running for close toll process [Login Info:: ] 15:25:20.789 Login successfully 15:25:20.379 process : User login 15:25:20.382 project running for close toll process [Login Info:: ADMIN: Administrator User] 15:25:36.929 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:25:40.137 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210114. [Login Info:: ADMIN: Administrator User] 15:40:44.808 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210113. [Login Info:: ADMIN: Administrator User] 15:40:49.425 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210114. [Login Info:: ADMIN: Administrator User] 15:41:03.733 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:41:06.197 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:41:10.016 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=302210124. [Login Info:: ADMIN: Administrator User] 15:41:22.022 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=302210123. [Login Info:: ADMIN: Administrator User] 15:41:24.272 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=302210122. [Login Info:: ADMIN: Administrator User] 15:41:25.670 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=302210121. [Login Info:: ADMIN: Administrator User] 15:41:26.784 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=302210120. [Login Info:: ADMIN: Administrator User] 15:41:27.897 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=302210119. [Login Info:: ADMIN: Administrator User] 15:41:52.473 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:41:56.044 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210107. [Login Info:: ADMIN: Administrator User] 15:42:11.571 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210106. [Login Info:: ADMIN: Administrator User] 15:42:13.521 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210105. [Login Info:: ADMIN: Administrator User] 15:42:16.919 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210104. [Login Info:: ADMIN: Administrator User] 15:42:26.192 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210108. [Login Info:: ADMIN: Administrator User] 15:42:37.025 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 15:42:41.350 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310090. [Login Info:: ADMIN: Administrator User] 15:42:46.089 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310089. [Login Info:: ADMIN: Administrator User] 15:43:09.940 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304210087. [Login Info:: ADMIN: Administrator User] 16:03:32.593 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:07:16.584 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:07:26.794 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210114. [Login Info:: ADMIN: Administrator User] 16:07:34.563 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210113. [Login Info:: ADMIN: Administrator User] 16:07:39.312 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210112. [Login Info:: ADMIN: Administrator User] 16:07:42.416 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210111. [Login Info:: ADMIN: Administrator User] 16:07:44.601 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210110. [Login Info:: ADMIN: Administrator User] 16:07:46.185 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310092. [Login Info:: ADMIN: Administrator User] 16:08:28.615 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310092. [Login Info:: ADMIN: Administrator User] 16:08:37.987 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310092. [Login Info:: ADMIN: Administrator User] 16:08:42.907 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310018. [Login Info:: ADMIN: Administrator User] 16:08:44.740 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310017. [Login Info:: ADMIN: Administrator User] 16:09:07.373 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:09:10.677 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210114. [Login Info:: ADMIN: Administrator User] 16:09:15.735 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210113. [Login Info:: ADMIN: Administrator User] 16:09:19.430 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210112. [Login Info:: ADMIN: Administrator User] 16:09:23.064 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210111. [Login Info:: ADMIN: Administrator User] 16:09:43.612 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:09:55.656 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:10:02.797 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310018. [Login Info:: ADMIN: Administrator User] 16:10:07.567 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310092. [Login Info:: ADMIN: Administrator User] 16:10:10.997 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310092. [Login Info:: ADMIN: Administrator User] 16:10:15.759 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310092. [Login Info:: ADMIN: Administrator User] 16:10:16.869 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310092. [Login Info:: ADMIN: Administrator User] 16:10:16.873 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310018. [Login Info:: ADMIN: Administrator User] 16:10:17.996 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310017. [Login Info:: ADMIN: Administrator User] 16:10:19.104 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=308314200. [Login Info:: ADMIN: Administrator User] 16:10:20.223 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310016. [Login Info:: ADMIN: Administrator User] 16:10:22.446 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312298. [Login Info:: ADMIN: Administrator User] 16:10:51.728 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310091. [Login Info:: ADMIN: Administrator User] 16:10:59.367 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312297. [Login Info:: ADMIN: Administrator User] 16:11:12.170 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310090. [Login Info:: ADMIN: Administrator User] 16:11:37.353 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310089. [Login Info:: ADMIN: Administrator User] 16:11:42.758 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310015. [Login Info:: ADMIN: Administrator User] 16:11:47.275 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310014. [Login Info:: ADMIN: Administrator User] 16:11:51.876 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310013. [Login Info:: ADMIN: Administrator User] 16:11:52.980 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=308314199. [Login Info:: ADMIN: Administrator User] 16:11:59.583 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312296. [Login Info:: ADMIN: Administrator User] 16:12:10.284 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310088. [Login Info:: ADMIN: Administrator User] 16:12:17.312 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312295. [Login Info:: ADMIN: Administrator User] 16:12:18.415 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312294. [Login Info:: ADMIN: Administrator User] 16:12:27.379 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=307310120. [Login Info:: ADMIN: Administrator User] 16:12:52.004 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:13:02.360 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=302210124. [Login Info:: ADMIN: Administrator User] 16:13:09.721 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=302210123. [Login Info:: ADMIN: Administrator User] 16:13:19.823 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:13:25.944 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210108. [Login Info:: ADMIN: Administrator User] 16:13:30.481 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210107. [Login Info:: ADMIN: Administrator User] 16:13:34.744 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210106. [Login Info:: ADMIN: Administrator User] 16:13:38.137 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210105. [Login Info:: ADMIN: Administrator User] 16:13:43.026 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210104. [Login Info:: ADMIN: Administrator User] 16:13:45.333 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=303210103. [Login Info:: ADMIN: Administrator User] 16:13:52.244 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:13:58.058 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=304310090. [Login Info:: ADMIN: Administrator User] 16:14:08.922 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:14:13.857 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=305210031. [Login Info:: ADMIN: Administrator User] 16:14:27.439 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:14:32.218 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312298. [Login Info:: ADMIN: Administrator User] 16:14:36.738 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312297. [Login Info:: ADMIN: Administrator User] 16:14:39.722 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312296. [Login Info:: ADMIN: Administrator User] 16:14:43.074 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312295. [Login Info:: ADMIN: Administrator User] 16:14:47.020 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312294. [Login Info:: ADMIN: Administrator User] 16:14:49.160 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306312293. [Login Info:: ADMIN: Administrator User] 16:14:52.025 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=306212292. [Login Info:: ADMIN: Administrator User] 16:14:59.389 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:15:07.417 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=307310120. [Login Info:: ADMIN: Administrator User] 16:15:15.709 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=307310119. [Login Info:: ADMIN: Administrator User] 16:15:19.091 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=307310118. [Login Info:: ADMIN: Administrator User] 16:15:25.162 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:15:30.694 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=308214198. [Login Info:: ADMIN: Administrator User] 16:15:39.737 SI Audit Transaction Grid Data fetch successfully. [Login Info:: ADMIN: Administrator User] 16:15:46.793 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310210012. [Login Info:: ADMIN: Administrator User] 16:15:57.190 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310013. [Login Info:: ADMIN: Administrator User] 16:16:01.785 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310014. [Login Info:: ADMIN: Administrator User] 16:16:02.946 SI Audit Transaction Details Data fetch successfully where HTransactionNumber=310310015. [Login Info:: ADMIN: Administrator User]