VccAutoMailSentJob.GetConsolidatedAutoApprovedMailDetails

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

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

Properties

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

State

9/9/2025 5:33:20 AM (+1m 19.640s) Failed

An exception occurred during performance of the job.

System.Data.SqlClient.SqlException

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The user name or password is incorrect
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   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

+11m 23.457s Processing

Server:
pc15:11020
Worker:
45a9e38b

+7m 606ms Processing

Server:
pc15:26868
Worker:
ac43d558

+14h 33m Processing

Server:
pc15:24252
Worker:
04cc6a03

+1.077s Processing

Server:
pc15:34388
Worker:
53408da7

+263ms Enqueued

Triggered by recurring job scheduler

9/8/2025 2:40:27 PM Created