Activities of "okains"

Hi,

Would it be easier to give you access to the GitHub repo? This would be a very big file otherwise.

Thanks,

Karim

Hi,

I have shared the full debug logs of the site load and login attempt. Here is a screenshot of the db error that I believe is causing these 400 errors:

Thanks,

Karim

OK but this is happening during the login process, seems to be on the db connection that pulls the OpenIddictApplications record for the BlazorWebAppTiered client.

So I would need to pull the source code for login then and try and handle it in there? Any info on what method I should focus on , or any other ideas on how to best do this?

Hi,

Yeah I understand that, question is how to handle this without being able to use EnableRetryOnFailure. Is there a best practice with ABP for this?

Is there any plan on implementing this in a future version?

Thanks,

Karim

• ABP Framework version: v8.2.3
• UI Type: Blazor Server
• Database System: EF Core (SQL Server)
• Tiered (for MVC) or Auth Server Separated (for Angular): yes
• Exception message and full stack trace:
• Steps to reproduce the issue:

Hi,

I have been deploying to Azure Deployment Slots, and I am getting transient db errors in the logs on the Auth project that are causing me to often get 400 Errors returned. The log errors are initially in this format:

2024-09-06 15:20:30.990 +00:00 [ERR] An error occurred using the connection to database 'ESv2-testing' on server 'tcp:hathor-hk.database.windows.net,1433'.

Resulting in this:

Following the suggestion of ChatGPT, I added EnableRetryOnFailure:

Configure<AbpDbContextOptions>(options => { /* The main point to change your DBMS. * See also ESv2DbContextFactory for EF Core tooling. */ options.UseSqlServer(sqlOptions => sqlOptions.EnableRetryOnFailure(5, TimeSpan.FromSeconds(10), null)); });

But it seems this may not be supported in ABP.

I am now getting the following in my logs :

2024-09-06 13:08:13.988 +00:00 [ERR] An exception occurred while iterating over the results of a query for context type 'Volo.Abp.TextTemplateManagement.EntityFrameworkCore.TextTemplateManagementDbContext'. System.InvalidOperationException: The configured execution strategy 'SqlServerRetryingExecutionStrategy' does not support user-initiated transactions. Use the execution strategy returned by 'DbContext.Database.CreateExecutionStrategy()' to execute all the operations in the transaction as a retriable unit. at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.OnFirstExecution()

Is there another approach to handling these errors?

This particular exception that is logged: [ERR] An exception occurred while iterating over the results of a query for context type 'Volo.Abp.TextTemplateManagement.EntityFrameworkCore.TextTemplateManagementDbContext'.

Is this maybe the root cause here? This doesn't happen all of the time though, any idea on what is going on here?

Thanks,

Karim Ainsworth

Hi,

OK I updated everything as suggested, still the same issue. When I hover over it is showing javascript:void(0) as the link. Is that normal? I don't see any way to reproduce this in a template project, there is just something wrong with my project it seems.

Looking for any suggestions on where to look / troubleshoot to try and fix this. Concerned that maybe some scripts aren't loading correctly or something like that?

• ABP Framework version: v8.2.0
• UI Type: Blazor Server
• Database System: EF Core (SQL Server)
• Tiered (for MVC) or Auth Server Separated (for Angular): yes
• Exception message and full stack trace:
• Steps to reproduce the issue:

My logged in user menu doesn't open on click, other menus in the header are working fine. Any idea on how to get this fixed?

Thanks,

Karim Ainsworth

Hi,

Thank you, this all works now. Thanks for sticking with this, it was a long one, I appreciate your help.

Karim

Ah OK, that works, now the menu items are showing. However, when I click on My Account I am getting an exception thrown, also on Security Logs and Sessions, which seems like the same error from looking at the logs.

Seems like the currentUser isn't being set, is there something else we are missing here?

Thanks,

Karim

Hi,

Yes you can. Just log in with admin , default password. You should get to that exact screen, where it does look like we are logged in however no profile menu. Use the staging branch, it is exactly what is deployed now.

Thanks,

Karim