CreateLeaveRequestsJob.ExecuteAsync

// Id: #910
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
1764810006

State

4‏‏/12‏‏/2025 12:50:51 م (+2.470s) Failed

An exception occurred during performance of the job.

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

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:111180
Worker:
847dabee

+9h 12m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 5:31:43 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
6142999c

+1h 10m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 3:38:29 ص

+36ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
90126983

+41m 207ms Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 2:28:33 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
d6723963

+25m 15.110s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 1:47:29 ص

+43ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
35e71474

+11m 30.027s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 1:22:08 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
c11ea6a6

+5m 29.990s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 1:10:37 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
f4d72a62

+2m 59.980s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 1:05:17 ص

+36ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
90126983

+59.966s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 1:02:13 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
6f3acbf3

+29.964s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 1:01:11 ص

+36ms Failed

An exception occurred during performance of the job.

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

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)

+7ms Processing

Server:
win-1htud3sbs52:138828
Worker:
f8ad73cd

+44.957s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
4‏‏/12‏‏/2025 1:00:37 ص

+43ms Failed

An exception occurred during performance of the job.

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

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:138828
Worker:
f6bf19c1

+ <1ms Enqueued

Triggered by recurring job scheduler

4‏‏/12‏‏/2025 1:00:06 ص Created