Activities of "nenjamio"

We have developed an application under version ASPNET Core 2.2 and AspNetZero 5, using Angular. Application is currently in production and hosting 100 concurrent users, around 4000 daily. We are having issues when the APP pool is restarted, the application takes up to 30minutes or 1hour to start responding (the symthom is that the SQL connections qty raises up to top max conn pool size and never release).

We have been recommended in this forum to upgrade to AspNetZero 9.0.1 and ASPNET Core 3.1. We have created an empty template and then uploaded all our customizations and classes. So far we only focused in upgrading the API, not yet Angular site. We did not make any upgrade or run any script to modify the DB. However, we didnt find any differences in the classes.

We could manage to make the login working sucessfully and run our customized sections too. However, the issue we are facing now is that many propietary framework sections are not working for instance users section.

Is there any special consideration for continuing on this version migration? Is there any version migrator for the DB?

Could you help mwith this error? Its an empty project, recently downloaded, I can compile it succesfully, but when i want to execute HOST, I have the next error:

HTTP Error 500.0 - ANCM In-Process Handler Load Failure

Regards

Hi @ismcagdas, Yer, i am using AbpRedisCacheModule.

Do you think it could be something about Redis configuration?

Could you help me with this message?

AcceptLanguageHeaderRequestCultureProvider returned the following unsupported cultures 'en, pt, es-ES'

Where can i configure it in order to dissapear the warning message?

Hi, i have a critical problem with sql connections when the applications starts. The application works fine but when i want to publish some new changes, y do iisreset and when starts again, the framework begins to open multiple connections, and the application takes a long time to respond. Genereating multiple errors.

Did anyone have a similar problem?

Mvc.Authorization.AbpAuthorizationFilter - [(null)] - System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.BeginTransaction(IsolationLevel isolationLevel) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.BeginTransaction(DatabaseFacade databaseFacade, IsolationLevel isolationLevel) at Abp.EntityFrameworkCore.Uow.DbContextEfCoreTransactionStrategy.CreateDbContext[TDbContext](String connectionString, IDbContextResolver dbContextResolver) at Abp.EntityFrameworkCore.Uow.EfCoreUnitOfWork.GetOrCreateDbContext[TDbContext](Nullable1 multiTenancySide, String name) at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.<GetQueryable>b__7_0(Type key) at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory) at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.GetQueryable() at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.GetAllIncluding(Expression1[] propertySelectors) at Abp.Domain.Repositories.AbpRepositoryBase2.GetAllList(Expression1 predicate) at Castle.Proxies.Invocations.IRepository2_GetAllList_43.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformSyncUow(IInvocation invocation, UnitOfWorkOptions options) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.IRepository2Proxy_18.GetAllList(Expression1 predicate) at Abp.Localization.MultiTenantLocalizationDictionary.GetAllValuesFromDatabase(Nullable1 tenantId) at Castle.Proxies.Invocations.MultiTenantLocalizationDictionary_GetAllValuesFromDatabase.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformSyncUow(IInvocation invocation, UnitOfWorkOptions options) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.MultiTenantLocalizationDictionaryProxy.GetAllValuesFromDatabase(Nullable1 tenantId) at Abp.Runtime.Caching.CacheExtensions.<>c__DisplayClass5_02.<Get>b__0(String k) at Abp.Runtime.Caching.CacheBase.Get(String key, Func2 factory) at Abp.Runtime.Caching.CacheExtensions.Get[TKey,TValue](ICache cache, TKey key, Func2 factory) at Abp.Localization.MultiTenantLocalizationDictionary.GetOrNull(Nullable1 tenantId, String name) at Castle.Proxies.Invocations.ILocalizationDictionary_GetOrNull.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.MultiTenantLocalizationDictionaryProxy.GetOrNull(String name) at Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource.GetStringOrNull(String name, CultureInfo culture, Boolean tryDefaults) at Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource.GetString(String name, CultureInfo culture) at Abp.Authorization.AuthorizationHelper.AuthorizeAsync(IEnumerable1 authorizeAttributes) at Abp.Authorization.AuthorizationHelper.CheckPermissions(MethodInfo methodInfo, Type type) at Abp.Authorization.AuthorizationHelper.AuthorizeAsync(MethodInfo methodInfo, Type type) at Abp.AspNetCore.Mvc.Authorization.AbpAuthorizationFilter.OnAuthorizationAsync(AuthorizationFilterContext context) System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.BeginTransaction(IsolationLevel isolationLevel) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.BeginTransaction(DatabaseFacade databaseFacade, IsolationLevel isolationLevel) at Abp.EntityFrameworkCore.Uow.DbContextEfCoreTransactionStrategy.CreateDbContext[TDbContext](String connectionString, IDbContextResolver dbContextResolver) at Abp.EntityFrameworkCore.Uow.EfCoreUnitOfWork.GetOrCreateDbContext[TDbContext](Nullable1 multiTenancySide, String name) at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.<GetQueryable>b__7_0(Type key) at System.Collections.Concurrent.ConcurrentDictionary2.GetOrAdd(TKey key, Func2 valueFactory) at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.GetQueryable() at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.GetAllIncluding(Expression1[] propertySelectors) at Abp.Domain.Repositories.AbpRepositoryBase2.GetAllList(Expression1 predicate) at Castle.Proxies.Invocations.IRepository2_GetAllList_43.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformSyncUow(IInvocation invocation, UnitOfWorkOptions options) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.IRepository2Proxy_18.GetAllList(Expression1 predicate) at Abp.Localization.MultiTenantLocalizationDictionary.GetAllValuesFromDatabase(Nullable1 tenantId) at Castle.Proxies.Invocations.MultiTenantLocalizationDictionary_GetAllValuesFromDatabase.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformSyncUow(IInvocation invocation, UnitOfWorkOptions options) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.MultiTenantLocalizationDictionaryProxy.GetAllValuesFromDatabase(Nullable1 tenantId) at Abp.Runtime.Caching.CacheExtensions.<>c__DisplayClass5_02.<Get>b__0(String k) at Abp.Runtime.Caching.CacheBase.Get(String key, Func2 factory) at Abp.Runtime.Caching.CacheExtensions.Get[TKey,TValue](ICache cache, TKey key, Func2 factory) at Abp.Localization.MultiTenantLocalizationDictionary.GetOrNull(Nullable1 tenantId, String name) at Castle.Proxies.Invocations.ILocalizationDictionary_GetOrNull.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.MultiTenantLocalizationDictionaryProxy.GetOrNull(String name) at Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource.GetStringOrNull(String name, CultureInfo culture, Boolean tryDefaults) at Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource.GetString(String name, CultureInfo culture) at Abp.Authorization.AuthorizationHelper.AuthorizeAsync(IEnumerable1 authorizeAttributes) at Abp.Authorization.AuthorizationHelper.CheckPermissions(MethodInfo methodInfo, Type type) at Abp.Authorization.AuthorizationHelper.AuthorizeAsync(MethodInfo methodInfo, Type type) at Abp.AspNetCore.Mvc.Authorization.AbpAuthorizationFilter.OnAuthorizationAsync(AuthorizationFilterContext context)

