PurchaseAgent Jobs

Job

Can not find the target method.

Id 
#2445

Parameters

RecurringJobId 
"govapi.mfds.sync"
Time 
1779040803
CurrentCulture 
""
RetryCount 
2

State

05/17/2026 18:35:10 (+27ms) Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-7987458f6-j7r6z:1)

42P01: relation "cosmetic_ingredients" does not exist POSITION: 122

Npgsql.PostgresException: 42P01: relation "cosmetic_ingredients" does not exist

POSITION: 122
   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.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at PurchaseAgent.Application.GovApi.Mfds.MfdsIngredientSyncJob.UpsertAsync(IReadOnlyList`1 ingredients, CancellationToken ct) in /src/src/PurchaseAgent.Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 75
   at PurchaseAgent.Application.GovApi.Mfds.MfdsIngredientSyncJob.RunAsync(CancellationToken ct) in /src/src/PurchaseAgent.Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 50
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+16ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-7987458f6-j7r6z:1
Worker:
4958a455

+30m 3.680s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+4ms Scheduled

Retry attempt 2 of 2: 42P01: relation "cosmetic_ingredients" does not e…

Enqueue at:
05/17/2026 18:35:06

+41ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-7987458f6-j7r6z:1)

42P01: relation "cosmetic_ingredients" does not exist POSITION: 122

Npgsql.PostgresException: 42P01: relation "cosmetic_ingredients" does not exist

POSITION: 122
   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.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at PurchaseAgent.Application.GovApi.Mfds.MfdsIngredientSyncJob.UpsertAsync(IReadOnlyList`1 ingredients, CancellationToken ct) in /src/src/PurchaseAgent.Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 75
   at PurchaseAgent.Application.GovApi.Mfds.MfdsIngredientSyncJob.RunAsync(CancellationToken ct) in /src/src/PurchaseAgent.Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 50
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+16ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-7987458f6-j7r6z:1
Worker:
4958a455

+5m 2.341s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+5ms Scheduled

Retry attempt 1 of 2: 42P01: relation "cosmetic_ingredients" does not e…

Enqueue at:
05/17/2026 18:05:04

+243ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-7987458f6-j7r6z:1)

42P01: relation "cosmetic_ingredients" does not exist POSITION: 122

Npgsql.PostgresException: 42P01: relation "cosmetic_ingredients" does not exist

POSITION: 122
   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.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at PurchaseAgent.Application.GovApi.Mfds.MfdsIngredientSyncJob.UpsertAsync(IReadOnlyList`1 ingredients, CancellationToken ct) in /src/src/PurchaseAgent.Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 75
   at PurchaseAgent.Application.GovApi.Mfds.MfdsIngredientSyncJob.RunAsync(CancellationToken ct) in /src/src/PurchaseAgent.Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 50
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+31ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-7987458f6-j7r6z:1
Worker:
4958a455

+4ms Enqueued

Triggered by recurring job scheduler

Queue:
low

05/17/2026 18:00:03 Created