RetrieveCancellationsTask.ProcessRecurringAsync

// Job ID: #6238317
using EkolPY.Integration.Manager.Tasks;

var retrieveCancellationsTask = Activate<RetrieveCancellationsTask>();
await retrieveCancellationsTask.ProcessRecurringAsync(
    null,
    "default",
    FromJson<TaskType>("{\"Id\":37,\"SystemName\":\"RetrieveCancellations\",\"Name\":\"Sipariş iptallerinin çekilmesi\",\"JobClassName\":\"RetrieveCancellationsTask\",\"Type\":\"Recurring\",\"Cron\":\"*/2 * * * *\",\"AccountId\":1,\"SalesChannelOption\":1,\"AccountOption\":1,\"SalesChannelOptionEnum\":1,\"AccountOptionEnum\":1,\"CreatedOnUtc\":\"2023-05-22T15:26:29.407\",\"UpdatedOnUtc\":\"2023-05-22T15:26:29.407\",\"IsActive\":true,\"TaskTypeSalesChannel\":[{\"Id\":50,\"TaskTypeId\":37,\"SalesChannelId\":2,\"CreatedOnUtc\":\"2023-05-22T15:26:29.407\",\"UpdatedOnUtc\":\"2023-05-22T15:26:29.407\",\"IsActive\":true},{\"Id\":51,\"TaskTypeId\":37,\"SalesChannelId\":3,\"CreatedOnUtc\":\"2023-05-22T15:26:29.407\",\"UpdatedOnUtc\":\"2023-05-22T15:26:29.407\",\"IsActive\":true},{\"Id\":52,\"TaskTypeId\":37,\"SalesChannelId\":14,\"CreatedOnUtc\":\"2023-05-22T15:26:29.407\",\"UpdatedOnUtc\":\"2023-05-22T15:26:29.407\",\"IsActive\":true},{\"Id\":49,\"TaskTypeId\":37,\"SalesChannelId\":1,\"CreatedOnUtc\":\"2023-05-22T15:26:29.407\",\"UpdatedOnUtc\":\"2023-05-22T15:26:29.407\",\"IsActive\":false},{\"Id\":104,\"TaskTypeId\":37,\"SalesChannelId\":7,\"CreatedOnUtc\":\"2023-05-22T15:26:29.407\",\"UpdatedOnUtc\":\"2023-05-22T15:26:29.407\",\"IsActive\":true},{\"Id\":184,\"TaskTypeId\":37,\"SalesChannelId\":15,\"CreatedOnUtc\":\"2023-05-22T15:26:29.407\",\"UpdatedOnUtc\":\"2023-05-22T15:26:29.407\",\"IsActive\":true},{\"Id\":309,\"TaskTypeId\":37,\"SalesChannelId\":27,\"CreatedOnUtc\":\"2026-06-29T11:15:02.579574\",\"UpdatedOnUtc\":\"2026-06-29T11:15:02.579574\",\"IsActive\":true}]}"));

Parameters

RecurringJobId
"RetrieveCancellations"
Time
1786086602
CurrentCulture
""
CurrentUICulture
""

State

08/07/2026 07:10:10 (+4.164s) Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "ReasonForCancel" of relation "CancelRequest" violates not-null constraint

DETAIL: Failing row contains (14925, null, Shopify Parçalı İptal Talebi, 1, RF-997570314418, null, 41, 18490, 1, null, 0, null, 10, 2026-08-07 07:10:09.0989, 2026-08-07 07:10:09.098946, 1, 13133, null, null, 27, 7164066988210, 1, 2026-08-06 08:11:02, 16940449038514, SHP-#1353, 47642350616754, 61939, null, null, 0, 39, 951376, null, f).
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|215_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, 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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "ReasonForCancel" of relation "CancelRequest" violates not-null constraint
    Detail: Failing row contains (14925, null, Shopify Parçalı İptal Talebi, 1, RF-997570314418, null, 41, 18490, 1, null, 0, null, 10, 2026-08-07 07:10:09.0989, 2026-08-07 07:10:09.098946, 1, 13133, null, null, 27, 7164066988210, 1, 2026-08-06 08:11:02, 16940449038514, SHP-#1353, 47642350616754, 61939, null, null, 0, 39, 951376, null, f).
    SchemaName: public
    TableName: CancelRequest
    ColumnName: ReasonForCancel
    File: execMain.c
    Line: 2063
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at EkolPY.Integration.Service.IntegrationTaskService.SaveTaskAsync() in /src/Integration/EkolPY.Integration.Service/IntegrationService.cs:line 271
   at EkolPY.Integration.Service.IntegrationTaskService.SetFailedAsync() in /src/Integration/EkolPY.Integration.Service/IntegrationService.cs:line 251
   at EkolPY.Integration.Service.IntegrationTaskService.SetFailedWithException(String message, Exception ex) in /src/Integration/EkolPY.Integration.Service/IntegrationService.cs:line 265
   at EkolPY.Integration.Manager.TaskBase`1.ProcessRecurringAsync(PerformContext context, String queueName, TaskType taskType) in /src/Integration/EkolPY.Integration.Manager/TaskBase.cs:line 159
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

+3.585s Processing

Server:
ekol-py-int-tst-78c6d7f8c6-hx9vl:1
Worker:
a4cd0fc3

+5ms Enqueued

Triggered by recurring job scheduler

Queue:
default

08/07/2026 07:10:02 Created