// Id: #62978
using Volo.Abp.BackgroundJobs.Hangfire;
var hangfireJobExecutionAdapter = Activate<HangfireJobExecutionAdapter<NetoInventorySyncJobArgs>>();
await hangfireJobExecutionAdapter.ExecuteAsync(
"jetti-prod_default",
FromJson<NetoInventorySyncJobArgs>("{\"JobType\":1}"),
null);
| CurrentCulture | |
| RetryCount | |
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> Volo.Abp.Data.AbpDbConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 0 row(s); data may have been modified or deleted since entities were loaded. See https://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions. ---> Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 0 row(s); data may have been modified or deleted since entities were loaded. See https://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions. at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.ThrowAggregateUpdateConcurrencyExceptionAsync(RelationalDataReader reader, Int32 commandIndex, Int32 expectedRowsAffected, Int32 rowsAffected, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Update.Internal.NpgsqlModificationCommandBatch.Consume(RelationalDataReader reader, Boolean async, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChangesAsync(IList`1 entries, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Volo.Abp.EntityFrameworkCore.AbpDbContext`1.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) --- End of inner exception stack trace --- at Volo.Abp.EntityFrameworkCore.AbpDbContext`1.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Volo.Abp.Uow.UnitOfWork.SaveChangesAsync(CancellationToken cancellationToken) at Volo.Abp.Uow.UnitOfWork.CompleteAsync(CancellationToken cancellationToken) at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed) at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) --- End of inner exception stack trace --- at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken) at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 10 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> System.InvalidOperationException: An exception has been raised that is likely due to a transient failure. ---> Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> Npgsql.NpgsqlException: Exception while reading from stream ---> System.TimeoutException: Timeout during reading attempt --- End of inner exception stack trace --- at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChangesAsync(IList`1 entries, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) --- End of inner exception stack trace --- at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Volo.Abp.EntityFrameworkCore.AbpDbContext`1.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Volo.Abp.Domain.Repositories.EntityFrameworkCore.EfCoreRepository`2.UpdateManyAsync(IEnumerable`1 entities, Boolean autoSave, CancellationToken cancellationToken) at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed) at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.SaveProductUpdatesInChunksAsync(IReadOnlyCollection`1 updates, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 706 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ApplyFetchedItemsAsync(IReadOnlyCollection`1 items, NetoInventorySyncResult result, Boolean touchMatchedProducts, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 511 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 130 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 204 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 40 at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed) at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) --- End of inner exception stack trace --- at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken) at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 9 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> System.InvalidOperationException: The LINQ expression 'DbSet<Product>()
.Where(p => AbpEfCoreDataFilterDbFunctionMethods.SoftDeleteFilter(
isDeleted: ((ISoftDelete)p).IsDeleted,
boolParam: True) && AbpEfCoreDataFilterDbFunctionMethods.MultiTenantFilter(
tenantId: ((IMultiTenant)p).TenantId,
currentTenantId: __ef_filter__CurrentTenantId_0,
boolParam: True))
.LeftJoin(
inner: DbSet<Sku>()
.Where(s => AbpEfCoreDataFilterDbFunctionMethods.MultiTenantFilter(
tenantId: ((IMultiTenant)s).TenantId,
currentTenantId: __ef_filter__CurrentTenantId_0,
boolParam: True)),
outerKeySelector: p => EF.Property<Guid?>(p, "SkuId"),
innerKeySelector: s => EF.Property<Guid?>(s, "Id"),
resultSelector: (o, i) => new TransparentIdentifier<Product, Sku>(
Outer = o,
Inner = i
))
.Where(p => p.Outer.NetoId.HasValue && __netoIds_0
.Contains(p.Outer.NetoId.Value) || p.Inner != null && __skuMap_1.ContainsKey(p.Inner.Normalized))' could not be translated. Additional information: Translation of method 'System.Collections.Generic.Dictionary<string, Aurus.Jetti.Integrations.Neto.Models.Products.ItemSyncDto>.ContainsKey' failed. If this method can be mapped to your custom function, see https://go.microsoft.com/fwlink/?linkid=2132413 for more information. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.
at Microsoft.EntityFrameworkCore.Query.QueryableMethodTranslatingExpressionVisitor.Translate(Expression expression)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutorExpression[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteCore[TResult](Expression query, Boolean async, CancellationToken cancellationToken)
at Volo.Abp.EntityFrameworkCore.AbpEntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 93
at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 37
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync()
at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context)
--- End of inner exception stack trace ---
at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context)
at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken)
at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 8 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> System.InvalidOperationException: The LINQ expression 'DbSet<Product>()
.Where(p => AbpEfCoreDataFilterDbFunctionMethods.SoftDeleteFilter(
isDeleted: ((ISoftDelete)p).IsDeleted,
boolParam: True) && AbpEfCoreDataFilterDbFunctionMethods.MultiTenantFilter(
tenantId: ((IMultiTenant)p).TenantId,
currentTenantId: __ef_filter__CurrentTenantId_0,
boolParam: True))
.LeftJoin(
inner: DbSet<Sku>()
.Where(s => AbpEfCoreDataFilterDbFunctionMethods.MultiTenantFilter(
tenantId: ((IMultiTenant)s).TenantId,
currentTenantId: __ef_filter__CurrentTenantId_0,
boolParam: True)),
outerKeySelector: p => EF.Property<Guid?>(p, "SkuId"),
innerKeySelector: s => EF.Property<Guid?>(s, "Id"),
resultSelector: (o, i) => new TransparentIdentifier<Product, Sku>(
Outer = o,
Inner = i
))
.Where(p => p.Outer.NetoId.HasValue && __netoIds_0
.Contains(p.Outer.NetoId.Value) || p.Inner != null && __skuMap_1.ContainsKey(p.Inner.Normalized))' could not be translated. Additional information: Translation of method 'System.Collections.Generic.Dictionary<string, Aurus.Jetti.Integrations.Neto.Models.Products.ItemSyncDto>.ContainsKey' failed. If this method can be mapped to your custom function, see https://go.microsoft.com/fwlink/?linkid=2132413 for more information. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.
at Microsoft.EntityFrameworkCore.Query.QueryableMethodTranslatingExpressionVisitor.Translate(Expression expression)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutorExpression[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteCore[TResult](Expression query, Boolean async, CancellationToken cancellationToken)
at Volo.Abp.EntityFrameworkCore.AbpEntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 93
at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 37
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync()
at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context)
--- End of inner exception stack trace ---
at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context)
at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken)
at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 7 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> System.InvalidOperationException: The LINQ expression 'DbSet<Product>()
.Where(p => AbpEfCoreDataFilterDbFunctionMethods.SoftDeleteFilter(
isDeleted: ((ISoftDelete)p).IsDeleted,
boolParam: True) && AbpEfCoreDataFilterDbFunctionMethods.MultiTenantFilter(
tenantId: ((IMultiTenant)p).TenantId,
currentTenantId: __ef_filter__CurrentTenantId_0,
boolParam: True))
.LeftJoin(
inner: DbSet<Sku>()
.Where(s => AbpEfCoreDataFilterDbFunctionMethods.MultiTenantFilter(
tenantId: ((IMultiTenant)s).TenantId,
currentTenantId: __ef_filter__CurrentTenantId_0,
boolParam: True)),
outerKeySelector: p => EF.Property<Guid?>(p, "SkuId"),
innerKeySelector: s => EF.Property<Guid?>(s, "Id"),
resultSelector: (o, i) => new TransparentIdentifier<Product, Sku>(
Outer = o,
Inner = i
))
.Where(p => p.Outer.NetoId.HasValue && __netoIds_0
.Contains(p.Outer.NetoId.Value) || p.Inner != null && __skuMap_1.ContainsKey(p.Inner.Normalized))' could not be translated. Additional information: Translation of method 'System.Collections.Generic.Dictionary<string, Aurus.Jetti.Integrations.Neto.Models.Products.ItemSyncDto>.ContainsKey' failed. If this method can be mapped to your custom function, see https://go.microsoft.com/fwlink/?linkid=2132413 for more information. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.
at Microsoft.EntityFrameworkCore.Query.QueryableMethodTranslatingExpressionVisitor.Translate(Expression expression)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutorExpression[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteCore[TResult](Expression query, Boolean async, CancellationToken cancellationToken)
at Volo.Abp.EntityFrameworkCore.AbpEntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 93
at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 37
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync()
at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context)
--- End of inner exception stack trace ---
at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context)
at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken)
at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 6 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> System.InvalidOperationException: The LINQ expression 'DbSet<Product>()
.Where(p => AbpEfCoreDataFilterDbFunctionMethods.SoftDeleteFilter(
isDeleted: ((ISoftDelete)p).IsDeleted,
boolParam: True) && AbpEfCoreDataFilterDbFunctionMethods.MultiTenantFilter(
tenantId: ((IMultiTenant)p).TenantId,
currentTenantId: __ef_filter__CurrentTenantId_0,
boolParam: True))
.LeftJoin(
inner: DbSet<Sku>()
.Where(s => AbpEfCoreDataFilterDbFunctionMethods.MultiTenantFilter(
tenantId: ((IMultiTenant)s).TenantId,
currentTenantId: __ef_filter__CurrentTenantId_0,
boolParam: True)),
outerKeySelector: p => EF.Property<Guid?>(p, "SkuId"),
innerKeySelector: s => EF.Property<Guid?>(s, "Id"),
resultSelector: (o, i) => new TransparentIdentifier<Product, Sku>(
Outer = o,
Inner = i
))
.Where(p => p.Outer.NetoId.HasValue && __netoIds_0
.Contains(p.Outer.NetoId.Value) || p.Inner != null && __skuMap_1.ContainsKey(p.Inner.Normalized))' could not be translated. Additional information: Translation of method 'System.Collections.Generic.Dictionary<string, Aurus.Jetti.Integrations.Neto.Models.Products.ItemSyncDto>.ContainsKey' failed. If this method can be mapped to your custom function, see https://go.microsoft.com/fwlink/?linkid=2132413 for more information. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.
at Microsoft.EntityFrameworkCore.Query.QueryableMethodTranslatingExpressionVisitor.Translate(Expression expression)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutorExpression[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteCore[TResult](Expression query, Boolean async, CancellationToken cancellationToken)
at Volo.Abp.EntityFrameworkCore.AbpEntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 93
at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 37
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync()
at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context)
--- End of inner exception stack trace ---
at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context)
at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken)
at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 5 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> Npgsql.PostgresException: 42703: column i.LastDurationMs does not exist POSITION: 180 at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Volo.Abp.Domain.Repositories.RepositoryAsyncExtensions.FirstOrDefaultAsync[T](IReadOnlyRepository`1 repository, Expression`1 predicate, CancellationToken cancellationToken) at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.GetOrCreateCheckpointAsync(NetoInventorySyncJobType jobType, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 917 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 68 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 40 at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed) at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) --- End of inner exception stack trace --- at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken) at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 4 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> Npgsql.PostgresException: 42703: column i.LastDurationMs does not exist POSITION: 180 at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Volo.Abp.Domain.Repositories.RepositoryAsyncExtensions.FirstOrDefaultAsync[T](IReadOnlyRepository`1 repository, Expression`1 predicate, CancellationToken cancellationToken) at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.GetOrCreateCheckpointAsync(NetoInventorySyncJobType jobType, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 917 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 68 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 40 at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed) at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) --- End of inner exception stack trace --- at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken) at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 3 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> Npgsql.PostgresException: 42703: column i.LastDurationMs does not exist POSITION: 180 at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Volo.Abp.Domain.Repositories.RepositoryAsyncExtensions.FirstOrDefaultAsync[T](IReadOnlyRepository`1 repository, Expression`1 predicate, CancellationToken cancellationToken) at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.GetOrCreateCheckpointAsync(NetoInventorySyncJobType jobType, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 917 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 68 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 40 at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed) at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) --- End of inner exception stack trace --- at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken) at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 2 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> Npgsql.PostgresException: 42703: column i.LastDurationMs does not exist POSITION: 180 at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Volo.Abp.Domain.Repositories.RepositoryAsyncExtensions.FirstOrDefaultAsync[T](IReadOnlyRepository`1 repository, Expression`1 predicate, CancellationToken cancellationToken) at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.GetOrCreateCheckpointAsync(NetoInventorySyncJobType jobType, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 917 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 68 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 40 at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed) at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) --- End of inner exception stack trace --- at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken) at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Retry attempt 1 of 10: A background job execution is failed. See inner e…
An exception occurred during performance of the job.
A background job execution is failed. See inner exception for details.
Volo.Abp.BackgroundJobs.BackgroundJobExecutionException: A background job execution is failed. See inner exception for details. ---> Npgsql.PostgresException: 42703: column i.LastDurationMs does not exist POSITION: 180 at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) at Volo.Abp.Domain.Repositories.RepositoryAsyncExtensions.FirstOrDefaultAsync[T](IReadOnlyRepository`1 repository, Expression`1 predicate, CancellationToken cancellationToken) at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.GetOrCreateCheckpointAsync(NetoInventorySyncJobType jobType, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 917 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncService.ExecuteAsync(NetoInventorySyncRequest request, CancellationToken cancellationToken) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncService.cs:line 68 at Aurus.Jetti.Integrations.Neto.NetoInventorySyncJob.ExecuteAsync(NetoInventorySyncJobArgs args) in /src/src/Aurus.Jetti.Application/Integrations/Neto/NetoInventorySyncJob.cs:line 40 at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous(IInvocation invocation, IInvocationProceedInfo proceedInfo) at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.ProceedAsync() at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation) at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync(IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed) at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) --- End of inner exception stack trace --- at Volo.Abp.BackgroundJobs.BackgroundJobExecuter.ExecuteAsync(JobExecutionContext context) at Volo.Abp.BackgroundJobs.Hangfire.HangfireJobExecutionAdapter`1.ExecuteAsync(String queue, TArgs args, CancellationToken cancellationToken) at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)