Hangfire Dashboard

VccAutoMailSentJob.GetAutoApprovedMailDetails

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

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

Properties

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

State

9/8/2025 10:09:28 AM (+3.293s) Failed

An exception occurred during performance of the job.

System.Data.SqlClient.SqlException

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

System.Data.SqlClient.SqlException (0x80131904): Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)
   at System.Data.SqlClient.SqlDataReader.NextResult()
   at System.Data.ProviderBase.DataReaderContainer.NextResult()
   at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at OOP.BackgroundJobsManager.Jobs.VccAutoMailSentJob.GetAutoApprovedMailDetails() in D:\Source\GitHub\OOP\OOP.BackgroundJobsManager\Jobs\VccAutoMailSentJob.cs:line 85

-5m 11.940s Processing

Server:
ooptest:1436
Worker:
8da5c270

+317ms Processing

Server:
pc15:11656
Worker:
aded6086

+683ms Enqueued

Triggered by recurring job scheduler

Queue:
queue-k_autoapprovedordermailsent

9/8/2025 10:14:36 AM Created