VccAutoMailSentJob.GetConsolidatedAutoApprovedMailDetails

System.InvalidOperationException

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at OOP.BackgroundTask.Orders.SentAutoMailReportVCC.GetAutoApprovedMailDetailsCount(String division, String state) in D:\Projects_2.O\OOP_Git\OOP.BackgroundTask\Orders\SentAutoMailReportVCC.cs:line 652
   at OOP.BackgroundTask.Orders.SentAutoMailReportVCC.SentConsolidatedAutoMailDivisionWise(DataTable dt, String Division, String State, String mailto, String mailcc) in D:\Projects_2.O\OOP_Git\OOP.BackgroundTask\Orders\SentAutoMailReportVCC.cs:line 1102
   at OOP.BackgroundTask.Orders.SentAutoMailReportVCC.SentConsolidatedAutoMailReportForApprovedOrder(DataTable dt) in D:\Projects_2.O\OOP_Git\OOP.BackgroundTask\Orders\SentAutoMailReportVCC.cs:line 1041
   at OOP.BackgroundJobsManager.Jobs.VccAutoMailSentJob.GetConsolidatedAutoApprovedMailDetails() in D:\Projects_2.O\OOP_Git\OOP.BackgroundJobsManager\Jobs\VccAutoMailSentJob.cs:line 120

Server:

pc15:11020

Worker:

29f1ad52

Queue:

queue-k_consolidatedautoapprovedordermailsent