CreateLeaveRequestsJob.ExecuteAsync

// Id: #750
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
1762995607

State

13‏‏/11‏‏/2025 5:34:54 ص (+50ms) Failed

An exception occurred during performance of the job.

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

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:147272
Worker:
5564234b

+1h 53m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 5:34:44 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:147272
Worker:
8b228d6b

+1h 11m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 3:41:27 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:147272
Worker:
4266b00e

+43m 223ms Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 2:30:18 ص

+37ms Failed

An exception occurred during performance of the job.

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

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)

+ <1ms Processing

Server:
win-1htud3sbs52:147272
Worker:
a52d1b88

+23m 45.097s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 1:47:20 ص

+43ms Failed

An exception occurred during performance of the job.

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

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)

+10ms Processing

Server:
win-1htud3sbs52:147272
Worker:
b171e32f

+12m 40ms Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 1:23:35 ص

+37ms Failed

An exception occurred during performance of the job.

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

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:147272
Worker:
d70b9ab4

+6m 29.993s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 1:11:23 ص

+50ms Failed

An exception occurred during performance of the job.

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

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)

+4ms Processing

Server:
win-1htud3sbs52:147272
Worker:
8feacb7f

+2m 14.973s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 1:05:04 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:147272
Worker:
4266b00e

+59.877s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 1:02:44 ص

+130ms Failed

An exception occurred during performance of the job.

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

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)

+ <1ms Processing

Server:
win-1htud3sbs52:147272
Worker:
31c456ef

+44.807s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 1:01:41 ص

+197ms Failed

An exception occurred during performance of the job.

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

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:147272
Worker:
34da8ff1

+57.393s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
13‏‏/11‏‏/2025 1:00:54 ص

+2.520s Failed

An exception occurred during performance of the job.

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

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)

+44ms Processing

Server:
win-1htud3sbs52:147272
Worker:
8e0a9003

+36ms Enqueued

Triggered by recurring job scheduler

13‏‏/11‏‏/2025 1:00:07 ص Created