RetrieveCancellationsTask.ProcessRecurringAsync

// Job ID: #6321029
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
1786444094
CurrentCulture
""
CurrentUICulture
""

State

08/11/2026 10:28:17 (+2.243s) 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 (14942, null, Shopify Parçalı İptal Talebi, 1, RF-998192251058, null, 41, 18587, 1, null, 0, null, 10, 2026-08-11 10:28:16.082455, 2026-08-11 10:28:16.082456, 1, 13218, null, null, 27, 7175371849906, 1, 2026-08-11 10:27:00, 16967425327282, SHP-#1424, 47642350616754, 61939, null, null, 0, 39, 951448, 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 (14942, null, Shopify Parçalı İptal Talebi, 1, RF-998192251058, null, 41, 18587, 1, null, 0, null, 10, 2026-08-11 10:28:16.082455, 2026-08-11 10:28:16.082456, 1, 13218, null, null, 27, 7175371849906, 1, 2026-08-11 10:27:00, 16967425327282, SHP-#1424, 47642350616754, 61939, null, null, 0, 39, 951448, 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)

+21ms Processing

Server:
ekol-py-int-tst-84d7fdcf88-xdqbt:1
Worker:
5216b677

+6ms Enqueued

Triggered by recurring job scheduler

Queue:
default

08/11/2026 10:28:14 Created