Hangfire Dashboard

VccAutoMailSentJob.GetConsolidatedAutoApprovedMailDetails

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

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

Properties

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

State

9/8/2025 10:18:18 AM (+11.584s) 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.GetConsolidatedAutoApprovedMailDetails() in D:\Projects_2.O\OOP_Git\OOP.BackgroundJobsManager\Jobs\VccAutoMailSentJob.cs:line 116

+73ms Processing

Server:
pc15:10556
Worker:
c7140295

+13ms Enqueued

Triggered by recurring job scheduler

Queue:
queue-k_consolidatedautoapprovedordermailsent

9/8/2025 10:18:06 AM Created