Hangfire Dashboard

IEME4Service.CreateAndUpdateQuotes

// Id da Tarefa: #533787
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\":\"2024-06-25T14:33:01.2644884-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 
1719741480
CurrentCulture 
"pt-BR"
CurrentUICulture 
"pt-BR"
RetryCount 
10

Estado

30/06/2024 14:30:51 (+1.437s) 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.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.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 "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: 1968
    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.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:
4093cbfb3716:default:1
Worker:
a75ce933

+1h 54m Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 14:30:39

+1.476s 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.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.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 "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: 1968
    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.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:
4093cbfb3716:default:1
Worker:
3c385c5d

+1h 9m Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 12:35:57

+2.218s 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.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.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 "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: 1968
    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.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()

+11ms Processing

Server:
4093cbfb3716:default:1
Worker:
3c385c5d

+41m 46.640s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 11:27:03

+1.454s 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.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.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 "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: 1968
    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.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()

+11ms Processing

Server:
4093cbfb3716:default:1
Worker:
3c385c5d

+22m 45.098s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 10:45:12

+1.451s 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.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.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 "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: 1968
    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.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()

+11ms Processing

Server:
4093cbfb3716:default:1
Worker:
a9081ed8

+13m 29.351s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 10:22:18

+1.485s 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.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.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 "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: 1968
    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.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()

+11ms Processing

Server:
4093cbfb3716:default:1
Worker:
a75ce933

+5m 28.923s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 10:08:57

+1.449s 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.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.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 "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: 1968
    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.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()

+25ms Processing

Server:
4093cbfb3716:default:1
Worker:
3c385c5d

+2m 13.715s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 10:03:16

+1.450s 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.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.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 "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: 1968
    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.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:
4093cbfb3716:default:1
Worker:
a9081ed8

+1m 58.692s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 10:01:02

+1.431s 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.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.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 "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: 1968
    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.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()

+9ms Processing

Server:
4093cbfb3716:default:1
Worker:
a9081ed8

+43.590s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 09:59:13

+1.449s 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.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.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 "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: 1968
    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.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:
4093cbfb3716:default:1
Worker:
3c385c5d

+27.582s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+3ms Scheduled

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

Enqueue at:
30/06/2024 09:58:29

+1.454s 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.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.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 "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: 1968
    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.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:
4093cbfb3716:default:1
Worker:
a9081ed8

+10ms Enqueued

Triggered by recurring job scheduler

Queue:
default

30/06/2024 09:58:00 Created