JobAutomacaoEncerramentoCotacaoGeapService.ProcessarAutomacao

// Id: #9138102
using Inpart.Integracao.GerenciadorJobs.Services.AutomacaoEncerramentoCotacaoGeap;

var jobAutomacaoEncerramentoCotacaoGeapService = Activate<JobAutomacaoEncerramentoCotacaoGeapService>();
await jobAutomacaoEncerramentoCotacaoGeapService.ProcessarAutomacao();

Parameters

CurrentCulture
""
RecurringJobId
"automacao-encerramento-cotacao-geap"
Time
1785331880

State

07/29/2026 14:40:30 (+577ms) Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (desktop-qarb8l0.staging:6044)

Conversion failed when converting date and/or time from character string.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
   at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod)
   at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<InternalExecuteNonQueryAsync>b__193_1(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   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.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Inpart.Integracao.GerenciadorJobs.Services.AutomacaoEncerramentoCotacaoGeap.JobAutomacaoEncerramentoCotacaoGeapService.MarcarNecessarioAnalise(CotacaoCandidataAutomacao cotacao, List`1 resultadosItens, List`1 histsPendentes) in C:\Users\Ber\Documents\Inpart\Inpart.Integracao.GerenciadorJobs\Inpart.Integracao.GerenciadorJobs\Services\AutomacaoEncerramentoCotacaoGeap\JobAutomacaoEncerramentoCotacaoGeapService.cs:line 561
   at Inpart.Integracao.GerenciadorJobs.Services.AutomacaoEncerramentoCotacaoGeap.JobAutomacaoEncerramentoCotacaoGeapService.ProcessarCotacao(CotacaoCandidataAutomacao cotacao, Dictionary`2 regrasPorDistribuidor, Dictionary`2 mediasGeap, List`1 logsPendentes, List`1 histsPendentes) in C:\Users\Ber\Documents\Inpart\Inpart.Integracao.GerenciadorJobs\Inpart.Integracao.GerenciadorJobs\Services\AutomacaoEncerramentoCotacaoGeap\JobAutomacaoEncerramentoCotacaoGeapService.cs:line 340
   at Inpart.Integracao.GerenciadorJobs.Services.AutomacaoEncerramentoCotacaoGeap.JobAutomacaoEncerramentoCotacaoGeapService.ProcessarAutomacao() in C:\Users\Ber\Documents\Inpart\Inpart.Integracao.GerenciadorJobs\Inpart.Integracao.GerenciadorJobs\Services\AutomacaoEncerramentoCotacaoGeap\JobAutomacaoEncerramentoCotacaoGeapService.cs:line 91
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+77ms Processing

Server:
desktop-qarb8l0.staging:6044
Worker:
9d044efa

+14.543s Enqueued

Triggered via Dashboard UI

+590ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (desktop-qarb8l0.staging:6044)

Conversion failed when converting date and/or time from character string.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
   at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod)
   at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<InternalExecuteNonQueryAsync>b__193_1(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   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.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Inpart.Integracao.GerenciadorJobs.Services.AutomacaoEncerramentoCotacaoGeap.JobAutomacaoEncerramentoCotacaoGeapService.MarcarNecessarioAnalise(CotacaoCandidataAutomacao cotacao, List`1 resultadosItens, List`1 histsPendentes) in C:\Users\Ber\Documents\Inpart\Inpart.Integracao.GerenciadorJobs\Inpart.Integracao.GerenciadorJobs\Services\AutomacaoEncerramentoCotacaoGeap\JobAutomacaoEncerramentoCotacaoGeapService.cs:line 561
   at Inpart.Integracao.GerenciadorJobs.Services.AutomacaoEncerramentoCotacaoGeap.JobAutomacaoEncerramentoCotacaoGeapService.ProcessarCotacao(CotacaoCandidataAutomacao cotacao, Dictionary`2 regrasPorDistribuidor, Dictionary`2 mediasGeap, List`1 logsPendentes, List`1 histsPendentes) in C:\Users\Ber\Documents\Inpart\Inpart.Integracao.GerenciadorJobs\Inpart.Integracao.GerenciadorJobs\Services\AutomacaoEncerramentoCotacaoGeap\JobAutomacaoEncerramentoCotacaoGeapService.cs:line 340
   at Inpart.Integracao.GerenciadorJobs.Services.AutomacaoEncerramentoCotacaoGeap.JobAutomacaoEncerramentoCotacaoGeapService.ProcessarAutomacao() in C:\Users\Ber\Documents\Inpart\Inpart.Integracao.GerenciadorJobs\Inpart.Integracao.GerenciadorJobs\Services\AutomacaoEncerramentoCotacaoGeap\JobAutomacaoEncerramentoCotacaoGeapService.cs:line 91
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+73ms Processing

Server:
desktop-qarb8l0.staging:6044
Worker:
562ea128

+1h 8m Enqueued

Triggered via Dashboard UI

+847ms Succeeded

Latency:
415ms
Duration:
800ms

+147ms Processing

Server:
a52b5379a649.staging:1
Worker:
93ccc3b5

+233ms Enqueued

Triggered by recurring job scheduler

07/29/2026 13:31:21 Created