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.
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, SqlCommandcommand, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehaviorrunBehavior, SqlCommandcmdHandler, SqlDataReaderdataStream, BulkCopySimpleResultSetbulkCopyHandler, TdsParserStateObjectstateObj, Boolean&dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReaderds, RunBehaviorrunBehavior, StringresetOptionsString, BooleanisInternal, BooleanforDescribeParameterEncryption, BooleanshouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehaviorrunBehavior, BooleanreturnStream, BooleanisAsync, Int32timeout, Task&task, BooleanasyncWrite, BooleaninRetry, SqlDataReaderds, BooleandescribeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehaviorcmdBehavior, RunBehaviorrunBehavior, BooleanreturnStream, TaskCompletionSource`1completion, Int32timeout, Task&task, Boolean&usedCache, BooleanasyncWrite, BooleaninRetry, Stringmethod)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehaviorbehavior)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumeratorenumerator)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func`3operation, Func`3verifySucceeded, TStatestate)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at Inpart.Integracao.GerenciadorJobs.Services.JobFaturamentoDiretoService.Executar_px_IntegracaoCirurgia() in /src/Inpart.Integracao.GerenciadorJobs/Services/JobFaturamentoDiretoService.cs:line 51
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, SqlCommandcommand, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehaviorrunBehavior, SqlCommandcmdHandler, SqlDataReaderdataStream, BulkCopySimpleResultSetbulkCopyHandler, TdsParserStateObjectstateObj, Boolean&dataReady)
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReaderds, RunBehaviorrunBehavior, StringresetOptionsString, BooleanisInternal, BooleanforDescribeParameterEncryption, BooleanshouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehaviorrunBehavior, BooleanreturnStream, BooleanisAsync, Int32timeout, Task&task, BooleanasyncWrite, BooleaninRetry, SqlDataReaderds, BooleandescribeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehaviorcmdBehavior, RunBehaviorrunBehavior, BooleanreturnStream, TaskCompletionSource`1completion, Int32timeout, Task&task, Boolean&usedCache, BooleanasyncWrite, BooleaninRetry, Stringmethod)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dapper.SqlMapper.ExecuteCommand(IDbConnectioncnn, CommandDefinition&command, Action`2paramReader) in /_/Dapper/SqlMapper.cs:line 2965
at Dapper.SqlMapper.ExecuteImpl(IDbConnectioncnn, CommandDefinition&command) in /_/Dapper/SqlMapper.cs:line 656
at Hangfire.SqlServer.SqlServerDistributedLock.Acquire(DbConnectionconnection, Stringresource, TimeSpantimeout) in C:\projects\hangfire-525\src\Hangfire.SqlServer\SqlServerDistributedLock.cs:line 202
at Hangfire.SqlServer.SqlServerConnection.AcquireLock(Stringresource, TimeSpantimeout) in C:\projects\hangfire-525\src\Hangfire.SqlServer\SqlServerConnection.cs:line 731
at Hangfire.DisableConcurrentExecutionAttribute.OnPerforming(PerformingContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\DisableConcurrentExecutionAttribute.cs:line 48
at Hangfire.Profiling.ProfilerExtensions.InvokeAction[TInstance](InstanceAction`1tuple) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\ProfilerExtensions.cs:line 37
at Hangfire.Profiling.SlowLogProfiler.InvokeMeasured[TInstance,TResult](TInstanceinstance, Func`2action, Stringmessage) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\SlowLogProfiler.cs:line 51
at Hangfire.Profiling.ProfilerExtensions.InvokeMeasured[TInstance](IProfilerprofiler, TInstanceinstance, Action`1action, Stringmessage) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\ProfilerExtensions.cs:line 29
at Hangfire.Server.BackgroundJobPerformer.InvokePerformFilter(IServerFilterfilter, PerformingContextpreContext, Func`1continuation) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 140
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, SqlCommandcommand, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehaviorrunBehavior, SqlCommandcmdHandler, SqlDataReaderdataStream, BulkCopySimpleResultSetbulkCopyHandler, TdsParserStateObjectstateObj, Boolean&dataReady)
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReaderds, RunBehaviorrunBehavior, StringresetOptionsString, BooleanisInternal, BooleanforDescribeParameterEncryption, BooleanshouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehaviorrunBehavior, BooleanreturnStream, BooleanisAsync, Int32timeout, Task&task, BooleanasyncWrite, BooleaninRetry, SqlDataReaderds, BooleandescribeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehaviorcmdBehavior, RunBehaviorrunBehavior, BooleanreturnStream, TaskCompletionSource`1completion, Int32timeout, Task&task, Boolean&usedCache, BooleanasyncWrite, BooleaninRetry, Stringmethod)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dapper.SqlMapper.ExecuteCommand(IDbConnectioncnn, CommandDefinition&command, Action`2paramReader) in /_/Dapper/SqlMapper.cs:line 2965
at Dapper.SqlMapper.ExecuteImpl(IDbConnectioncnn, CommandDefinition&command) in /_/Dapper/SqlMapper.cs:line 656
at Hangfire.SqlServer.SqlServerDistributedLock.Acquire(DbConnectionconnection, Stringresource, TimeSpantimeout) in C:\projects\hangfire-525\src\Hangfire.SqlServer\SqlServerDistributedLock.cs:line 202
at Hangfire.SqlServer.SqlServerConnection.AcquireLock(Stringresource, TimeSpantimeout) in C:\projects\hangfire-525\src\Hangfire.SqlServer\SqlServerConnection.cs:line 731
at Hangfire.DisableConcurrentExecutionAttribute.OnPerforming(PerformingContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\DisableConcurrentExecutionAttribute.cs:line 48
at Hangfire.Profiling.ProfilerExtensions.InvokeAction[TInstance](InstanceAction`1tuple) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\ProfilerExtensions.cs:line 37
at Hangfire.Profiling.SlowLogProfiler.InvokeMeasured[TInstance,TResult](TInstanceinstance, Func`2action, Stringmessage) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\SlowLogProfiler.cs:line 51
at Hangfire.Profiling.ProfilerExtensions.InvokeMeasured[TInstance](IProfilerprofiler, TInstanceinstance, Action`1action, Stringmessage) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\ProfilerExtensions.cs:line 29
at Hangfire.Server.BackgroundJobPerformer.InvokePerformFilter(IServerFilterfilter, PerformingContextpreContext, Func`1continuation) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 140
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, SqlCommandcommand, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehaviorrunBehavior, SqlCommandcmdHandler, SqlDataReaderdataStream, BulkCopySimpleResultSetbulkCopyHandler, TdsParserStateObjectstateObj, Boolean&dataReady)
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReaderds, RunBehaviorrunBehavior, StringresetOptionsString, BooleanisInternal, BooleanforDescribeParameterEncryption, BooleanshouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehaviorrunBehavior, BooleanreturnStream, BooleanisAsync, Int32timeout, Task&task, BooleanasyncWrite, BooleaninRetry, SqlDataReaderds, BooleandescribeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehaviorcmdBehavior, RunBehaviorrunBehavior, BooleanreturnStream, TaskCompletionSource`1completion, Int32timeout, Task&task, Boolean&usedCache, BooleanasyncWrite, BooleaninRetry, Stringmethod)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Dapper.SqlMapper.ExecuteCommand(IDbConnectioncnn, CommandDefinition&command, Action`2paramReader) in /_/Dapper/SqlMapper.cs:line 2965
at Dapper.SqlMapper.ExecuteImpl(IDbConnectioncnn, CommandDefinition&command) in /_/Dapper/SqlMapper.cs:line 656
at Hangfire.SqlServer.SqlServerDistributedLock.Acquire(DbConnectionconnection, Stringresource, TimeSpantimeout) in C:\projects\hangfire-525\src\Hangfire.SqlServer\SqlServerDistributedLock.cs:line 202
at Hangfire.SqlServer.SqlServerConnection.AcquireLock(Stringresource, TimeSpantimeout) in C:\projects\hangfire-525\src\Hangfire.SqlServer\SqlServerConnection.cs:line 731
at Hangfire.DisableConcurrentExecutionAttribute.OnPerforming(PerformingContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\DisableConcurrentExecutionAttribute.cs:line 48
at Hangfire.Profiling.ProfilerExtensions.InvokeAction[TInstance](InstanceAction`1tuple) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\ProfilerExtensions.cs:line 37
at Hangfire.Profiling.SlowLogProfiler.InvokeMeasured[TInstance,TResult](TInstanceinstance, Func`2action, Stringmessage) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\SlowLogProfiler.cs:line 51
at Hangfire.Profiling.ProfilerExtensions.InvokeMeasured[TInstance](IProfilerprofiler, TInstanceinstance, Action`1action, Stringmessage) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\ProfilerExtensions.cs:line 29
at Hangfire.Server.BackgroundJobPerformer.InvokePerformFilter(IServerFilterfilter, PerformingContextpreContext, Func`1continuation) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 140
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallbackcallback, Objectstate)
--- End of stack trace from previous location ---
at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallbackcallback, Objectstate)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task¤tTaskSlot, ThreadthreadPoolThread)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumeratorenumerator, CancellationTokencancellationToken)
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`4operation, Func`4verifySucceeded, TStatestate, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4operation, Func`4verifySucceeded, TStatestate, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Inpart.Integracao.GerenciadorJobs.Services.JobFaturamentoDiretoService.Executar_px_IntegracaoCirurgia() in /src/Inpart.Integracao.GerenciadorJobs/Services/JobFaturamentoDiretoService.cs:line 46
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallbackcallback, Objectstate)
--- End of stack trace from previous location ---
at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallbackcallback, Objectstate)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task¤tTaskSlot, ThreadthreadPoolThread)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumeratorenumerator, CancellationTokencancellationToken)
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`4operation, Func`4verifySucceeded, TStatestate, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4operation, Func`4verifySucceeded, TStatestate, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Inpart.Integracao.GerenciadorJobs.Services.JobFaturamentoDiretoService.Executar_px_IntegracaoCirurgia() in /src/Inpart.Integracao.GerenciadorJobs/Services/JobFaturamentoDiretoService.cs:line 46
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallbackcallback, Objectstate)
--- End of stack trace from previous location ---
at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallbackcallback, Objectstate)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task¤tTaskSlot, ThreadthreadPoolThread)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumeratorenumerator, CancellationTokencancellationToken)
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`4operation, Func`4verifySucceeded, TStatestate, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4operation, Func`4verifySucceeded, TStatestate, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Inpart.Integracao.GerenciadorJobs.Services.JobFaturamentoDiretoService.Executar_px_IntegracaoCirurgia() in /src/Inpart.Integracao.GerenciadorJobs/Services/JobFaturamentoDiretoService.cs:line 46
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
The configured execution strategy 'SqlServerRetryingExecutionStrategy' does not support user-initiated transactions. Use the execution strategy returned by 'DbContext.Database.CreateExecutionStrategy()' to execute all the operations in the transaction as a retriable unit.
System.InvalidOperationException: The configured execution strategy 'SqlServerRetryingExecutionStrategy' does not support user-initiated transactions. Use the execution strategy returned by 'DbContext.Database.CreateExecutionStrategy()' to execute all the operations in the transaction as a retriable unit.
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.OnFirstExecution()
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
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 101
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 107
at System.RuntimeMethodHandle.InvokeMethod(Objecttarget, Void**arguments, Signaturesig, BooleanisConstructor)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'VlPeriodoHoras'.
at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1result)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallbackcallback, Objectstate)
--- End of stack trace from previous location ---
at System.Threading.ExecutionContext.RunInternal(ExecutionContextexecutionContext, ContextCallbackcallback, Objectstate)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task¤tTaskSlot, ThreadthreadPoolThread)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumeratorenumerator, CancellationTokencancellationToken)
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`4operation, Func`4verifySucceeded, TStatestate, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4operation, Func`4verifySucceeded, TStatestate, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
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 67
at System.RuntimeMethodHandle.InvokeMethod(Objecttarget, Void**arguments, Signaturesig, BooleanisConstructor)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Objectobj, BindingFlagsinvokeAttr)
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Hangfire.SqlServer.SqlServerStorage.CreateAndOpenConnection() in C:\projects\hangfire-525\src\Hangfire.SqlServer\SqlServerStorage.cs:line 365
at Hangfire.SqlServer.SqlServerConnection.AcquireLock(Stringresource, TimeSpantimeout) in C:\projects\hangfire-525\src\Hangfire.SqlServer\SqlServerConnection.cs:line 721
at Hangfire.DisableConcurrentExecutionAttribute.OnPerforming(PerformingContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\DisableConcurrentExecutionAttribute.cs:line 48
at Hangfire.Profiling.ProfilerExtensions.InvokeAction[TInstance](InstanceAction`1tuple) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\ProfilerExtensions.cs:line 37
at Hangfire.Profiling.SlowLogProfiler.InvokeMeasured[TInstance,TResult](TInstanceinstance, Func`2action, Stringmessage) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\SlowLogProfiler.cs:line 51
at Hangfire.Profiling.ProfilerExtensions.InvokeMeasured[TInstance](IProfilerprofiler, TInstanceinstance, Action`1action, Stringmessage) in C:\projects\hangfire-525\src\Hangfire.Core\Profiling\ProfilerExtensions.cs:line 29
at Hangfire.Server.BackgroundJobPerformer.InvokePerformFilter(IServerFilterfilter, PerformingContextpreContext, Func`1continuation) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 140