Hi, i have a problem with open connections when i have 100 users logged in my app. The framework starts to open connections and reach the max pool connections number.

with less than 100 users the application works without problems.

Could you help me with this? anyone had a similar problem?

Thanks

Hi team, we have a problem on setInterval() implementation. We use this function from the frontend in order to update a number every 30 seconds. This makes that when the core connects to database, the sql connections were taken and not released at time.

I think it could be the async function, because the sql connection is opened and closed correctly. Its a very simple function but we can´t detect why this is happenning.

Could you help me about this?

Example: FRONTEND TS

this.balanceTimer = setInterval(() => {
            this._serviceProxy.updateNumber(this.appSession.user.id).subscribe((aux) =>
            {
            }); 
        }, 30000); 

CORE

Task<decimal> UpdateNumber(int userId);

public async Task<decimal> UpdateNumber(int userId)
        {
            decimal aux = 0;
            using (var con = new SqlConnection(_connString))
            using (var cmd = new SqlCommand("UpdateAux", con)) {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
                con.Open();

                using (var rd = await cmd.ExecuteReaderAsync()) {
                    while (rd.Read()) {
                        aux = Convert.ToDecimal(rd["AuxNumber"]);
                    }
                }
                con.Close();
            }
            return aux;
        }

Regards

i get failed request when calling AbpUserConfiguration-getall or GetCurrentLoginInformations.....sometimes if a refresh the page like 10 ten time, it get fixed,

when running on a local computer (localhost) this never happen.

this is really frustating, the client is expecting the final release and i dont know what to say,

please, help me out here.

i can send you the code if it helps

whats the procedure in order to replace the logo with a custom one?

can you send us a sample code to add collections coming from another entity (one to many reletaion in the DB)

after the execution of a the basic rapid tool crud extension....

quick sample

name, surname, age

and then extend same class by adding a telephone collection.

name, surname, age, PHONES[]