Failed jobs do not become expired to allow you to re-queue them without any
time pressure. You should re-queue or delete them manually, or apply AutomaticRetry(OnAttemptsExceeded = AttemptsExceededAction.Delete)
attribute to delete them automatically.
An exception occurred during performance of the job. Fewer details...
07/16/2026 00:32:16
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 789
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 886
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/16/2026 00:15:15
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 789
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 886
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/16/2026 00:19:30
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 789
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 886
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/15/2026 23:00:38
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 789
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 886
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/15/2026 22:32:51
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 789
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 886
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/13/2026 17:56:14
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 785
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 882
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/13/2026 17:56:08
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 785
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 882
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at System.RuntimeMethodHandle.InvokeMethod(Objecttarget, Void**arguments, Signaturesig, BooleanisConstructor)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/13/2026 17:06:45
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 785
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 882
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at System.RuntimeMethodHandle.InvokeMethod(Objecttarget, Void**arguments, Signaturesig, BooleanisConstructor)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/10/2026 23:32:32
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 781
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 878
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at System.RuntimeMethodHandle.InvokeMethod(Objecttarget, Void**arguments, Signaturesig, BooleanisConstructor)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
An exception occurred during performance of the job. More details...
07/10/2026 22:37:12
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. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_id`))
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehaviorioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
at MySqlConnector.MySqlDataReader.InitAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, IDictionary`2cachedProcedures, IMySqlCommandcommand, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPositioncommandListPosition, ICommandPayloadCreatorpayloadCreator, CommandBehaviorbehavior, Activityactivity, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehaviorbehavior, IOBehaviorioBehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357
at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehaviorbehavior, CancellationTokencancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 781
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1operations, Func`1errorCallback, CancellationTokencancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32outraEmpresaId, Func`1func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 878
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32projetoId, UInt32usuarioPromotorId, UInt32empresaId, StringfaseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)