BaseJobs.AccrueTimeOffBalanceEntries

// Id: #66929
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 12:01:36 (+108ms) 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)

+35ms Processing

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

+29.770s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+35ms Scheduled

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

Enqueue at:
03/01/2026 12:01:28

+209ms 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)

+77ms Processing

Server:
scheduler-deployment-66bd49dd45-llmcj:1
Worker:
9b1cacbf

+52.734s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+9ms Scheduled

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

Enqueue at:
03/01/2026 12:00:57

+204ms 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)

+23ms Processing

Server:
scheduler-deployment-66bd49dd45-llmcj:1
Worker:
5ecad255

+13ms Enqueued

Queue:
alpha

03/01/2026 12:00:13 Created