I am attempting to build out some basic reporting features. I created a new end-point.
My application end-point code is as follows
public virtual async Task<PagedResultDto<ReportingContractor>> GetAvailableContractors(Guid? MSA = null, int? trade = null, int? status = null, Guid? vps = null) { List<ContractorDto> _rpt = new List<ContractorDto>();
IQueryable<Trade> queryableTrade = await _trade.GetQueryableAsync();
List<Trade> queryTrade = (from _t in queryableTrade
orderby _t.Id
select _t).ToList();
IQueryable<Status> queryableStatus = await _status.GetQueryableAsync();
List<Status> queryStatus = (from _s in queryableStatus
orderby _s.Id
select _s).ToList();
//Get all the contractors
IQueryable<Contractor> queryablecnt = await _contractor.GetQueryableAsync();
var querycnt = (from cnt in queryablecnt
orderby cnt.Id
select cnt).ToList();
var _cntrList = querycnt.WhereIf(MSA.HasValue, e => e.msaid.Contains(MSA.ToString()))
.WhereIf(trade.HasValue, e => e.tradeid == trade)
.WhereIf(status.HasValue, e => e.status == status)
.WhereIf(vps.HasValue, e => e.procurementSpecialist == vps.ToString());
////Duplicate Contractors for each of the MSA they belong to.
List<Contractor> _cntrItems = new List<Contractor>();
foreach (var _itemCtr in _cntrList.ToList())
{
Contractor _cnItem = new Contractor();
if (_itemCtr.msaid != null)
{
var tags = _itemCtr.msaid.ToString();
string[] _tags = tags.Split(',');
_tags = _tags.Where(x => !string.IsNullOrEmpty(x)).ToArray();
List<string> msaNames = new List<string>();
foreach (string _tag in _tags)
{
if (_tag.ToString() != null)
{
_itemCtr.msaid = _tag.ToString();
_cntrItems.Add(_itemCtr);
}
}
}
}
List<ReportingContractor> _rptItems = new List<ReportingContractor>();
foreach (var _itemCtr in _cntrItems.ToList())
{
ReportingContractor _cnItem = new ReportingContractor();
var rpt = ObjectMapper.Map<Contractor, ReportingContractor>(_itemCtr);
if (rpt.status != 0 || rpt.status != null)
{
foreach (var stat in queryStatus)
{
if (_cnItem.status == stat.Id)
{
rpt.statusName = stat.Name;
break;
}
}
}
if (rpt.tradeid != 0)
{
foreach (var _trade in queryTrade)
{
if (_trade.Id == rpt.tradeid)
{
rpt.tradeName = _trade.Name;
break;
}
}
}
_rptItems.Add(rpt);
}
var _return = new PagedResultDto<ReportingContractor>
{
TotalCount = _rptItems.Count,
Items = _rptItems
};
return _return;
}
The code itself runs at a decent speed given the number of records (close to 900). What I noticed is the code will return values in debug but it takes 3-4x as long for the values to show up in Swagger. I can't seem to figure out what would be causing the issue.
Here is the other areas of code: IContractorAppService
Task<PagedResultDto<ReportingContractor>> GetAvailableContractors(Guid? MSA = null, int? trade = null, int? status = null, Guid? vps = null);
HttpApi ContractorController
[HttpGet] [Route("gcavail")] public virtual Task<PagedResultDto<ReportingContractor>> GetAvailableContractors(Guid? MSA = null, int? trade = null, int? status = null, Guid? vps = null) { return _contractorsAppService.GetAvailableContractors(MSA, trade, status, vps); }
Ever since I upgraded my audit logs, user management and claim types screens do not show details after the first row. How can I fix this?
Hello. I have an project and I recently upgrade to 5.0 to 5.1.1. A couple things I noticed were the tags for advance search changed, but it seems that the modal also changed. Prior to the upgrade I defined my modal to be a size of xl
<abp-modal [busy]="isModalBusy" [(visible)]="isModalOpen" size="xl">
I noticed that the documentation changed and it should be defined as size="ExtraLarge". I made this change but my modal is still opening as modal-md. What tag should be used to open a modal as ExtraLarge?
2021-12-23 13:48:07.478 -05:00 [INF] Starting TiberVendor.HttpApi.Host.
2021-12-23 13:48:15.185 -05:00 [INF] User profile is available. Using 'C:\Users\ryanr\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
2021-12-23 13:48:15.549 -05:00 [INF] Start installing Hangfire SQL objects...
2021-12-23 13:48:15.697 -05:00 [INF] Hangfire SQL objects installed.
2021-12-23 13:48:15.757 -05:00 [INF] Starting Hangfire Server using job storage: 'SQL Server: localhost\SQLEXPRESS@TiberVendorAng'
2021-12-23 13:48:15.758 -05:00 [INF] Using the following options for SQL Server job storage: Queue poll interval: 00:00:15.
2021-12-23 13:48:15.758 -05:00 [INF] Using the following options for Hangfire Server:
Worker count: 20
Listening queues: 'default'
Shutdown timeout: 00:00:15
Schedule polling interval: 00:00:15
2021-12-23 13:48:15.771 -05:00 [DBG] Execution loop BackgroundServerProcess:90579595 has started in 10.2107 ms
2021-12-23 13:48:15.772 -05:00 [INF] Initializing UI Database
2021-12-23 13:48:15.826 -05:00 [INF] Server desktop-2dfljpm:70276:c8f0680d caught stopping signal...
2021-12-23 13:48:15.829 -05:00 [INF] Server desktop-2dfljpm:70276:c8f0680d caught stopped signal...
2021-12-23 13:48:15.890 -05:00 [INF] Server desktop-2dfljpm:70276:c8f0680d successfully announced in 108.9271 ms
2021-12-23 13:48:15.895 -05:00 [DBG] Execution loop ServerHeartbeatProcess:e120c096 has started in 3.9227 ms
2021-12-23 13:48:15.895 -05:00 [INF] Server desktop-2dfljpm:70276:c8f0680d is starting the registered dispatchers: ServerWatchdog, ServerJobCancellationWatcher, ExpirationManager, CountersAggregator, SqlServerHeartbeatProcess, Worker, DelayedJobScheduler, RecurringJobScheduler...
2021-12-23 13:48:15.895 -05:00 [DBG] Execution loop ServerHeartbeatProcess:e120c096 stopped in 4.1088 ms
2021-12-23 13:48:15.899 -05:00 [DBG] Execution loop ServerWatchdog:17bccc67 has started in 4.3167 ms
2021-12-23 13:48:15.899 -05:00 [DBG] Execution loop ServerWatchdog:17bccc67 stopped in 4.3574 ms
2021-12-23 13:48:15.904 -05:00 [DBG] Execution loop ServerJobCancellationWatcher:e29f6cba has started in 6.7077 ms
2021-12-23 13:48:15.904 -05:00 [DBG] Execution loop ServerJobCancellationWatcher:e29f6cba stopped in 6.821 ms
2021-12-23 13:48:15.910 -05:00 [DBG] Execution loop ExpirationManager:0725f7c2 has started in 8.0649 ms
2021-12-23 13:48:15.910 -05:00 [DBG] Execution loop ExpirationManager:0725f7c2 stopped in 8.1971 ms
2021-12-23 13:48:15.913 -05:00 [DBG] Execution loop CountersAggregator:439be6c0 has started in 6.2212 ms
2021-12-23 13:48:15.913 -05:00 [DBG] Execution loop CountersAggregator:439be6c0 stopped in 6.2547 ms
2021-12-23 13:48:15.919 -05:00 [DBG] Execution loop SqlServerHeartbeatProcess:f4e344fc has started in 5.6444 ms
2021-12-23 13:48:15.919 -05:00 [DBG] Execution loop SqlServerHeartbeatProcess:f4e344fc stopped in 5.6894 ms
2021-12-23 13:48:15.925 -05:00 [DBG] Execution loop Worker:24d2f18b has started in 7.6708 ms
2021-12-23 13:48:15.925 -05:00 [DBG] Execution loop Worker:24d2f18b stopped in 7.934 ms
2021-12-23 13:48:15.928 -05:00 [DBG] Execution loop Worker:c05070a1 has started in 11.4221 ms
2021-12-23 13:48:15.928 -05:00 [DBG] Execution loop Worker:c05070a1 stopped in 11.4885 ms
2021-12-23 13:48:15.933 -05:00 [DBG] Execution loop Worker:c7f005dc has started in 16.3926 ms
2021-12-23 13:48:15.934 -05:00 [DBG] Execution loop Worker:c7f005dc stopped in 16.4976 ms
2021-12-23 13:48:15.936 -05:00 [DBG] Execution loop Worker:cd7fd0ba has started in 19.1263 ms
2021-12-23 13:48:15.937 -05:00 [DBG] Execution loop Worker:cd7fd0ba stopped in 19.5377 ms
2021-12-23 13:48:15.944 -05:00 [DBG] Execution loop Worker:9cf54cf7 has started in 26.5275 ms
2021-12-23 13:48:15.944 -05:00 [DBG] Execution loop Worker:9cf54cf7 stopped in 27.4965 ms
2021-12-23 13:48:15.946 -05:00 [DBG] Execution loop Worker:62148920 has started in 29.282 ms
2021-12-23 13:48:15.946 -05:00 [DBG] Execution loop Worker:62148920 stopped in 29.3286 ms
2021-12-23 13:48:15.951 -05:00 [DBG] Execution loop Worker:8f4d5267 has started in 33.1531 ms
2021-12-23 13:48:15.951 -05:00 [DBG] Execution loop Worker:8f4d5267 stopped in 33.5867 ms
2021-12-23 13:48:15.957 -05:00 [DBG] Execution loop Worker:0146fb59 has started in 40.3228 ms
2021-12-23 13:48:15.957 -05:00 [DBG] Execution loop Worker:0146fb59 stopped in 40.4706 ms
2021-12-23 13:48:15.962 -05:00 [DBG] Execution loop Worker:c23324b3 has started in 45.0744 ms
2021-12-23 13:48:15.962 -05:00 [DBG] Execution loop Worker:c23324b3 stopped in 45.5077 ms
2021-12-23 13:48:15.965 -05:00 [DBG] Execution loop Worker:aa8ade2e has started in 47.5985 ms
2021-12-23 13:48:15.965 -05:00 [DBG] Execution loop Worker:aa8ade2e stopped in 47.6411 ms
2021-12-23 13:48:15.970 -05:00 [DBG] Execution loop Worker:d83114e5 has started in 53.1525 ms
2021-12-23 13:48:15.970 -05:00 [DBG] Execution loop Worker:d83114e5 stopped in 53.3358 ms
2021-12-23 13:48:15.976 -05:00 [DBG] Execution loop Worker:584bf70f has started in 58.9081 ms
2021-12-23 13:48:15.977 -05:00 [DBG] Execution loop Worker:584bf70f stopped in 59.5967 ms
2021-12-23 13:48:15.979 -05:00 [DBG] Execution loop Worker:3ee042b1 has started in 61.853 ms
2021-12-23 13:48:15.979 -05:00 [DBG] Execution loop Worker:3ee042b1 stopped in 62.2163 ms
2021-12-23 13:48:15.983 -05:00 [DBG] Execution loop Worker:6e7617aa has started in 65.8995 ms
2021-12-23 13:48:15.983 -05:00 [DBG] Execution loop Worker:6e7617aa stopped in 65.9383 ms
2021-12-23 13:48:15.989 -05:00 [DBG] Execution loop Worker:c394413a has started in 72.3089 ms
2021-12-23 13:48:15.990 -05:00 [DBG] Execution loop Worker:c394413a stopped in 73.0446 ms
2021-12-23 13:48:15.992 -05:00 [DBG] Execution loop Worker:81c10c93 has started in 75.2019 ms
2021-12-23 13:48:15.992 -05:00 [DBG] Execution loop Worker:81c10c93 stopped in 75.2302 ms
2021-12-23 13:48:15.997 -05:00 [DBG] Execution loop Worker:307e71f8 has started in 80.2291 ms
2021-12-23 13:48:15.997 -05:00 [DBG] Execution loop Worker:307e71f8 stopped in 80.2583 ms
2021-12-23 13:48:16.001 -05:00 [DBG] Execution loop Worker:9fc6b0fc has started in 84.2354 ms
2021-12-23 13:48:16.001 -05:00 [DBG] Execution loop Worker:9fc6b0fc stopped in 84.3294 ms
2021-12-23 13:48:16.004 -05:00 [DBG] Execution loop Worker:642a441b has started in 87.3229 ms
2021-12-23 13:48:16.006 -05:00 [DBG] Execution loop Worker:642a441b stopped in 88.8779 ms
2021-12-23 13:48:16.009 -05:00 [DBG] Execution loop Worker:50e592a0 has started in 91.8216 ms
2021-12-23 13:48:16.009 -05:00 [DBG] Execution loop Worker:50e592a0 stopped in 91.8739 ms
2021-12-23 13:48:16.014 -05:00 [INF] Server desktop-2dfljpm:70276:c8f0680d all the dispatchers started
2021-12-23 13:48:16.014 -05:00 [DBG] Execution loop DelayedJobScheduler:2539bd3f has started in 10.2585 ms
2021-12-23 13:48:16.014 -05:00 [DBG] Execution loop DelayedJobScheduler:2539bd3f stopped in 10.3319 ms
2021-12-23 13:48:16.017 -05:00 [DBG] Execution loop RecurringJobScheduler:dfdfa40a has started in 4.7769 ms
2021-12-23 13:48:16.017 -05:00 [DBG] Execution loop RecurringJobScheduler:dfdfa40a stopped in 4.8079 ms
2021-12-23 13:48:16.021 -05:00 [INF] Server desktop-2dfljpm:70276:c8f0680d All dispatchers stopped
2021-12-23 13:48:16.025 -05:00 [INF] Server desktop-2dfljpm:70276:c8f0680d successfully reported itself as stopped in 2.7547 ms
2021-12-23 13:48:16.025 -05:00 [INF] Server desktop-2dfljpm:70276:c8f0680d has been stopped in total 199.2083 ms
2021-12-23 13:48:16.025 -05:00 [DBG] Execution loop BackgroundServerProcess:90579595 stopped in 199.2965 ms
2021-12-23 13:48:16.042 -05:00 [FTL] Host terminated unexpectedly!
Autofac.Core.DependencyResolutionException: An exception was thrown while activating HealthChecks.UI.Core.Data.HealthChecksDb.
---> Autofac.Core.DependencyResolutionException: An exception was thrown while invoking the constructor 'Void .ctor(Microsoft.EntityFrameworkCore.DbContextOptions`1[HealthChecks.UI.Core.Data.HealthChecksDb])' on type 'HealthChecksDb'.
---> System.TypeLoadException: Method 'GetServiceProviderHashCode' in type 'ExtensionInfo' from assembly 'Microsoft.EntityFrameworkCore.InMemory, Version=5.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60' does not have an implementation.
at Microsoft.EntityFrameworkCore.InMemory.Infrastructure.Internal.InMemoryOptionsExtension.get_Info()
at Microsoft.EntityFrameworkCore.DbContextOptions.GetHashCode()
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd[TArg](TKey key, Func`3 valueFactory, TArg factoryArgument)
at Microsoft.EntityFrameworkCore.Internal.ServiceProviderCache.GetOrAdd(IDbContextOptions options, Boolean providerRequired)
at Microsoft.EntityFrameworkCore.DbContext..ctor(DbContextOptions options)
at lambda_method21(Closure , Object[] )
at Autofac.Core.Activators.Reflection.BoundConstructor.Instantiate()
--- End of inner exception stack trace ---
at Autofac.Core.Activators.Reflection.BoundConstructor.Instantiate()
at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)
at Autofac.Core.Activators.Reflection.ReflectionActivator.<ConfigurePipeline>b__11_0(ResolveRequestContext ctxt, Action`1 next)
at Autofac.Core.Resolving.Middleware.DelegateMiddleware.Execute(ResolveRequestContext context, Action`1 next)
at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
at Autofac.Core.Resolving.Middleware.DisposalTrackingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
--- End of inner exception stack trace ---
at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
at Autofac.Core.Pipeline.ResolvePipeline.Invoke(ResolveRequestContext ctxt)
at Autofac.Core.Resolving.Middleware.RegistrationPipelineInvokeMiddleware.Execute(ResolveRequestContext context, Action`1 next)
at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
at Autofac.Core.Resolving.Middleware.SharingMiddleware.<>c__DisplayClass5_0.<Execute>b__0()
at Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid id, Func`1 creator)
at Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid primaryId, Nullable`1 qualifyingId, Func`1 creator)
at Autofac.Core.Resolving.Middleware.SharingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
at Autofac.Core.Resolving.Middleware.CircularDependencyDetectorMiddleware.Execute(ResolveRequestContext context, Action`1 next)
at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
at Autofac.Core.Pipeline.ResolvePipeline.Invoke(ResolveRequestContext ctxt)
at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, ResolveRequest request)
at Autofac.Core.Resolving.ResolveOperation.ExecuteOperation(ResolveRequest request)
at Autofac.Core.Resolving.ResolveOperation.Execute(ResolveRequest request)
at Autofac.Core.Lifetime.LifetimeScope.ResolveComponent(ResolveRequest request)
at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)
at Autofac.ResolutionExtensions.ResolveService(IComponentContext context, Service service, IEnumerable`1 parameters)
at Autofac.ResolutionExtensions.Resolve(IComponentContext context, Type serviceType, IEnumerable`1 parameters)
at Autofac.ResolutionExtensions.Resolve(IComponentContext context, Type serviceType)
at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.GetRequiredService(Type serviceType)
at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
at HealthChecks.UI.Core.HostedService.UIInitializationHostedService.InitializeDatabase(IServiceProvider sp)
at HealthChecks.UI.Core.HostedService.UIInitializationHostedService.StartAsync(CancellationToken cancellationToken)
at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken)
at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.Run(IHost host)
at TiberVendor.Program.Main(String[] args) in C:\source\repos\_TiberVendor\VendorDatabase\aspnet-core\src\TiberVendor.HttpApi.Host\Program.cs:line 31
I have a background job where I am attempting to select records from a trap table. When the code gets to _list = query.ToList() I get the error System.NullReferenceException: 'Object reference not set to an instance of an object.' in List.cs. What am I doing wrong? Any ideas of why this error is occuring?
foreach (var row in values)
{
IQueryable<Trap> queryable = await _trapsSheet.GetQueryableAsync();
var query = queryable.Where(x => x.Asset.Equals(ConvertInt64(row[0].ToString())));
if(query.Any())
{
try
{
var _c1 = MapValues(row);
List<Trap> _list = new List<Trap>();
_list = query.ToList();
Trap _result = ObjectMapper(_c1, _list[0]);
mTrapExist.Add(_result);
}catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
else
{
try
{
Trap _result = MapValues(row);
System.Diagnostics.Debug.WriteLine(_result.Asset.ToString());
mTrap.Add(_result);
}catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
}
}
}
Hello, I recently migrated my project from a local environment to a Debian linux environment. Now I am getting the following error in one of my tables that I generated with ABP Suite
2021-12-15 08:40:02.949 -05:00 [ERR] An error occurred while updating the entries. See the inner exception for details.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
---> Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'IsDeleted', table 'TiberConstructionVendor.db_owner.AppMSAS'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__169_0(Task`1 result)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
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)
ClientConnectionId:294eace5-4611-4881-ae93-f95507748680
Error Number:515,State:2,Class:16
--- 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.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.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.InsertAsync(TEntity entity, Boolean autoSave, CancellationToken cancellationToken)
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()
at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at TiberVendor.MSArea.MSASAppService.CreateAsync(MSACreateDto input) in C:\source\repos\_TiberVendor\VendorDatabase\aspnet-core\src\TiberVendor.Application\MSArea\MSAAppService.cs:line 57
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()
at Volo.Abp.Authorization.AuthorizationInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()
at Volo.Abp.GlobalFeatures.GlobalFeatureInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()
at Volo.Abp.Auditing.AuditingInterceptor.ProceedByLoggingAsync(IAbpMethodInvocation invocation, IAuditingHelper auditingHelper, IAuditLogScope auditLogScope)
at Volo.Abp.Auditing.AuditingInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()
at Volo.Abp.Validation.ValidationInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)
at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()
at Volo.Abp.Uow.UnitOfWorkInterceptor.InterceptAsync(IAbpMethodInvocation invocation)
at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)
at lambda_method3952(Closure , Object )
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
I attempted to to change the code in my appservice and set IsDeleted to false and I am still getting the error. Why isnt the fullaudit doing this?
var mSA = ObjectMapper.Map<MSACreateDto, MSA>(input); mSA.TenantId = CurrentTenant.Id; mSA.IsDeleted = false; mSA = await _mSARepository.InsertAsync(mSA, autoSave: true); return ObjectMapper.Map<MSA, MSADto>(mSA);
I created a background job. I generated a class in the *.Domain project.
My class is defined below
public class PassiveCheckerWorker : AsyncPeriodicBackgroundWorkerBase
{
public PassiveCheckerWorker(AbpAsyncTimer timer,
IServiceScopeFactory serviceScopeFactory) : base(timer,serviceScopeFactory)
{
Timer.Period = 150000; //600000; //10 minutes
}
protected async override Task DoWorkAsync(PeriodicBackgroundWorkerContext workerContext)
{
Logger.LogInformation("Starting: Setting status of inactive users...");
var _objectMapper = workerContext.ServiceProvider.GetRequiredService<IObjectMapper>();
GetContractorsInput _input = new GetContractorsInput();
var _contractor = workerContext.ServiceProvider.GetRequiredService<IContractorsAppService>(); //IRepository<Contractor, Guid>>(); //IContractorsAppService>();
//IQueryable<Contractor> queryable = await _contractor.GetQueryableAsync();
DateTime _today = DateTime.Now;
DateTime _monthAgo = _today.AddMonths(-1);
//Set WCI Expiration
_input.wciexpirationdateMin = _monthAgo;
_input.wciexpirationdateMax = _today;
PagedResultDto<ContractorDto> _clist = await _contractor.GetListAsync(_input);
//var query = from contractor in queryable
// where contractor.wciexpirationdate <= _today
// orderby contractor.Id
// select contractor;
//var _cntr = query.ToList();
foreach (var _c in _clist.Items)
{
//Check status
if (_c.status != 5 && _c.status != 6 && _c.status != 3)
{
//Change status
_c.status = 6;
ContractorUpdateDto _update = new ContractorUpdateDto();
var _cntr = _objectMapper.Map<ContractorDto, ContractorUpdateDto>(_c);
await _contractor.UpdateAsync(_c.Id, _cntr);
//TODO: Send out email notification to vendor
}
}
//Set GLI Expiration
GetContractorsInput _input2 = new GetContractorsInput();
_input2.gliexperationdateMin = _monthAgo;
_input2.gliexperationdateMax = _today;
PagedResultDto<ContractorDto> _clist2 = await _contractor.GetListAsync(_input2);
foreach (var _c in _clist2.Items)
{
//Check status
if (_c.status != 5 && _c.status != 6 && _c.status != 3)
{
//Change status
_c.status = 5;
ContractorUpdateDto _update = new ContractorUpdateDto();
var _cntr = _objectMapper.Map<ContractorDto, ContractorUpdateDto>(_c);
await _contractor.UpdateAsync(_c.Id, _cntr);
//TODO: Send out email notification to vendor
}
}
Logger.LogInformation("Completed: Setting status of inactive users...");
}
}
I registed it in the DomainModule.cs file
public override void OnApplicationInitialization(ApplicationInitializationContext context)
{
context.AddBackgroundWorker<PassiveCheckerWorker>();
}
the background job executes fine. My Issue is I get the following in the Audit log
[
{
"code": "Volo.Authorization:010001",
"message": "Exception of type 'Volo.Abp.Authorization.AbpAuthorizationException' was thrown.",
"details": "AbpAuthorizationException: Exception of type 'Volo.Abp.Authorization.AbpAuthorizationException' was thrown.\r\nSTACK TRACE: at Microsoft.AspNetCore.Authorization.AbpAuthorizationServiceExtensions.CheckAsync(IAuthorizationService authorizationService, AuthorizationPolicy policy)\r\n at Volo.Abp.Authorization.MethodInvocationAuthorizationService.CheckAsync(MethodInvocationAuthorizationContext context)\r\n at Volo.Abp.Authorization.AuthorizationInterceptor.AuthorizeAsync(IAbpMethodInvocation invocation)\r\n at Volo.Abp.Authorization.AuthorizationInterceptor.InterceptAsync(IAbpMethodInvocation invocation)\r\n at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)\r\n at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)\r\n at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()\r\n at Volo.Abp.GlobalFeatures.GlobalFeatureInterceptor.InterceptAsync(IAbpMethodInvocation invocation)\r\n at Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.InterceptAsync[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo, Func`3 proceed)\r\n at Castle.DynamicProxy.AsyncInterceptorBase.ProceedAsynchronous[TResult](IInvocation invocation, IInvocationProceedInfo proceedInfo)\r\n at Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapterWithReturnValue`1.ProceedAsync()\r\n at Volo.Abp.Auditing.AuditingInterceptor.ProceedByLoggingAsync(IAbpMethodInvocation invocation, IAuditingHelper auditingHelper, IAuditLogScope auditLogScope)\r\n at Volo.Abp.Auditing.AuditingInterceptor.ProcessWithNewAuditingScopeAsync(IAbpMethodInvocation invocation, AbpAuditingOptions options, ICurrentUser currentUser, IAuditingManager auditingManager, IAuditingHelper auditingHelper)\r\n",
"data": null,
"validationErrors": null
}
]
I have also attempted to run a linq query and by-pass the application layer, but my code seems to hang on
var query = from contractor in queryable
where contractor.wciexpirationdate <= _today
orderby contractor.Id
select contractor;
var _cntr = query.ToList();
How can I execute a background job as a user or how can I by-pass the authentication?
I am utilizing the File Manegement module for vendors to upload documents to the system. I built a custom service which takes the files and generates a vendor specific folder and sub-folders within File Management. In order for me to get this to work, I had to give permissions to Directory and Files. The issue I am having is now the menu is showing up for the vendors which now gives them access to all the folders and files. My question is, can the folder/files only show for that specific vendor or can the menu item be removed for vendors but show for admins or other groups. If so, how can this be done?
Normally, for other screens I create seperate permissions and limit it in the menu under providers/route.provider.ts file, but not having source for File Manager makes this a little bit more challenging.
This site can’t be reachedThe webpage at https://localhost:44350/api/file-management/file-descriptor/download/ee301db0-5092-0437-3545-39ffeeafb36e?token=752f06c9-3310-43b5-8a8f-3b34cb52cae1 might be temporarily down or it may have moved permanently to a new web address. ERR_INVALID_RESPONSE
I installed File-Management component to my project. When I upload a file things work fine. When I go to download or simply click on file name I get the error
This site can’t be reachedThe webpage at https://localhost:44350/api/file-management/file-descriptor/download/ee301db0-5092-0437-3545-39ffeeafb36e?token=752f06c9-3310-43b5-8a8f-3b34cb52cae1 might be temporarily down or it may have moved permanently to a new web address. ERR_INVALID_RESPONSE
If you go to the backend service and manually run it through SWAG the file appears to be corrupt.
Here is the log file entries
2021-11-01 17:11:38 ::1 GET /api/file-management/file-descriptor/download/e4bd11f8-341c-79ca-1e21-39ffee85d537 token=ddb88a0b-e5c0-4ce2-97ed-30149c796e90 44350 - ::1 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/95.0.4638.54+Safari/537.36 http://localhost:4200/ 406 0 0 62 2021-11-01 17:11:39 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:11:49 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:11:59 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:12:09 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:12:19 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:12:29 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:12:39 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:12:49 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:12:59 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:13:09 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:13:19 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:13:29 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:13:39 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:13:49 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:13:59 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:14:10 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:14:20 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:14:30 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:14:40 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:14:50 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:15:00 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:15:10 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:15:20 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:15:30 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:15:40 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:15:50 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:16:00 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:16:10 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 8 2021-11-01 17:16:20 ::1 GET /health-status - 44350 - ::1 - - 200 0 0 9 2021-11-01 17:16:23 ::1 GET /api/file-management/file-descriptor/download/e4bd11f8-341c-79ca-1e21-39ffee85d537 token=ddb88a0b-e5c0-4ce2-97ed-30149c796e90 44350 - ::1 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/95.0.4638.54+Safari/537.36 http://localhost:4200/ 406 0 0 63
My next question is, is there a way to use this component within another component? If so, how would you do this with Angular?
When I deploy the .NET backend code to azure in a playground to see it all work. I am getting a 500 error when I access the authorize in swagger. Here is my app.setting file
{ "App": { "SelfUrl": "http://materialdbapi.azurewebsites.net", "AngularUrl": "http://materialdbapi.azurewebsites.net", "CorsOrigins": "http://materialdbapi.azurewebsites.net", "RedirectAllowedUrls": "http://materialdbapi.azurewebsites.net" }, "Redis": { "Configuration": "127.0.0.1", "InEnabled": "false" }, "ConnectionStrings": { "Default": "Server=tcp:tcgcorpsitedev.database.windows.net,1433;Initial Catalog=TiberConstruction;Persist Security Info=False;User ID=<username>;Password=<password>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;" }, "AuthServer": { "Authority": "http://materialdbapi.azurewebsites.net", "RequireHttpsMetadata": "false", "SwaggerClientId": "MaterialDatabase_Swagger", "SwaggerClientSecret": "1q2w3e" }, "StringEncryption": { "DefaultPassPhrase": "SJWiQooPdpFwOiuN" }, "Settings": { "Volo.Abp.LeptonTheme.Style": "Style6", "Volo.Abp.LeptonTheme.Layout.MenuPlacement": "Left", "Volo.Abp.LeptonTheme.Layout.MenuStatus": "AlwaysOpened", "Volo.Abp.LeptonTheme.Layout.Boxed": "False" } }