Hangfire Dashboard

DataCloud scheduler Robos job: app

// Job ID: #62118
using LegalOne.Lib.Queue.Hangfire.Queues;

var dataCloudSchedulerRobosQueueResolver = Activate<DataCloudSchedulerRobosQueueResolver<DataCloudSchedulerJob,TaskQueueItemParam<DataCloudScheduleQueueItem>>>();
dataCloudSchedulerRobosQueueResolver.Run(
    "DataCloud scheduler Robos job: app",
    FromJson<TaskQueueItemParam`1>("{\"ReportModelId\":0,\"ReportId\":0,\"AppIdInstance\":0,\"Parameter\":{\"Id\":1271,\"IdMonHorarioAgendadorApp\":5,\"TimeZoneIdentiy\":\"E. South America Standard Time\",\"SchedulerType\":0,\"DataBaseName\":\"NOVAJUS_FULL_8199314_0310\",\"DataBaseServer\":\"legalone-maintenance.database.windows.net\",\"AppIdInstancia\":8192195,\"OfficeName\":\"app\",\"ManagerIdentifier\":\"d6aa84a2-9db3-450c-afa6-97f6dd95f9c3\",\"UtcDifference\":-180,\"EnqueuedDate\":\"2022-10-08T18:18:00.1392356Z\"},\"ReportIdentifier\":null,\"TransactionId\":null,\"Tenancy\":\"app\",\"TenantIdentifier\":null,\"UserId\":-1,\"BatchId\":null,\"OperationId\":\"CZjhUcLDQ9Q=\",\"EnqueueTime\":\"2025-12-12T15:18:57.6530095-03:00\",\"MutexIdentifier\":null,\"QueueType\":null}"),
    null);
BatchId
"ce38476a-a7cf-4904-a25c-96495ee047ac"
CurrentCulture
"pt-BR"
CurrentUICulture
"pt-BR"

State

08/10/2022 21:18:01 (+703ms) Failed

An exception occurred during performance of the job.

System.ApplicationException

Error on DataCloud scheduler Robos job: app. See inner exception for more details.

System.ApplicationException: Error on DataCloud scheduler Robos job: app. See inner exception for more details. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MON_HR_AGDR_LOG_001". The conflict occurred in database "NOVAJUS_FULL_8199314_0310", table "dbo.MON_HorarioAgendador", column 'Id'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at LegalOne.Lib.Mvc.Database.AbstractDatabaseProvider.ExecuteQueryInternally(DbConnection connection, String sql, Action`1 readerAction, DbTransaction optionalTransaction, Nullable`1 commandTimeout, DbParameter[] parameters) in C:\Agent\1\_work\24\s\LegalOne\LegalOne.Infrastructure\Database\AbstractDatabaseProvider.cs:line 226
   at LegalOne.Lib.Mvc.Database.AbstractDatabaseProvider.ExecuteNonQuery(DbConnection connection, String sql, DbParameter[] parameters) in C:\Agent\1\_work\24\s\LegalOne\LegalOne.Infrastructure\Database\AbstractDatabaseProvider.cs:line 138
   at LegalOne.Lib.Schedulers.DataCloud.Robos.GerenciadorTarefa.GerenciadorTarefasRobosNovaJus.NotificaInicioTarefa(Tarefa tarefa) in C:\Agent\1\_work\24\s\LegalOne\LegalOne.Lib\Schedulers\DataCloud\Robos\GerenciadorTarefas\GerenciadorTarefasRobosNovaJus.cs:line 159
   at LegalOne.Lib.Schedulers.DataCloud.DataCloudSchedulerJob.Run(TaskQueueItemParam`1 param) in C:\Agent\1\_work\24\s\LegalOne\LegalOne.Lib\Schedulers\DataCloud\DataCloudSchedulerJob.cs:line 172
   at LegalOne.Lib.Queue.Hangfire.TaskQueueResolver`2.Execute(TTask task, TTaskParam parameter, Exception& exception) in C:\Agent\1\_work\24\s\LegalOne\LegalOne.Lib\Queue\Hangfire\TaskQueueResolver.cs:line 161
   --- End of inner exception stack trace ---
   at LegalOne.Lib.Queue.Hangfire.TaskQueueResolver`2.Run(String jobDescription, TTaskParam parameter, IJobCancellationToken cancellationToken) in C:\Agent\1\_work\24\s\LegalOne\LegalOne.Lib\Queue\Hangfire\TaskQueueResolver.cs:line 139

+250ms Processing

Server:
pd1mdwk000504:7408
Worker:
ba2174ee

+ <1ms Enqueued

Queue:
datacloud_scheduler_robos_jobs

08/10/2022 21:18:00 Created