Hangfire Dashboard

IEME4Service.CreateAndUpdateQuotes

// Id da Tarefa: #226182
using Datainfo.Supplier.Services.Infrastructure.Services;

var eME4Service = Activate<IEME4Service>();
await eME4Service.CreateAndUpdateQuotes(
    FromJson<UserDTO>("{\"Id\":1,\"FirstName\":\"Admin\",\"LastName\":\"Admin\",\"Login\":\"@Admin\",\"Email\":\"admin@admin.admin\",\"LastAccess\":\"2025-01-20T14:41:34.9979871-03:00\",\"UserRoles\":{\"$type\":\"Common.DTO.AuthDTO.UserRolesDto[], Common.DTO\",\"$values\":[{\"UserId\":1,\"RoleId\":1,\"Role\":{\"Name\":\"admin\"}}]},\"UserActivitys\":{\"$type\":\"Common.DTO.UserActivityDTO[], Common.DTO\",\"$values\":[]},\"Settings\":{}}"));

Parameters

RecurringJobId 
"IEME4Service.CreateAndUpdateQuotes"
Time 
1737551168
CurrentCulture 
"pt-BR"
CurrentUICulture 
"pt-BR"
RetryCount 
8

Estado

22/01/2025 14:36:34 (+85ms) Succeeded

Latency:
1h 30m
Duration:
71ms
Result:
{"$type":"Datainfo.Supplier.Entities.ResponseHangfireDTO, Datainfo.Supplier.Entities","Date":"2025-01-22T11:36:34.732972-03:00","State":3,"Description":"Erro","Cache":[{"Id":1,"Date":"2025-01-22T11:36:34.6766779-03:00","State":3,"Type":1,"Description":"M4Server - Marcas de produto não foram importadas."},{"Id":2,"Date":"2025-01-22T11:36:34.6871648-03:00","State":3,"Type":1,"Description":"M4Server - Condições de pagamento não foram importadas."},{"Id":3,"Date":"2025-01-22T11:36:34.7101033-03:00","State":3,"Type":2,"Description":"M4Server - Marcas de produto não foram importadas."},{"Id":4,"Date":"2025-01-22T11:36:34.7219753-03:00","State":3,"Type":2,"Description":"M4Server - Condições de pagamento não foram importadas."},{"Id":5,"Date":"2025-01-22T11:36:34.7329638-03:00","State":3,"Type":2,"Description":"Erro M4Server - Cotações não foram importadas."}],"CacheCount":5}

+12ms Processing

Server:
8820725a725d:default:1
Worker:
b8c2f546

+42m 2.366s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+2ms Scheduled

Retry attempt 8 of 10: An error occurred while updating the entries. See…

Enqueue at:
22/01/2025 14:36:24

+1.199s Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while updating the entries. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    SchemaName: PFD
    TableName: PaymentConditions
    ColumnName: CodPayment
    File: execMain.c
    Line: 2003
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, 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 Common.DataAccess.EFCore.BaseRepository`2.Edit(TType obj, ContextSession session) in /src/Common/Common.DataAccess.EFCore/Repositories/BaseRepository.cs:line 70
   at Datainfo.Supplier.Services.EME4Service.LogActivity(UserDTO userDTO, String method, String description, String typeRegister, String codRegister) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 214
   at Datainfo.Supplier.Services.EME4Service.CreateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4ServiceImport.cs:line 104
   at Datainfo.Supplier.Services.EME4Service.ExecuteHangfireJob(UserDTO user, EME4Function[] functions, HangfireManager manager) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 154
   at Datainfo.Supplier.Services.EME4Service.CreateAndUpdateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 126
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

+14ms Processing

Server:
8820725a725d:default:1
Worker:
a0fd0c7b

+25m 16.663s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+2ms Scheduled

Retry attempt 7 of 10: An error occurred while updating the entries. See…

Enqueue at:
22/01/2025 13:54:28

+1.206s Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while updating the entries. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    SchemaName: PFD
    TableName: PaymentConditions
    ColumnName: CodPayment
    File: execMain.c
    Line: 2003
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, 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 Common.DataAccess.EFCore.BaseRepository`2.Edit(TType obj, ContextSession session) in /src/Common/Common.DataAccess.EFCore/Repositories/BaseRepository.cs:line 70
   at Datainfo.Supplier.Services.EME4Service.LogActivity(UserDTO userDTO, String method, String description, String typeRegister, String codRegister) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 214
   at Datainfo.Supplier.Services.EME4Service.CreateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4ServiceImport.cs:line 104
   at Datainfo.Supplier.Services.EME4Service.ExecuteHangfireJob(UserDTO user, EME4Function[] functions, HangfireManager manager) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 154
   at Datainfo.Supplier.Services.EME4Service.CreateAndUpdateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 126
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

