Application Metadata (AppInfoModel)
  • Application Name & Version DSTAPI v4.1.9.0
  • App Description A lightweight, high-performance DST api client handler
  • App Type ASP .NET 8 CORE API
  • Environment Mode Server
  • Token D5EE2R6ER6D3FF54E359
Device & Client Profile (PhysicalDeviceInformation)
  • Form Factor Desktop Workspace
  • Manufacturer & Model ATUL-SINGH Microsoft Windows 10.0.26200
  • Platform / OS .NET 8.0.21
  • Client IP Address 106.192.179.154
  • Exception Status & Mode Flags
    Status: Unhandled Mode: Development
Code Reference & Location
Timestamp 2026-09-09 13:48:38 +05:30
Line Number Line 62
Namespace dst.admin.web.services.repo.Employee.List.Repository
Page / Component Name EmployeeListRepository
Method Name GetSalesmanListByYearAsync
Site Map dst.admin.web.services.repo.Employee.List.Repository - EmployeeListRepository/GetSalesmanListByYearAsync
File Path Source D:\Core Application\DST Admin Web Services\Employee\List\Repository\GetSalesmanListBySalesYear.cs
Exception Message Payload
Primary Message
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=15164; handshake=33;
INNER EXCEPTION MESSAGE
The wait operation timed out.
Full Stack Trace Diagnostics
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at dst.admin.web.services.repo.Employee.List.Repository.EmployeeListRepository.GetSalesmanListByYearAsync(String financialYear, CancellationToken cancellationToken) in D:\Core Application\DST Admin Web Services\Employee\List\Repository\GetSalesmanListBySalesYear.cs:line 28