Can't add a new passkey with an error "An error occurred while processing your request" after publish the Blazor Web App to Azure.

[jinzhao1127]

REGRESSION INFO: Not a regression (Also reproduces on 10.0 Preview 7 and 10.0 RC 2)

INSTALL STEPS:

1. Install VS 18.0 Insiders 1.2 from https://aka.ms/vs/18/insiders/vs_Enterprise.exe

   • Web workload + .NET Desktop workload
   • Including 10.0.100-rc.1.25451.107

Platform

• Windows
• macOS
• Linux

Repro Steps

1. File > New Project > Select "Blazor Web App" template > Next, Give a name > Next > select ".NET 10.0" and change Authentication to "Individual Accounts" and set the Interactive render mode as Server> Create
2. Run the project and can register the account and log in successfully
3. Right-click project > Publish, choose Azure > Next > Azure App Service (Windows) > Next
4. After profile creation, add a database configuration dependency under the "Service Dependencies" node, and configure the Azure SQL database.
5. Publish the application to Azure
6. Click the Register, register a new account and log in using the account just registered
7. Click on the Account, and then click Passkeys

Actual Result

It failed to add Passkey with error "An error occurred while processing your request"

Error Log

Error.
An error occurred while processing your request.
Request ID: 00-d391275d77723d0d2ba62842e0f30370-dfde7fe2092d1c16-00

Development Mode
Swapping to Development environment will display more detailed information about the error that occurred.

The Development environment shouldn't be enabled for deployed applications. It can result in displaying sensitive information from exceptions to end users. For local debugging, enable the Development environment by setting the ASPNETCORE_ENVIRONMENT environment variable to Development and restarting the app.

Expected Result:
It can be add the Passkey successfully.

Note:

1. This issue does not repro for publish to folder
2. This issue does not repro for Running the app
3. When I directly click log in with a passkey, it will pop up the dialog

[jinzhao1127]

I try to add setting the ASPNETCORE_ENVIRONMENT environment variable to Development on Azure App Service. And then add click Passkeys again. the error as below:

Error log:

An unhandled exception occurred while processing the request.
SqlException: Invalid object name 'AspNetUserPasskeys'.
Microsoft.Data.SqlClient.SqlCommand+<>c.<ExecuteDbDataReaderAsync>b__195_0(Task<SqlDataReader> result)

Stack Query Cookies Headers Routing
SqlException: Invalid object name 'AspNetUserPasskeys'.
Microsoft.Data.SqlClient.SqlCommand+<>c.<ExecuteDbDataReaderAsync>b__195_0(Task<SqlDataReader> result)
System.Threading.Tasks.ContinuationResultTaskFromResultTask<TAntecedentResult, TResult>.InnerInvoke()
System.Threading.Tasks.Task+<>c.<.cctor>b__288_0(object obj)
System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, object state)
System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, object state)
System.Threading.Tasks.Task.ExecuteWithThreadLocal(ref Task currentTaskSlot, Thread threadPoolThread)
Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable<T>+AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync<TState, TResult>(TState state, Func<DbContext, TState, CancellationToken, Task<TResult>> operation, Func<DbContext, TState, CancellationToken, Task<ExecutionResult<TResult>>> verifySucceeded, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable<T>+AsyncEnumerator.MoveNextAsync()
Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync<TSource>(IQueryable<TSource> source, CancellationToken cancellationToken)
Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync<TSource>(IQueryable<TSource> source, CancellationToken cancellationToken)
Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserOnlyStore<TUser, TContext, TKey, TUserClaim, TUserLogin, TUserToken, TUserPasskey>.GetPasskeysAsync(TUser user, CancellationToken cancellationToken)
BlazorApp1.Components.Account.Pages.Manage.Passkeys.OnInitializedAsync() in Passkeys.razor
Microsoft.AspNetCore.Components.ComponentBase.RunInitAndSetParametersAsync()
Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle, ComponentState owningComponentState)
Microsoft.AspNetCore.Components.HtmlRendering.Infrastructure.StaticHtmlRenderer.HandleException(Exception exception)
Microsoft.AspNetCore.Components.RenderTree.Renderer.HandleExceptionViaErrorBoundary(Exception error, ComponentState errorSourceOrNull)
Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle, ComponentState owningComponentState)
Microsoft.AspNetCore.Components.Endpoints.EndpointHtmlRenderer.<WaitForNonStreamingPendingTasks>g__Execute|58_0()
Microsoft.AspNetCore.Components.Endpoints.EndpointHtmlRenderer.WaitForResultReady(bool waitForQuiescence, PrerenderedComponentHtmlContent result)
Microsoft.AspNetCore.Components.Endpoints.EndpointHtmlRenderer.RenderEndpointComponent(HttpContext httpContext, Type rootComponentType, ParameterView parameters, bool waitForQuiescence)
System.Runtime.CompilerServices.ValueTaskAwaiter<TResult>.GetResult()
Microsoft.AspNetCore.Components.Endpoints.RazorComponentEndpointInvoker.RenderComponentCore(HttpContext context)
Microsoft.AspNetCore.Components.Endpoints.RazorComponentEndpointInvoker.RenderComponentCore(HttpContext context)
Microsoft.AspNetCore.Components.Rendering.RendererSynchronizationContext+<>c+<<InvokeAsync>b__10_0>d.MoveNext()
Microsoft.AspNetCore.Builder.ServerRazorComponentsEndpointConventionBuilderExtensions+<>c__DisplayClass1_1+<<AddInteractiveServerRenderMode>b__1>d.MoveNext()
Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context)

[jinzhao1127]

cc: @MackinnonBuck

[MackinnonBuck]

@jinzhao1127, do you think there's a chance that you're reusing the same SQL Server instance between a .NET 9 and .NET 10 project? This might explain the error, since the AspNetUserPasskeys table didn't exist in .NET 9.

If that's not the cause, could you please expand on the steps you took for the "configure the Azure SQL database" step? That way I can make sure I'm precisely following the same steps you are, as I was able to get this to work when I tried it. Thanks 🙂

[jinzhao1127]

@MackinnonBuck We following the below steps to configure the Azure SQL database

1. After the profile is created, In the SQL Server Database tab under Service Dependencies, click Configure > select "Azure SQL Database" > click Next.

2. In Configure Azure SQL Database dialog, click Plus icon to create a new database
3. Click Next, fill in corresponding strings to the specific text boxs, then click "Finish" button to add database
4. Click the publish button
5. Open the Azure SQL Database on the Azure portal. and configure the SQL Database

• Generate script.sql file via following command under the project folder:

dotnet tool install -g dotnet-ef
dotnet ef migrations script -o script1.sql

• Copy the context of script.sql and back to Azure SQL Database page, run the .sql file to add a new query.

• Add a new query to run the following commands to grant the permission for your publish profile ( replace with your App service name):

CREATE USER [<identity-name>] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [<identity-name>];
ALTER ROLE db_datawriter ADD MEMBER [<identity-name>];
ALTER ROLE db_ddladmin ADD MEMBER [<identity-name>];
GO

[jinzhao1127]

@MackinnonBuck , Today I try to create a new database and use the 10.0 Rc 2 dotnet-ef . The Passkeys can added successfully for now. I will close this bug.
Additional: When create the db from the VS the default version is 9.0.3

cc: @balachir

[MackinnonBuck]

Thanks for trying it again, @jinzhao1127! Glad to hear it works well when using the .NET 10 dotnet-ef tool.