+16ms Processing

Server:
8820725a725d:default:1
Worker:
b8c2f546

+12m 46.997s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+2ms Scheduled

Retry attempt 6 of 10: An error occurred while updating the entries. See…

Enqueue at:
22/01/2025 13:29:12

+1.420s Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while updating the entries. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    SchemaName: PFD
    TableName: PaymentConditions
    ColumnName: CodPayment
    File: execMain.c
    Line: 2003
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, 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 Common.DataAccess.EFCore.BaseRepository`2.Edit(TType obj, ContextSession session) in /src/Common/Common.DataAccess.EFCore/Repositories/BaseRepository.cs:line 70
   at Datainfo.Supplier.Services.EME4Service.LogActivity(UserDTO userDTO, String method, String description, String typeRegister, String codRegister) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 214
   at Datainfo.Supplier.Services.EME4Service.CreateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4ServiceImport.cs:line 104
   at Datainfo.Supplier.Services.EME4Service.ExecuteHangfireJob(UserDTO user, EME4Function[] functions, HangfireManager manager) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 154
   at Datainfo.Supplier.Services.EME4Service.CreateAndUpdateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 126
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

+12ms Processing

Server:
8820725a725d:default:1
Worker:
a0fd0c7b

+4m 59.725s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+2ms Scheduled

Retry attempt 5 of 10: An error occurred while updating the entries. See…

Enqueue at:
22/01/2025 13:16:16

+1.194s Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while updating the entries. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    SchemaName: PFD
    TableName: PaymentConditions
    ColumnName: CodPayment
    File: execMain.c
    Line: 2003
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, 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 Common.DataAccess.EFCore.BaseRepository`2.Edit(TType obj, ContextSession session) in /src/Common/Common.DataAccess.EFCore/Repositories/BaseRepository.cs:line 70
   at Datainfo.Supplier.Services.EME4Service.LogActivity(UserDTO userDTO, String method, String description, String typeRegister, String codRegister) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 214
   at Datainfo.Supplier.Services.EME4Service.CreateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4ServiceImport.cs:line 104
   at Datainfo.Supplier.Services.EME4Service.ExecuteHangfireJob(UserDTO user, EME4Function[] functions, HangfireManager manager) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 154
   at Datainfo.Supplier.Services.EME4Service.CreateAndUpdateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 126
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

+13ms Processing

Server:
8820725a725d:default:1
Worker:
b8c2f546

+2m 29.058s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+2ms Scheduled

Retry attempt 4 of 10: An error occurred while updating the entries. See…

Enqueue at:
22/01/2025 13:11:14

