BaseJobs.AccrueTimeOffBalanceEntries

// Id: #64062
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 00:02:05 (+420ms) Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-5754c6c4f7-59lpr: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)

+151ms Processing

Server:
scheduler-deployment-5754c6c4f7-59lpr:1
Worker:
937e1e44

+59.971s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+79ms Scheduled

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

Enqueue at:
02/22/2026 00:02:01

+373ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-5754c6c4f7-59lpr: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)

+61ms Processing

Server:
scheduler-deployment-5754c6c4f7-59lpr:1
Worker:
937e1e44

+51.081s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+31ms Scheduled

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

Enqueue at:
02/22/2026 00:00:57

+848ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-5754c6c4f7-59lpr: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)

+138ms Processing

Server:
scheduler-deployment-5754c6c4f7-59lpr:1
Worker:
c3e11e4c

+103ms Enqueued

Queue:
alpha

02/22/2026 00:00:12 Created