// Id: #63138
using Volo.Abp.BackgroundJobs.Hangfire;
var hangfireJobExecutionAdapter = Activate<HangfireJobExecutionAdapter<NetoInventorySyncJobArgs>>();
await hangfireJobExecutionAdapter.ExecuteAsync(
"jetti-prod_default",
FromJson<NetoInventorySyncJobArgs>("{\"JobType\":1,\"BatchSizeOverride\":50}"),
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: 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 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. ---> 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 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. ---> 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 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. ---> 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.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass11_0`1.<ExecuteCore>b__0()
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 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. ---> 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.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass11_0`1.<ExecuteCore>b__0()
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 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. ---> 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.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass11_0`1.<ExecuteCore>b__0()
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)