+1.190s Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while updating the entries. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    SchemaName: PFD
    TableName: PaymentConditions
    ColumnName: CodPayment
    File: execMain.c
    Line: 2003
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, 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 Common.DataAccess.EFCore.BaseRepository`2.Edit(TType obj, ContextSession session) in /src/Common/Common.DataAccess.EFCore/Repositories/BaseRepository.cs:line 70
   at Datainfo.Supplier.Services.EME4Service.LogActivity(UserDTO userDTO, String method, String description, String typeRegister, String codRegister) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 214
   at Datainfo.Supplier.Services.EME4Service.CreateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4ServiceImport.cs:line 104
   at Datainfo.Supplier.Services.EME4Service.ExecuteHangfireJob(UserDTO user, EME4Function[] functions, HangfireManager manager) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 154
   at Datainfo.Supplier.Services.EME4Service.CreateAndUpdateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 126
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

+13ms Processing

Server:
8820725a725d:default:1
Worker:
b8c2f546

+58.852s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+2ms Scheduled

Retry attempt 3 of 10: An error occurred while updating the entries. See…

Enqueue at:
22/01/2025 13:08:43

+1.232s Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while updating the entries. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    SchemaName: PFD
    TableName: PaymentConditions
    ColumnName: CodPayment
    File: execMain.c
    Line: 2003
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, 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 Common.DataAccess.EFCore.BaseRepository`2.Edit(TType obj, ContextSession session) in /src/Common/Common.DataAccess.EFCore/Repositories/BaseRepository.cs:line 70
   at Datainfo.Supplier.Services.EME4Service.LogActivity(UserDTO userDTO, String method, String description, String typeRegister, String codRegister) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 214
   at Datainfo.Supplier.Services.EME4Service.CreateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4ServiceImport.cs:line 104
   at Datainfo.Supplier.Services.EME4Service.ExecuteHangfireJob(UserDTO user, EME4Function[] functions, HangfireManager manager) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 154
   at Datainfo.Supplier.Services.EME4Service.CreateAndUpdateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 126
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

+17ms Processing

Server:
8820725a725d:default:1
Worker:
a0fd0c7b

+1m 13.860s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+2ms Scheduled

Retry attempt 2 of 10: An error occurred while updating the entries. See…

Enqueue at:
22/01/2025 13:07:43

+1.230s Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while updating the entries. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    SchemaName: PFD
    TableName: PaymentConditions
    ColumnName: CodPayment
    File: execMain.c
    Line: 2003
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, 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 Common.DataAccess.EFCore.BaseRepository`2.Edit(TType obj, ContextSession session) in /src/Common/Common.DataAccess.EFCore/Repositories/BaseRepository.cs:line 70
   at Datainfo.Supplier.Services.EME4Service.LogActivity(UserDTO userDTO, String method, String description, String typeRegister, String codRegister) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 214
   at Datainfo.Supplier.Services.EME4Service.CreateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4ServiceImport.cs:line 104
   at Datainfo.Supplier.Services.EME4Service.ExecuteHangfireJob(UserDTO user, EME4Function[] functions, HangfireManager manager) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 154
   at Datainfo.Supplier.Services.EME4Service.CreateAndUpdateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 126
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

+14ms Processing

Server:
8820725a725d:default:1
Worker:
b8c2f546

+28.812s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+2ms Scheduled

Retry attempt 1 of 10: An error occurred while updating the entries. See…

Enqueue at:
22/01/2025 13:06:30

+1.229s Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException

An error occurred while updating the entries. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Npgsql.PostgresException (0x80004005): 23502: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
   at Npgsql.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 23502
    MessageText: null value in column "CodPayment" of relation "PaymentConditions" violates not-null constraint
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    SchemaName: PFD
    TableName: PaymentConditions
    ColumnName: CodPayment
    File: execMain.c
    Line: 2003
    Routine: ExecConstraints
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, 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 Common.DataAccess.EFCore.BaseRepository`2.Edit(TType obj, ContextSession session) in /src/Common/Common.DataAccess.EFCore/Repositories/BaseRepository.cs:line 70
   at Datainfo.Supplier.Services.EME4Service.LogActivity(UserDTO userDTO, String method, String description, String typeRegister, String codRegister) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 214
   at Datainfo.Supplier.Services.EME4Service.CreateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4ServiceImport.cs:line 104
   at Datainfo.Supplier.Services.EME4Service.ExecuteHangfireJob(UserDTO user, EME4Function[] functions, HangfireManager manager) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 154
   at Datainfo.Supplier.Services.EME4Service.CreateAndUpdateQuotes(UserDTO user) in /src/Business/Datainfo.Supplier.Services/EME4/EME4Service.cs:line 126
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

+26ms Processing

Server:
8820725a725d:default:1
Worker:
b8c2f546

+11ms Enqueued

Triggered by recurring job scheduler

Queue:
default

22/01/2025 13:06:08 Created