BaseJobs.AccrueTimeOffBalanceEntries

// Id: #62593
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/18/2026 03:01:51 (+103ms) Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-6f7b599c74-8kzsf: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)

+37ms Processing

Server:
scheduler-deployment-6f7b599c74-8kzsf:1
Worker:
fcca4cee

+59.955s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+8ms Scheduled

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

Enqueue at:
02/18/2026 03:01:41

+90ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-6f7b599c74-8kzsf: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)

+37ms Processing

Server:
scheduler-deployment-6f7b599c74-8kzsf:1
Worker:
fcca4cee

+44.217s Enqueued

Triggered by DelayedJobScheduler

Queue:
alpha

+12ms Scheduled

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

Enqueue at:
02/18/2026 03:00:40

+183ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (scheduler-deployment-6f7b599c74-8kzsf: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)

+24ms Processing

Server:
scheduler-deployment-6f7b599c74-8kzsf:1
Worker:
a3d60df6

+15ms Enqueued

Queue:
alpha

02/18/2026 03:00:06 Created