PurchaseAgent Jobs

Job

Can not find the target method.

Id 
#16679

Parameters

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

State

05/24/2026 18:35:08 (+28ms) Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-79f7ccdf96-76gw6: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-79f7ccdf96-76gw6:1
Worker:
42f5e263

+30m 3.687s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+2ms Scheduled

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

Enqueue at:
05/24/2026 18:35:04

+37ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-79f7ccdf96-76gw6: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)

+21ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-79f7ccdf96-76gw6:1
Worker:
42f5e263

+5m 2.682s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+6ms Scheduled

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

Enqueue at:
05/24/2026 18:05:02

+192ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-79f7ccdf96-76gw6: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)

+19ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-79f7ccdf96-76gw6:1
Worker:
42f5e263

+4ms Enqueued

Triggered by recurring job scheduler

Queue:
low

05/24/2026 18:00:01 Created