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:

923f0311

Server:

pc15:26868

Worker:

f6136c7f

Server:

pc15:24252

Worker:

eff34b88

Server:

pc15:34388

Worker:

bd85218c

Server:

pc15:32908

Worker:

d56b55bb

Queue:

queue-k_consolidatedautoapprovedordermailsent