VccAutoMailSentJob.GetConsolidatedAutoApprovedMailDetails

// Job ID: #3653302
using OOP.BackgroundJobsManager.Jobs;

var vccAutoMailSentJob = Activate<VccAutoMailSentJob>();
vccAutoMailSentJob.GetConsolidatedAutoApprovedMailDetails();

Properties

CurrentCulture
"en-IN"
CurrentUICulture
"en-US"
RecurringJobId
"2"
Time
1757398037

State

9/10/2025 5:48:19 AM (+6m 24.190s) Failed

Failed to change state to a 'Succeeded' one due to an exception after 10 retry attempts

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 Hangfire.SqlServer.SqlServerStorage.CreateAndOpenConnection()
   at Hangfire.SqlServer.SqlServerConnection.AcquireLock(String resource, TimeSpan timeout)
   at Hangfire.SqlServer.SqlServerConnection.AcquireDistributedLock(String resource, TimeSpan timeout)
   at Hangfire.Storage.StorageConnectionExtensions.AcquireDistributedJobLock(IStorageConnection connection, String jobId, TimeSpan timeout)
   at Hangfire.States.BackgroundJobStateChanger.ChangeState(StateChangeContext context)
   at Hangfire.Server.Worker.TryChangeState(BackgroundProcessContext context, IStorageConnection connection, IFetchedJob fetchedJob, IState state, String[] expectedStates, CancellationToken initializeToken, CancellationToken abortToken)

+20h 4m Processing

Server:
pc15:23032
Worker:
7e26a74e

+20m 34.600s Processing

Server:
pc15:3440
Worker:
7565e47d

+2h 5m Processing

Server:
pc15:11240
Worker:
bb1d8667

+35m 32.657s Processing

Server:
pc15:22952
Worker:
538f66dd

+28m 29.380s Processing

Server:
pc15:28120
Worker:
7484784d

+20ms Processing

Server:
pc15:9040
Worker:
236fdc06

+20ms Enqueued

Triggered by recurring job scheduler

9/9/2025 6:07:17 AM Created