Hangfire Dashboard

DashboardKrSnapshotRecalcJob.ExecuteAsync

The job is finished. It will be removed automatically 01/01/0001 00:00:00. 
// Id: #1223
using PD_Api.Jobs;

var dashboardKrSnapshotRecalcJob = Activate<DashboardKrSnapshotRecalcJob>();
await dashboardKrSnapshotRecalcJob.ExecuteAsync(40, 955, 1);

Parameters

CurrentCulture 
"pt-BR"
CurrentUICulture 
"pt-BR"
RetryCount 
10

State

03/30/2026 21:35:13 (+390ms) Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (911bd34a0b8f:1)

Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))

MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
   at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
   at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
   at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
   at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
   at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
   at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken)
   at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 214
   at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45
   at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+6.119s Processing

Server:
911bd34a0b8f:1
Worker:
d1cd8ff8

+1h 50m Enqueued

Triggered by DelayedJobScheduler

+8ms Scheduled

Retry attempt 10 of 10: Cannot add or update a child row: a foreign key c…

Enqueue at:
03/30/2026 21:34:20

+330ms Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (911bd34a0b8f:1)

Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))

MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_dev`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
   at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894
   at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37
   at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
   at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483
   at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
   at MySqlConnector.MySqlCommand.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken)
   at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 214
   at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45
   at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+10.911s Processing

Server:
911bd34a0b8f:1
Worker:
d1cd8ff8

+1h 10m Enqueued

Triggered by DelayedJobScheduler

+9ms Scheduled

Retry attempt 9 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 19:43:19

+40m 19.429s Failed

Can not change the state to 'Enqueued': target method was not found.

System.InvalidOperationException (5962cba3cea8:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+17ms Scheduled

Retry attempt 8 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 18:34:36

+23m 34.333s Failed

Can not change the state to 'Enqueued': target method was not found.

System.InvalidOperationException (5962cba3cea8:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+9ms Scheduled

Retry attempt 7 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 17:52:57

+10m 45.815s Failed

Can not change the state to 'Enqueued': target method was not found.

System.InvalidOperationException (6a276eaeb3c0:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+9ms Scheduled

Retry attempt 6 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 17:30:18

+4m 15.370s Failed

Can not change the state to 'Enqueued': target method was not found.

System.InvalidOperationException (6a276eaeb3c0:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+9ms Scheduled

Retry attempt 5 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 17:19:57

+2m 221ms Failed

Can not change the state to 'Enqueued': target method was not found.

System.InvalidOperationException (6a276eaeb3c0:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+8ms Scheduled

Retry attempt 4 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 17:15:16

+2m 15.235s Failed

Can not change the state to 'Enqueued': target method was not found.

System.InvalidOperationException (6a276eaeb3c0:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+8ms Scheduled

Retry attempt 3 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 17:11:53

+64ms Failed

Can not change the state to 'Enqueued': target method was not found.

System.InvalidOperationException (6a276eaeb3c0:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+9ms Scheduled

Retry attempt 2 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 17:11:03

+36.369s Failed

Can not change the state to 'Enqueued': target method was not found.

System.InvalidOperationException (6a276eaeb3c0:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+7ms Scheduled

Retry attempt 1 of 10: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJo…

Enqueue at:
03/30/2026 17:10:19

+3.787s Failed

Can not change the state to 'Processing': target method was not found.

System.InvalidOperationException (6a276eaeb3c0:1)

The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`

System.InvalidOperationException: The type `PD_Api.Jobs.DashboardKrSnapshotRecalcJob` does not contain a method with signature `ExecuteAsync(UInt32, Nullable`1, Nullable`1)`
   at Hangfire.Storage.InvocationData.<>c.<CachedDeserializeMethod>b__33_0(MethodDeserializerCacheKey key) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 350
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Hangfire.Storage.InvocationData.CachedDeserializeMethod(Func`2 typeResolver, String typeName, String methodName, String parameterTypes, Type& type, MethodInfo& methodInfo) in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 335
   at Hangfire.Storage.InvocationData.DeserializeJob() in C:\projects\hangfire-525\src\Hangfire.Core\Storage\InvocationData.cs:line 100

+174ms Enqueued

03/30/2026 17:09:45 Created