JobAutomacaoEncerramentoCotacaoGeapService.ProcessarAutomacao

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

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

Parameters

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

State

07/30/2026 12:01:08 (+847ms) Failed

An exception occurred during performance of the job.

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

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 535
   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 205
   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:20676
Worker:
f661b023

+57.856s Enqueued

Triggered via Dashboard UI

+1.254s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (94ed2b2cfd31.staging:1)

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 /src/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 /src/Inpart.Integracao.GerenciadorJobs/Services/AutomacaoEncerramentoCotacaoGeap/JobAutomacaoEncerramentoCotacaoGeapService.cs:line 231
   at Inpart.Integracao.GerenciadorJobs.Services.AutomacaoEncerramentoCotacaoGeap.JobAutomacaoEncerramentoCotacaoGeapService.ProcessarAutomacao() in /src/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)

+70ms Processing

Server:
94ed2b2cfd31.staging:1
Worker:
d11fd641

+20ms Enqueued

Triggered by recurring job scheduler

07/30/2026 12:00:08 Created