Hangfire Dashboard

CreateLeaveRequestsJob.ExecuteAsync

// Id: #854
using MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs;

var createLeaveRequestsJob = Activate<CreateLeaveRequestsJob>();
await createLeaveRequestsJob.ExecuteAsync(null);

Parameters

CurrentCulture 
"en-US"
CurrentUICulture 
"en-US"
RecurringJobId 
"create-leave-request-automatic-job"
RetryCount 
10
Time 
1764211589

State

27‏‏/11‏‏/2025 7:14:31 ص (+46ms) Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+4ms Processing

Server:
win-1htud3sbs52:142328
Worker:
9527eaba

+1h 49m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 10 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 7:14:21 ص

+40ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+4ms Processing

Server:
win-1htud3sbs52:142328
Worker:
a4c5d10e

+1h 8m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 9 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 5:24:31 ص

+40ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+ <1ms Processing

Server:
win-1htud3sbs52:142328
Worker:
a7dcdc8f

+40m 45.210s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 8 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 4:15:46 ص

+44ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3ms Processing

Server:
win-1htud3sbs52:142328
Worker:
3776edfd

+25m 127ms Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 7 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 3:35:07 ص

+33ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3ms Processing

Server:
win-1htud3sbs52:142328
Worker:
cfbe782d

+11m 45.037s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

Retry attempt 6 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 3:10:09 ص

+34ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3ms Processing

Server:
win-1htud3sbs52:142328
Worker:
af5975f0

+5m 14.967s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

Retry attempt 5 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 2:58:25 ص

+73ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+4ms Processing

Server:
win-1htud3sbs52:142328
Worker:
f9d9ec2e

+3m 14.986s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 4 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 2:53:11 ص

+37ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3ms Processing

Server:
win-1htud3sbs52:142328
Worker:
93d0d8e2

+1m 29.884s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 3 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 2:49:57 ص

+133ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3ms Processing

Server:
win-1htud3sbs52:142328
Worker:
69bdc0dc

+59.867s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 2 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 2:48:25 ص

+147ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3ms Processing

Server:
win-1htud3sbs52:142328
Worker:
a7dcdc8f

+57.343s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 1 of 10: Invalid column name 'EmployeeStatus'.

Enqueue at:
27‏‏/11‏‏/2025 2:47:15 ص

+2.484s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (win-1htud3sbs52:142328)

Invalid column name 'EmployeeStatus'.

Microsoft.Data.SqlClient.SqlException: Invalid column name 'EmployeeStatus'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at MoD.BenefitTrack.HousingRequestManagement.EntityFramework.Repositories.LeaveRequestReadOnlyRepository.GetUnitAllocationsRequiretEvacuationAsync(CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Domain.DomainManagers.LeaveRequestManager.SystemCreateListAsync(Guid termsVersionId, CancellationToken cancellationToken)
   at MoD.BenefitTrack.Post_HousingRequestManagement.Application.BackgroundJobs.CreateLeaveRequestsJob.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+83ms Processing

Server:
win-1htud3sbs52:142328
Worker:
3776edfd

+43ms Enqueued

Triggered by recurring job scheduler

27‏‏/11‏‏/2025 2:46:29 ص Created