CreateLeaveRequestsJob.ExecuteAsync

// Id: #950
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
1765242011

State

9‏‏/12‏‏/2025 9:53:04 ص (+40ms) Failed

An exception occurred during performance of the job.

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

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:58728
Worker:
102c6df5

+1h 53m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 9:53:04 ص

+40ms Failed

An exception occurred during performance of the job.

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

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)

+ <1ms Processing

Server:
win-1htud3sbs52:58728
Worker:
03a9f69a

+1h 12m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 7:59:34 ص

+33ms Failed

An exception occurred during performance of the job.

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

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:58728
Worker:
79d363ee

+43m 45.064s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 6:47:09 ص

+180ms Failed

An exception occurred during performance of the job.

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

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:58728
Worker:
017f5b5f

+23m 45.033s Enqueued

Triggered by DelayedJobScheduler

+4ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 6:03:30 ص

+86ms Failed

An exception occurred during performance of the job.

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

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:58728
Worker:
08d83b5d

+13m 12.634s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 5:39:45 ص

+2.450s Failed

An exception occurred during performance of the job.

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

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)

+20ms Processing

Server:
win-1htud3sbs52:58728
Worker:
03a9f69a

+4h 22m Enqueued

Triggered by DelayedJobScheduler

+4ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 1:09:02 ص

+36ms Failed

An exception occurred during performance of the job.

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

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:86036
Worker:
69237919

+2m 14.976s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 1:04:08 ص

+37ms Failed

An exception occurred during performance of the job.

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

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:86036
Worker:
60100d1b

+44.967s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 1:01:48 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:86036
Worker:
706eb208

+29.963s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 1:00:59 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:86036
Worker:
f3b30b7e

+29.960s Enqueued

Triggered by DelayedJobScheduler

+4ms Scheduled

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

Enqueue at:
9‏‏/12‏‏/2025 1:00:30 ص

+36ms Failed

An exception occurred during performance of the job.

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

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:86036
Worker:
be23197c

+ <1ms Enqueued

Triggered by recurring job scheduler

9‏‏/12‏‏/2025 1:00:11 ص Created