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.
System.InvalidOperationException: Instances of abstract classes cannot be created.
at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance(IServiceProviderprovider, TypeinstanceType, Object[]parameters)
at Hangfire.Server.CoreBackgroundJobPerformer.Perform(PerformContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\CoreBackgroundJobPerformer.cs:line 49
at Hangfire.Server.BackgroundJobPerformer.InvokeServerFilter(Enumerator&enumerator, IBackgroundJobPerformerinnerPerformer, PerformContextcontext, PerformingContextpreContext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 143
at Hangfire.Server.BackgroundJobPerformer.Perform(PerformContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 71
at Hangfire.Server.Worker.PerformJob(BackgroundProcessContextcontext, IStorageConnectionconnection, StringjobId, BackgroundJobbackgroundJob, IReadOnlyDictionary`2&customData) in C:\projects\hangfire-525\src\Hangfire.Core\Server\Worker.cs:line 293
ExcelDataReader.Exceptions.HeaderException: Detected ZIP file, but not a valid OpenXml file.
at ExcelDataReader.Core.OpenXmlFormat.ZipWorker..ctor(StreamfileStream)
at ExcelDataReader.ExcelOpenXmlReader..ctor(Streamstream)
at ExcelDataReader.ExcelReaderFactory.CreateReader(StreamfileStream, ExcelReaderConfigurationconfiguration)
at Services.InboundGatewayProcessingService.LoadFileAsTable(StringfileUri, StringfileName) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\InboundGatewayProcessingService.cs:line 1295
at Services.InboundGatewayProcessingService.ParseUpload(Int64uploadId) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\InboundGatewayProcessingService.cs:line 165
at Services.InboundGatewayProcessingService.ParseUpload(Int64uploadId) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\InboundGatewayProcessingService.cs:line 180
at InvokeStub_TaskAwaiter.GetResult(Object,Object, IntPtr*)
at System.Reflection.RuntimeMethodInfo.Invoke(Objectobj, BindingFlagsinvokeAttr, Binderbinder, Object[]parameters, CultureInfoculture)
System.InvalidOperationException: Instances of abstract classes cannot be created.
at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance(IServiceProviderprovider, TypeinstanceType, Object[]parameters)
at Hangfire.AspNetCore.AspNetCoreJobActivatorScope.Resolve(Typetype) in C:\projects\hangfire-525\src\Hangfire.NetCore\AspNetCore\AspNetCoreJobActivatorScope.cs:line 34
at Hangfire.Server.CoreBackgroundJobPerformer.Perform(PerformContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\CoreBackgroundJobPerformer.cs:line 60
at Hangfire.Server.BackgroundJobPerformer.InvokeNextServerFilter(Enumerator&enumerator, IBackgroundJobPerformerinnerPerformer, PerformContextcontext, PerformingContextpreContext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 128
at Hangfire.Server.BackgroundJobPerformer.InvokeServerFilter(Enumerator&enumerator, IBackgroundJobPerformerinnerPerformer, PerformContextcontext, PerformingContextpreContext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 164
at Hangfire.Server.BackgroundJobPerformer.PerformJobWithFilters(PerformContextcontext, FilterCollection`1filters) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 119
at Hangfire.Server.BackgroundJobPerformer.Perform(PerformContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 78
at Hangfire.Server.Worker.PerformJob(BackgroundProcessContextcontext, IStorageConnectionconnection, StringjobId, BackgroundJobbackgroundJob, IReadOnlyDictionary`2&customData) in C:\projects\hangfire-525\src\Hangfire.Core\Server\Worker.cs:line 320
System.InvalidOperationException: Instances of abstract classes cannot be created.
at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateInstance(IServiceProviderprovider, TypeinstanceType, Object[]parameters)
at Hangfire.AspNetCore.AspNetCoreJobActivatorScope.Resolve(Typetype) in C:\projects\hangfire-525\src\Hangfire.NetCore\AspNetCore\AspNetCoreJobActivatorScope.cs:line 34
at Hangfire.Server.CoreBackgroundJobPerformer.Perform(PerformContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\CoreBackgroundJobPerformer.cs:line 60
at Hangfire.Server.BackgroundJobPerformer.InvokeNextServerFilter(Enumerator&enumerator, IBackgroundJobPerformerinnerPerformer, PerformContextcontext, PerformingContextpreContext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 128
at Hangfire.Server.BackgroundJobPerformer.InvokeServerFilter(Enumerator&enumerator, IBackgroundJobPerformerinnerPerformer, PerformContextcontext, PerformingContextpreContext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 164
at Hangfire.Server.BackgroundJobPerformer.PerformJobWithFilters(PerformContextcontext, FilterCollection`1filters) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 119
at Hangfire.Server.BackgroundJobPerformer.Perform(PerformContextcontext) in C:\projects\hangfire-525\src\Hangfire.Core\Server\BackgroundJobPerformer.cs:line 78
at Hangfire.Server.Worker.PerformJob(BackgroundProcessContextcontext, IStorageConnectionconnection, StringjobId, BackgroundJobbackgroundJob, IReadOnlyDictionary`2&customData) in C:\projects\hangfire-525\src\Hangfire.Core\Server\Worker.cs:line 320
An error occurred while saving the entity changes. See the inner exception for details.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> Microsoft.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'IndealAccountNumber', table 'Indeal.dbo.InboundSheets'; column does not allow nulls. UPDATE fails.
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.TryHasMoreRows(Boolean&moreRows)
at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(BooleansetTimeout, Boolean&more)
at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Tasktask, Objectstate)
at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1context)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetAsync(Int32startCommandIndex, RelationalDataReaderreader, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetAsync(Int32startCommandIndex, RelationalDataReaderreader, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeAsync(RelationalDataReaderreader, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Update.Internal.SqlServerModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChangesAsync(IList`1entries, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Services.InboundGatewayProcessingService.ProcessUpload(Int64uploadId) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\InboundGatewayProcessingService.cs:line 311
at System.RuntimeMethodHandle.InvokeMethod(ObjectHandleOnStacktarget, Void**arguments, ObjectHandleOnStacksig, BOOLisConstructor, ObjectHandleOnStackresult)
at System.Reflection.MethodBaseInvoker.InterpretedInvoke_Method(Objectobj, IntPtr*args)
at System.Reflection.RuntimeMethodInfo.Invoke(Objectobj, BindingFlagsinvokeAttr, Binderbinder, Object[]parameters, CultureInfoculture)
An error occurred while saving the entity changes. See the inner exception for details.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> Microsoft.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'IndealAccountNumber', table 'Indeal.dbo.InboundSheets'; column does not allow nulls. UPDATE fails.
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.TryHasMoreRows(Boolean&moreRows)
at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(BooleansetTimeout, Boolean&more)
at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Tasktask, Objectstate)
at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1context)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetAsync(Int32startCommandIndex, RelationalDataReaderreader, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetAsync(Int32startCommandIndex, RelationalDataReaderreader, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeAsync(RelationalDataReaderreader, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Update.Internal.SqlServerModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChangesAsync(IList`1entries, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Services.InboundGatewayProcessingService.ProcessUpload(Int64uploadId) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\InboundGatewayProcessingService.cs:line 311
at System.RuntimeMethodHandle.InvokeMethod(ObjectHandleOnStacktarget, Void**arguments, ObjectHandleOnStacksig, BOOLisConstructor, ObjectHandleOnStackresult)
at System.Reflection.MethodBaseInvoker.InterpretedInvoke_Method(Objectobj, IntPtr*args)
at System.Reflection.RuntimeMethodInfo.Invoke(Objectobj, BindingFlagsinvokeAttr, Binderbinder, Object[]parameters, CultureInfoculture)
An error occurred while saving the entity changes. See the inner exception for details.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> Microsoft.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'IndealAccountNumber', table 'Indeal.dbo.InboundSheets'; column does not allow nulls. UPDATE fails.
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.TryHasMoreRows(Boolean&moreRows)
at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(BooleansetTimeout, Boolean&more)
at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Tasktask, Objectstate)
at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1context)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetAsync(Int32startCommandIndex, RelationalDataReaderreader, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetAsync(Int32startCommandIndex, RelationalDataReaderreader, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeAsync(RelationalDataReaderreader, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Update.Internal.SqlServerModificationCommandBatch.ExecuteAsync(IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1commandBatches, IRelationalConnectionconnection, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChangesAsync(IList`1entries, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1entriesToSave, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManagerstateManager, BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(BooleanacceptAllChangesOnSuccess, CancellationTokencancellationToken)
at Services.InboundGatewayProcessingService.ProcessUpload(Int64uploadId) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\InboundGatewayProcessingService.cs:line 311
at System.RuntimeMethodHandle.InvokeMethod(ObjectHandleOnStacktarget, Void**arguments, ObjectHandleOnStacksig, BOOLisConstructor, ObjectHandleOnStackresult)
at System.Reflection.MethodBaseInvoker.InterpretedInvoke_Method(Objectobj, IntPtr*args)
at System.Reflection.RuntimeMethodInfo.Invoke(Objectobj, BindingFlagsinvokeAttr, Binderbinder, Object[]parameters, CultureInfoculture)