BaseJobs.AccrueTimeOffBalanceEntries

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

03/01/2026 21:01:23 (+104ms) Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-66bd49dd45-llmcj: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)

+28ms Processing

Server:
scheduler-deployment-66bd49dd45-llmcj:1
Worker:
7f7dde5d

+59.994s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+7ms Scheduled

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

Enqueue at:
03/01/2026 21:01:23

+83ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-66bd49dd45-llmcj: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)

+36ms Processing

Server:
scheduler-deployment-66bd49dd45-llmcj:1
Worker:
7f7dde5d

+17.841s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+6ms Scheduled

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

Enqueue at:
03/01/2026 21:00:23

+157ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-66bd49dd45-llmcj: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)

+86ms Processing

Server:
scheduler-deployment-66bd49dd45-llmcj:1
Worker:
2d2c5b79

+21ms Enqueued

Queue:
alpha

03/01/2026 21:00:05 Created