CreateLeaveRequestsJob.ExecuteAsync

// Id: #798
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
1763514011

State

19‏‏/11‏‏/2025 5:35:27 ص (+50ms) Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
9b9cdef7

+1h 52m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 5:35:23 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
00f2c2b4

+1h 12m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 3:43:15 ص

+44ms Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
91859214

+40m 45.227s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 2:30:28 ص

+33ms Failed

An exception occurred during performance of the job.

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

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)

+7ms Processing

Server:
win-1htud3sbs52:18928
Worker:
e0d27816

+24m 15.097s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 1:49:45 ص

+43ms Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
cb991756

+12m 45.020s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 1:25:30 ص

+40ms Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
aa562b14

+6m 29.997s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 1:12:52 ص

+37ms Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
e81dea03

+3m 14.950s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 1:06:15 ص

+70ms Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
91859214

+1m 44.857s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 1:03:06 ص

+153ms Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
bfe60949

+29.757s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 1:01:20 ص

+247ms Failed

An exception occurred during performance of the job.

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

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:18928
Worker:
923a96fe

+42.260s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
19‏‏/11‏‏/2025 1:00:48 ص

+2.563s Failed

An exception occurred during performance of the job.

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

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)

+87ms Processing

Server:
win-1htud3sbs52:18928
Worker:
3dd0ed4d

+43ms Enqueued

Triggered by recurring job scheduler

19‏‏/11‏‏/2025 1:00:11 ص Created