Activities of "ravindrapatail"

Abp version is Version v7.1.0.0 Nuget versions are as below

to give more informtion, in the application log below error is comming several time ERROR 2024-07-31 22:40:41,179 [86 ] e.Diagnostics.ExceptionHandlerMiddleware - An unhandled exception has occurred while executing the request. 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.get_Table() at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.GetQueryable() at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.GetAllIncluding(Expression1[] propertySelectors) at Castle.Proxies.Invocations.IRepository2_GetAll.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformSyncUow(IInvocation invocation, UnitOfWorkOptions options) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.IRepository1Proxy.GetAll() at Castle.Proxies.Invocations.AbpTenantManager2_get_Tenants.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.TenantManagerProxy.get_Tenants() at Bit2Sky.Bit2EHR.Sessions.SessionAppService.GetCurrentLoginInformations() in D:\Bit2Sky\CSAAC\server\src\XXX.xxxx.Application\Sessions\SessionAppService.cs:line 45 at Abp.Threading.InternalAsyncHelper.AwaitTaskWithPostActionAndFinallyAndGetResult[T](Task1 actualReturnValue, Func1 postAction, Action1 finalAction) at Bit2Sky.Bit2EHR.Web.Session.PerRequestSessionCache.GetCurrentLoginInformationsAsync() in D:\Bit2Sky\CSAAC\server\src\Bit2Sky.Bit2EHR.Web.Core\Session\PerRequestSessionCache.cs:line 33 at Bit2Sky.Bit2EHR.Web.Controllers.UiController.Index() in D:\Bit2Sky\CSAAC\server\src\Bit2Sky.Bit2EHR.Web.Host\Controllers\UiController.cs:line 47 at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextExceptionFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ExceptionContext context) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync() at Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context) at Abp.AspNetZeroCore.Web.Authentication.JwtBearer.JwtTokenMiddleware.<>c__DisplayClass0_0.<<UseJwtTokenMiddleware>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.Invoke(HttpContext context)

Hello Support

We are using Angular + .netCore Version v7.1.0.0 [20240731]
Our application is continuously crashing at random times on azure, when we have analysed memory dump we found below error, need your urgent attention as this is happening on production server

Abp.EntityFrameworkCore.Uow.DbContextEfCoreTransactionStrategy.CreateDbContext<Abp.Zero.EntityFrameworkCore.AbpZeroCommonDbContext<Bit2Sky.Bit2EHR.Authorization.Roles.Role, Bit2Sky.Bit2EHR.Authorization.Users.User, Bit2Sky.Bit2EHR.EntityFrameworkCore.Bit2EHRDbContext>>(string, Abp.EntityFrameworkCore.IDbContextResolver) is synchronously waiting on System.Threading.WaitHandle.WaitAny(System.Threading.WaitHandle[], int, bool), causing thread pool starvation. Your app may experience the following symptoms under load: Slow web requests Loss of throughput Request timeouts

Can we have your expert view on this error. let me know in case of any addtional information is required

Hi, What is the current status of having multitenancy with SSO? Is this feature available in the latest release?

Prerequisites

Please answer the following questions before submitting an issue. YOU MAY DELETE THE PREREQUISITES SECTION.

• What is your product version? 9.3
• What is your product type (Angular or MVC)? angular
• What is product framework type (.net framework or .net core)? .net core

For Application Authentication we are primarly using OpenID with AAD. We have requirement to call Application APIs from External Application which using AAD login. Just want to understnd how can we use AAD token to call aspnetzero application APIs. if this is not possible what are diffrent approches for SSO.

Let me know if any further information is required, appriciate early response.

Hello ismcagdas,

We would really appreciate if get any temporary solution for this, did you get any response from metronics support, are we planning this fix 10.3 ?

Prerequisites

Please answer the following questions before submitting an issue. YOU MAY DELETE THE PREREQUISITES SECTION.

• What is your product version? 9.2
• What is your product type (Angular or MVC)? angular
• What is product framework type (.net framework or .net core)? .net core

Realtime Notification (signalR) is working Randomly !!

We have Announcements module build using default notification features available in the framework, Most of the time, Recipient need to referesh the application to receive the Notifications We receive below error

Error: Failed to start the connection: Error: Unable to connect to the server with any of the available transports. ServerSentEvents failed: Error: 'ServerSentEvents' is disabled by the client. LongPolling failed: Error: 'LongPolling' is disabled by the client.

Need your expert suggestion.

Hi ismcagdas,

Please help us on this point by discussing it with Metronic and find a fix for this.  Few key users from our client getting hardtime due to this problem. they don't want to use accordion menu.

Prerequisites

Please answer the following questions before submitting an issue.

• What is your product version? 9.3.0
• What is your product type (Angular or MVC)? Angular
• What is product framework type (.net framework or .net core)? .net core

If issue is about UI

• Which theme are you using?
• What are the theme settings?

We are using default theme and small screen resolution user are not able to scroll down in Administation Menu, please refer the screen Awaiting your response asap

Thanks you @ismcagdas, Yes this is very urgent for us, we tried hard diffrent settings using diffrent posts but somehow not able to get AAD token. Please Note that we are using OpenID as external login provider Can you please guide us ? which class and which method will return AAD Token and appropriate place to write code to save this AAD token to DB table.