03:41:49.782	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): 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(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 563 	[Login Info:: ]