BaseJobs.AccrueTimeOffBalanceEntries

// Id: #64350
using Timetta.Infrastructure.Scheduler.Jobs;

var baseJobs = Activate<BaseJobs>();
await baseJobs.AccrueTimeOffBalanceEntries(
    FromJson<TenantInfo>("{\"Id\":\"dd2327c7-ec89-4e94-9ffa-157a7c98140e\",\"PrimaryDomain\":\"domain.com\"}"));

Parameters

CurrentCulture
""
CurrentUICulture
""
RetryCount
2

State

02/22/2026 18:01:52 (+108ms) Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-5d957d8588-sqw8f:1)

42703: column r.subcontractor_id does not exist POSITION: 1486

Npgsql.PostgresException: 42703: column r.subcontractor_id does not exist

POSITION: 1486
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   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 Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.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 Red.WorkPoint.Services.TimeOffBalanceModuleService.AccrueTimeOffBalanceEntries() in /src/Timetta.Domain.Aggregates/Services/ModuleServices/TimeOffBalanceModuleService.cs:line 54
   at Red.WorkPoint.Services.TimeOffBalanceModuleService.AccrueTimeOffBalanceEntries() in /src/Timetta.Domain.Aggregates/Services/ModuleServices/TimeOffBalanceModuleService.cs:line 110
   at Timetta.Infrastructure.Scheduler.Jobs.BaseJobs.AccrueTimeOffBalanceEntries(TenantInfo tenant) in /src/Timetta.Infrastructure.Scheduler/Jobs/BaseJobs.cs:line 156
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+51ms Processing

Server:
scheduler-deployment-5d957d8588-sqw8f:1
Worker:
10918d67

+1m 14.932s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+7ms Scheduled

Retry attempt 2 of 2: 42703: column r.subcontractor_id does not exist …

Enqueue at:
02/22/2026 18:01:45

+115ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-5d957d8588-sqw8f:1)

42703: column r.subcontractor_id does not exist POSITION: 1486

Npgsql.PostgresException: 42703: column r.subcontractor_id does not exist

POSITION: 1486
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   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 Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.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 Red.WorkPoint.Services.TimeOffBalanceModuleService.AccrueTimeOffBalanceEntries() in /src/Timetta.Domain.Aggregates/Services/ModuleServices/TimeOffBalanceModuleService.cs:line 54
   at Red.WorkPoint.Services.TimeOffBalanceModuleService.AccrueTimeOffBalanceEntries() in /src/Timetta.Domain.Aggregates/Services/ModuleServices/TimeOffBalanceModuleService.cs:line 110
   at Timetta.Infrastructure.Scheduler.Jobs.BaseJobs.AccrueTimeOffBalanceEntries(TenantInfo tenant) in /src/Timetta.Infrastructure.Scheduler/Jobs/BaseJobs.cs:line 156
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+30ms Processing

Server:
scheduler-deployment-5d957d8588-sqw8f:1
Worker:
a066df0b

+30.657s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+5ms Scheduled

Retry attempt 1 of 2: 42703: column r.subcontractor_id does not exist …

Enqueue at:
02/22/2026 18:00:27

+222ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-5d957d8588-sqw8f:1)

42703: column r.subcontractor_id does not exist POSITION: 1486

Npgsql.PostgresException: 42703: column r.subcontractor_id does not exist

POSITION: 1486
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   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 Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.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 Red.WorkPoint.Services.TimeOffBalanceModuleService.AccrueTimeOffBalanceEntries() in /src/Timetta.Domain.Aggregates/Services/ModuleServices/TimeOffBalanceModuleService.cs:line 54
   at Red.WorkPoint.Services.TimeOffBalanceModuleService.AccrueTimeOffBalanceEntries() in /src/Timetta.Domain.Aggregates/Services/ModuleServices/TimeOffBalanceModuleService.cs:line 110
   at Timetta.Infrastructure.Scheduler.Jobs.BaseJobs.AccrueTimeOffBalanceEntries(TenantInfo tenant) in /src/Timetta.Infrastructure.Scheduler/Jobs/BaseJobs.cs:line 156
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+53ms Processing

Server:
scheduler-deployment-5d957d8588-sqw8f:1
Worker:
45feb3a7

+51ms Enqueued

Queue:
alpha

02/22/2026 18:00:05 Created