System.InvalidOperationException

[jasonliao-cb]

we are migration the identity server to the version 7.4.4 with MySql.EntityFrameworkCore 10.0.1 on .net 10. However we face the error below which blocks the upgrade. It seems the FindIdentityResourcesByScopeNameAsync at https://github.com/DuendeSoftware/products/blob/cc5e631a3497bb3b4cc4efc7221de83c59cd0b50/identity-server/src/EntityFramework.Storage/Stores/ResourceStore.cs#L146 is causing the issue, can someone investigate and update a solution?

{
    "@t": "2026-03-02T10:54:19.4572667Z",
    "@m": "An unhandled exception has occurred while executing the request.",
    "@i": "48a46595",
    "@l": "Error",
    "@x": "System.InvalidOperationException: Expression '@scopes' in the SQL tree does not have a type mapping assigned. 
    at Microsoft.EntityFrameworkCore.Query.RelationalTypeMappingPostprocessor.VisitExtension(Expression expression 
    at Microsoft.EntityFrameworkCore.Query.SqlExpressions.InExpression.VisitChildren(ExpressionVisitor visitor 
    at Microsoft.EntityFrameworkCore.Query.RelationalTypeMappingPostprocessor.VisitExtension(Expression expression 
    at Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression.VisitChildren(ExpressionVisitor visitor 
    at Microsoft.EntityFrameworkCore.Query.RelationalTypeMappingPostprocessor.VisitExtension(Expression expression 
    at Microsoft.EntityFrameworkCore.Query.RelationalTypeMappingPostprocessor.VisitExtension(Expression expression 
    at Microsoft.EntityFrameworkCore.Query.RelationalTypeMappingPostprocessor.Process(Expression expression 
    at Microsoft.EntityFrameworkCore.Query.RelationalQueryTranslationPostprocessor.ProcessTypeMappings(Expression expression 
    at Microsoft.EntityFrameworkCore.Query.RelationalQueryTranslationPostprocessor.Process(Expression query 
    at MySql.EntityFrameworkCore.Query.Internal.MySQLQueryTranslationPostprocessor.Process(Expression query 
    at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutorExpression[TResult](Expression query 
    at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query 
    at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async 
    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async 
    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass11_0`1.<ExecuteCore>b__0 
    at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler 
    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteCore[TResult](Expression query, Boolean async, CancellationToken cancellationToken 
    at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteAsync[TResult](Expression query, CancellationToken cancellationToken 
    at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken 
    at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken 
    at System.Runtime.CompilerServices.ConfiguredCancelableAsyncEnumerable`1.GetAsyncEnumerator 
    at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken 
    at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToArrayAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken 
    at Duende.IdentityServer.EntityFramework.Stores.ResourceStore.FindIdentityResourcesByScopeNameAsync(IEnumerable`1 scopeNames in /_/identity-server/src/EntityFramework.Storage/Stores/ResourceStore.cs:line 146 
    at Duende.IdentityServer.Stores.IResourceStoreExtensions.FindResourcesByScopeAsync(IResourceStore store, IEnumerable`1 scopeNames in /_/identity--.cs:line 22 
    at Duende.IdentityServer.Stores.IResourceStoreExtensions.FindEnabledResourcesByScopeAsync(IResourceStore store, IEnumerable`1 scopeNames in /_/identity--.cs:line 92 
    at Duende.IdentityServer.Validation.DefaultResourceValidator.ValidateRequestedResourcesAsync(ResourceValidationRequest request in /_/identity--.cs:line 58 
    at Duende.IdentityServer.Validation.TokenRequestValidator.ValidateRefreshTokenRequestAsync(NameValueCollection parameters in /_/identity--.cs:line 809 
    at Duende.IdentityServer.Validation.TokenRequestValidator.RunValidationAsync(Func`2 validationFunc, NameValueCollection parameters in /_/identity--.cs:line 289 
    at Duende.IdentityServer.Validation.TokenRequestValidator.ValidateRequestAsync(TokenRequestValidationContext context in /_/identity--.cs:line 211 
    at Duende.IdentityServer.Endpoints.TokenEndpoint.ProcessTokenRequestAsync(HttpContext context in /_/identity-server/src/IdentityServer/Endpoints/TokenEndpoint.cs:line 116 
    at Duende.IdentityServer.Endpoints.TokenEndpoint.ProcessAsync(HttpContext context in /_/identity-server/src/IdentityServer/Endpoints/TokenEndpoint.cs:line 77 
    at Duende.IdentityServer.Hosting.IdentityServerMiddleware.Invoke(HttpContext context, IdentityServerOptions options, IEndpointRouter router, IUserSession userSession, IEventService events, IIssuerNameService issuerNameService, ISessionCoordinationService sessionCoordinationService in /_/identity--.cs:line 100 
    at Duende.IdentityServer.Hosting.IdentityServerMiddleware.Invoke(HttpContext context, IdentityServerOptions options, IEndpointRouter router, IUserSession userSession, IEventService events, IIssuerNameService issuerNameService, ISessionCoordinationService sessionCoordinationService in /_/identity--.cs:line 122 
    at Duende.IdentityServer.Hosting.MutualTlsEndpointMiddleware.Invoke(HttpContext context, IAuthenticationSchemeProvider schemes in /_/identity--.cs:line 125 
    at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context 
    at Duende.IdentityServer.Hosting.DynamicProviders.DynamicSchemeAuthenticationMiddleware.Invoke(HttpContext context in /_/identity--.cs:line 57 
    at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.<Invoke>g__InvokeCoreAwaited|15_0(HttpContext context, Task`1 policyTask 
    at Duende.IdentityServer.Hosting.BaseUrlMiddleware.Invoke(HttpContext context in /_/identity--.cs:line 23 
    at OneIAM.Infrastructure.MultiSite.SiteResolutionMiddleware.Invoke(HttpContext context in /app/src/OneIAM.Infrastructure/MultiSite/SiteResolutionMiddleware.cs:line 53 
    at OneIAM.Middlewares.TenantResolutionMiddleware.Invoke(HttpContext context, IIssuerNameService issuerNameService, IKeyMaterialService keys in /app/src/OneIAM.-.cs:line 58 
    at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context 
    at OneIAM.Services.Correlation.CorrelationMiddleware.InvokeAsync(HttpContext context in /app/src/OneIAM.-.cs:line 21 
    at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext 
    at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider 
    at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context 
    at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|10_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)",
    "@tr": "681fb06f94bddcab5306c7bac283fbfb",
    "@sp": "2800b1f0de7fe453",
    "EventId": {
        "Id": 1,
        "Name": "UnhandledException"
    },
    "SourceContext": "Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware",
    "RequestId": "0HNJO8U3BR17Q:00000006",
    "RequestPath": "/oneiam/connect/token",
    "ConnectionId": "0HNJO8U3BR17Q",
    "CorrelationId": "95dbad5d7b8c44c29bd2e7070650e3fa"
}

[jasonliao-cb]

any update?

[wcabus]

This seems to be a bug in the MySql.EntityFrameworkCore NuGet package. Someone has already contributed a bugfix for this, but the fix has not yet been merged or released.