00:08:43.337 Failed to load grid data of SI Audit Transactions page. could not execute query [ select ProjectID,PlazaID,ID, HTransactionNumber,LaneTransactionNumber,VehicleNumber VehicleNumber,LaneID,TDateTime,ShiftID,ShiftsType,ClassName,AVCClassName,WimClassName,TcClassID,AVCClassID,PaymentMeansID,PaymentMeans,TotalPaidAmount,WIMPaidAmt,TCUserID,Simulation ,IsOverloaded,CONCAT('Lane ',LaneID ) as Lane,OperationShiftNumber,WimAmount,IsOverloaded,IsSWB ,IsAudited,AuditMode,FastagTransactionNumber,PMethodID,LaneDirectionID,CardID,DateTime, TagClass, TCSubClassID, AVCSubClassID from vw_ValidateTransactionDetails Where cast(TDateTime as date) BETWEEN cast('2023-04-04 23:55:32' as date) AND cast('2023-04-04 23:55:32' as date) and IsAuditCancel=0 and IsAudited=0 and AuditDateTime is null and IsFakeViolation!=1 and PlazaID=3 and ProjectID=1 And ShiftID IN (3) order by TDateTime desc ] [SQL: select ProjectID,PlazaID,ID, HTransactionNumber,LaneTransactionNumber,VehicleNumber VehicleNumber,LaneID,TDateTime,ShiftID,ShiftsType,ClassName,AVCClassName,WimClassName,TcClassID,AVCClassID,PaymentMeansID,PaymentMeans,TotalPaidAmount,WIMPaidAmt,TCUserID,Simulation ,IsOverloaded,CONCAT('Lane ',LaneID ) as Lane,OperationShiftNumber,WimAmount,IsOverloaded,IsSWB ,IsAudited,AuditMode,FastagTransactionNumber,PMethodID,LaneDirectionID,CardID,DateTime, TagClass, TCSubClassID, AVCSubClassID from vw_ValidateTransactionDetails Where cast(TDateTime as date) BETWEEN cast('2023-04-04 23:55:32' as date) AND cast('2023-04-04 23:55:32' as date) and IsAuditCancel=0 and IsAudited=0 and AuditDateTime is null and IsFakeViolation!=1 and PlazaID=3 and ProjectID=1 And ShiftID IN (3) order by TDateTime desc]MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: Connection timed out. ---> System.Net.Sockets.SocketException (110): Connection timed out at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) in /_/src/System.Net.Sockets/src/System/Net/Sockets/NetworkStream.cs:line 298 --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) in /_/src/System.Net.Sockets/src/System/Net/Sockets/NetworkStream.cs:line 298 at System.Net.Security.SslStream.FillBufferAsync[TReadAdapter](TReadAdapter adapter, Int32 minSize) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.Implementation.cs:line 1463 at System.Net.Security.SslStream.ReadAsyncInternal[TReadAdapter](TReadAdapter adapter, Memory`1 buffer) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.Implementation.cs:line 1439 at System.Net.Security.SslStream.Read(Byte[] buffer, Int32 offset, Int32 count) in /_/src/System.Net.Security/src/System/Net/Security/SslStream.cs:line 753 at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(DbCommand st, QueryParameters queryParameters, ISessionImplementor session, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) at NHibernate.Impl.AbstractSessionImpl.List[T](NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List[T]() at QuaLiX.TMS.Web.Areas.Validation.Controllers.SIAuditController.GetGridList(TransactionSearchMultiSelection jsonData, String isRealTime, Int32 isSwb) in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\SIAuditController.cs:line 206 [Login Info:: ADMIN: Administrator User] 10:48:54.643 Failed to load grid data of Module Version Details page. could not execute query [ SELECT Build AS 'Version' FROM modulesversion WHERE ApplicationType = 1 order by versionId desc limit 1 ] [SQL: SELECT Build AS 'Version' FROM modulesversion WHERE ApplicationType = 1 order by versionId desc limit 1] [Login Info:: ADMIN: Administrator User] 10:48:54.725 Failed to load grid data of Uploaded SI Transaction page. could not execute query [ select PaymentMeansID, Description as PaymentMeans, sum(NotUploaded) as NotUploaded, sum(Uploaded) as Uploaded from ( Select LT.PaymentMeansID, mppm.Description, CASE WHEN IFNULL(LT.LaneTransactionNumber,0)=LTU.LaneTransactionNumber THEN 0 ELSE 1 END as NotUploaded, (CASE WHEN IFNULL(LTU.LaneTransactionNumber,0)>0 THEN 1 ELSE 0 END) AS Uploaded from lanetransactions LT left join lanetransactionuploaded LTU on LT.LaneTransactionNumber=LTU.LaneTransactionNumber LEFT JOIN mplazapaymentmeans mppm ON LT.PaymentMeansID = mppm.PaymentMeansID AND mppm.ProjectTypeID = 2 Where cast(LT.TDateTime as date) BETWEEN cast('2022-08-23' as date) AND cast('2023-04-05' as date) and (IFNULL(LT.AVCClassID,0) >0 or IFNULL(LT.TcClassID,0)>0) and LT.IsTCCancel=0 )temp group by PaymentMeansID, Description order by PaymentMeansID asc ] [SQL: select PaymentMeansID, Description as PaymentMeans, sum(NotUploaded) as NotUploaded, sum(Uploaded) as Uploaded from ( Select LT.PaymentMeansID, mppm.Description, CASE WHEN IFNULL(LT.LaneTransactionNumber,0)=LTU.LaneTransactionNumber THEN 0 ELSE 1 END as NotUploaded, (CASE WHEN IFNULL(LTU.LaneTransactionNumber,0)>0 THEN 1 ELSE 0 END) AS Uploaded from lanetransactions LT left join lanetransactionuploaded LTU on LT.LaneTransactionNumber=LTU.LaneTransactionNumber LEFT JOIN mplazapaymentmeans mppm ON LT.PaymentMeansID = mppm.PaymentMeansID AND mppm.ProjectTypeID = 2 Where cast(LT.TDateTime as date) BETWEEN cast('2022-08-23' as date) AND cast('2023-04-05' as date) and (IFNULL(LT.AVCClassID,0) >0 or IFNULL(LT.TcClassID,0)>0) and LT.IsTCCancel=0 )temp group by PaymentMeansID, Description order by PaymentMeansID asc ]MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred. (Connection refused 172.16.32.9:3306) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (111): Connection refused 172.16.32.9:3306 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/Socket.cs:line 2407 at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/TCPClient.cs:line 338 at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/FutureFactory.cs:line 547 --- End of inner exception stack trace --- at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/Task.cs:line 2763 at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.AdoNet.ConnectionManager.GetConnection() at NHibernate.AdoNet.AbstractBatcher.Prepare(DbCommand cmd) 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.UploadSITrxnController.GetTrxnSummary(SearchTrxnSummry jsonData, String isRealTime, Int32 type) in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 142 [Login Info:: ADMIN: Administrator User] 10:48:54.742 Failed to load grid data of GetLastUploadTrxnTime() Uploaded SI Transaction page. could not execute query [ Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1; ] [SQL: Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1; ]MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred. (Connection refused 172.16.32.9:3306) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (111): Connection refused 172.16.32.9:3306 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/Socket.cs:line 2407 at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/TCPClient.cs:line 338 at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/FutureFactory.cs:line 547 --- End of inner exception stack trace --- at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/Task.cs:line 2763 at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.AdoNet.ConnectionManager.GetConnection() at NHibernate.AdoNet.AbstractBatcher.Prepare(DbCommand cmd) 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(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at QuaLiX.TMS.Web.Areas.Validation.Controllers.UploadSITrxnController.GetLastUploadTrxnTime() in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 583 [Login Info:: ADMIN: Administrator User] 10:49:10.693 Failed to load grid data of Module Version Details page. could not execute query [ SELECT Build AS 'Version' FROM modulesversion WHERE ApplicationType = 1 order by versionId desc limit 1 ] [SQL: SELECT Build AS 'Version' FROM modulesversion WHERE ApplicationType = 1 order by versionId desc limit 1] [Login Info:: ADMIN: Administrator User] 10:49:10.718 Failed to load grid data of Uploaded SI Transaction page. could not execute query [ select PaymentMeansID, Description as PaymentMeans, sum(NotUploaded) as NotUploaded, sum(Uploaded) as Uploaded from ( Select LT.PaymentMeansID, mppm.Description, CASE WHEN IFNULL(LT.LaneTransactionNumber,0)=LTU.LaneTransactionNumber THEN 0 ELSE 1 END as NotUploaded, (CASE WHEN IFNULL(LTU.LaneTransactionNumber,0)>0 THEN 1 ELSE 0 END) AS Uploaded from lanetransactions LT left join lanetransactionuploaded LTU on LT.LaneTransactionNumber=LTU.LaneTransactionNumber LEFT JOIN mplazapaymentmeans mppm ON LT.PaymentMeansID = mppm.PaymentMeansID AND mppm.ProjectTypeID = 2 Where cast(LT.TDateTime as date) BETWEEN cast('2022-08-23' as date) AND cast('2023-04-05' as date) and (IFNULL(LT.AVCClassID,0) >0 or IFNULL(LT.TcClassID,0)>0) and LT.IsTCCancel=0 )temp group by PaymentMeansID, Description order by PaymentMeansID asc ] [SQL: select PaymentMeansID, Description as PaymentMeans, sum(NotUploaded) as NotUploaded, sum(Uploaded) as Uploaded from ( Select LT.PaymentMeansID, mppm.Description, CASE WHEN IFNULL(LT.LaneTransactionNumber,0)=LTU.LaneTransactionNumber THEN 0 ELSE 1 END as NotUploaded, (CASE WHEN IFNULL(LTU.LaneTransactionNumber,0)>0 THEN 1 ELSE 0 END) AS Uploaded from lanetransactions LT left join lanetransactionuploaded LTU on LT.LaneTransactionNumber=LTU.LaneTransactionNumber LEFT JOIN mplazapaymentmeans mppm ON LT.PaymentMeansID = mppm.PaymentMeansID AND mppm.ProjectTypeID = 2 Where cast(LT.TDateTime as date) BETWEEN cast('2022-08-23' as date) AND cast('2023-04-05' as date) and (IFNULL(LT.AVCClassID,0) >0 or IFNULL(LT.TcClassID,0)>0) and LT.IsTCCancel=0 )temp group by PaymentMeansID, Description order by PaymentMeansID asc ]MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred. (Connection refused 172.16.32.9:3306) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (111): Connection refused 172.16.32.9:3306 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/Socket.cs:line 2407 at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/TCPClient.cs:line 338 at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/FutureFactory.cs:line 547 --- End of inner exception stack trace --- at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/Task.cs:line 2763 at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.AdoNet.ConnectionManager.GetConnection() at NHibernate.AdoNet.AbstractBatcher.Prepare(DbCommand cmd) 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.UploadSITrxnController.GetTrxnSummary(SearchTrxnSummry jsonData, String isRealTime, Int32 type) in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 142 [Login Info:: ADMIN: Administrator User] 10:49:10.727 Failed to load grid data of GetLastUploadTrxnTime() Uploaded SI Transaction page. could not execute query [ Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1; ] [SQL: Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1; ]MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred. (Connection refused 172.16.32.9:3306) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (111): Connection refused 172.16.32.9:3306 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/Socket.cs:line 2407 at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/TCPClient.cs:line 338 at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/FutureFactory.cs:line 547 --- End of inner exception stack trace --- at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/Task.cs:line 2763 at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.AdoNet.ConnectionManager.GetConnection() at NHibernate.AdoNet.AbstractBatcher.Prepare(DbCommand cmd) 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(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at QuaLiX.TMS.Web.Areas.Validation.Controllers.UploadSITrxnController.GetLastUploadTrxnTime() in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 583 [Login Info:: ADMIN: Administrator User] 10:50:01.915 Failed to load grid data of Module Version Details page. could not execute query [ SELECT Build AS 'Version' FROM modulesversion WHERE ApplicationType = 1 order by versionId desc limit 1 ] [SQL: SELECT Build AS 'Version' FROM modulesversion WHERE ApplicationType = 1 order by versionId desc limit 1] [Login Info:: ADMIN: Administrator User] 10:50:01.979 Failed to load grid data of Uploaded SI Transaction page. could not execute query [ select PaymentMeansID, Description as PaymentMeans, sum(NotUploaded) as NotUploaded, sum(Uploaded) as Uploaded from ( Select LT.PaymentMeansID, mppm.Description, CASE WHEN IFNULL(LT.LaneTransactionNumber,0)=LTU.LaneTransactionNumber THEN 0 ELSE 1 END as NotUploaded, (CASE WHEN IFNULL(LTU.LaneTransactionNumber,0)>0 THEN 1 ELSE 0 END) AS Uploaded from lanetransactions LT left join lanetransactionuploaded LTU on LT.LaneTransactionNumber=LTU.LaneTransactionNumber LEFT JOIN mplazapaymentmeans mppm ON LT.PaymentMeansID = mppm.PaymentMeansID AND mppm.ProjectTypeID = 2 Where cast(LT.TDateTime as date) BETWEEN cast('2022-08-23' as date) AND cast('2023-04-05' as date) and (IFNULL(LT.AVCClassID,0) >0 or IFNULL(LT.TcClassID,0)>0) and LT.IsTCCancel=0 )temp group by PaymentMeansID, Description order by PaymentMeansID asc ] [SQL: select PaymentMeansID, Description as PaymentMeans, sum(NotUploaded) as NotUploaded, sum(Uploaded) as Uploaded from ( Select LT.PaymentMeansID, mppm.Description, CASE WHEN IFNULL(LT.LaneTransactionNumber,0)=LTU.LaneTransactionNumber THEN 0 ELSE 1 END as NotUploaded, (CASE WHEN IFNULL(LTU.LaneTransactionNumber,0)>0 THEN 1 ELSE 0 END) AS Uploaded from lanetransactions LT left join lanetransactionuploaded LTU on LT.LaneTransactionNumber=LTU.LaneTransactionNumber LEFT JOIN mplazapaymentmeans mppm ON LT.PaymentMeansID = mppm.PaymentMeansID AND mppm.ProjectTypeID = 2 Where cast(LT.TDateTime as date) BETWEEN cast('2022-08-23' as date) AND cast('2023-04-05' as date) and (IFNULL(LT.AVCClassID,0) >0 or IFNULL(LT.TcClassID,0)>0) and LT.IsTCCancel=0 )temp group by PaymentMeansID, Description order by PaymentMeansID asc ]MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred. (Connection refused 172.16.32.9:3306) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (111): Connection refused 172.16.32.9:3306 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/Socket.cs:line 2407 at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/TCPClient.cs:line 338 at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/FutureFactory.cs:line 547 --- End of inner exception stack trace --- at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/Task.cs:line 2763 at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.AdoNet.ConnectionManager.GetConnection() at NHibernate.AdoNet.AbstractBatcher.Prepare(DbCommand cmd) 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.UploadSITrxnController.GetTrxnSummary(SearchTrxnSummry jsonData, String isRealTime, Int32 type) in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 142 [Login Info:: ADMIN: Administrator User] 10:50:02.009 Failed to load grid data of GetLastUploadTrxnTime() Uploaded SI Transaction page. could not execute query [ Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1; ] [SQL: Select TXN_NO, date_format(LTU.RequestDate, '%d/%m/%Y %h:%i:%s') as LastRequestDateTime, date_format(LT.TDateTime, '%d/%m/%Y %h:%i:%s') as LastTrxnDateTime from lanetransactionuploaded LTU inner join lanetransactions LT on LTU.LaneTransactionNumber=LT.LaneTransactionNumber order by RequestDate desc limit 1; ]MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. ---> System.AggregateException: One or more errors occurred. (Connection refused 172.16.32.9:3306) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (111): Connection refused 172.16.32.9:3306 at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/Socket.cs:line 2407 at System.Net.Sockets.TcpClient.EndConnect(IAsyncResult asyncResult) in /_/src/System.Net.Sockets/src/System/Net/Sockets/TCPClient.cs:line 338 at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/FutureFactory.cs:line 547 --- End of inner exception stack trace --- at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) in /_/src/System.Private.CoreLib/shared/System/Threading/Tasks/Task.cs:line 2763 at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.AdoNet.ConnectionManager.GetConnection() at NHibernate.AdoNet.AbstractBatcher.Prepare(DbCommand cmd) 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(NativeSQLQuerySpecification spec, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.List() at QuaLiX.TMS.Web.Areas.Validation.Controllers.UploadSITrxnController.GetLastUploadTrxnTime() in D:\WorkingProjects\OpenSource TMS\BackOffice\QuaLiX.TMS.WebApp\QuaLiX.TMS.Web\Areas\Validation\Controllers\UploadSITrxnController.cs:line 583 [Login Info:: ADMIN: Administrator User]