升级至Entity Framework Core Interbase SQL 7.13.1后新增用户报错求助

异常1：带参数查询触发IBException（错误码-104） #

Exception thrown: 'InterBaseSql.Data.InterBaseClient.IBException' in System.Private.CoreLib.dll
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, column 29

异常2：升级至7.13.1后新增用户触发DbUpdateException（内部错误-303） #

堆栈信息 #

Microsoft.EntityFrameworkCore.DbUpdateException
  HResult=0x80131500
  Message=An error occurred while saving the entity changes. See the inner exception for details.
  Source=Microsoft.EntityFrameworkCore.Relational
  StackTrace:
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.<ExecuteAsync>d__29.MoveNext()
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.<ExecuteAsync>d__9.MoveNext()
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.<ExecuteAsync>d__9.MoveNext()
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.<ExecuteAsync>d__9.MoveNext()
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<SaveChangesAsync>d__103.MoveNext()
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<SaveChangesAsync>d__107.MoveNext()
   at Microsoft.EntityFrameworkCore.DbContext.<SaveChangesAsync>d__60.MoveNext()
   at Microsoft.EntityFrameworkCore.DbContext.<SaveChangesAsync>d__60.MoveNext()
   at Common.DataAccess.EFCore.Repositories.BaseUserRepository`2.<Edit>d__2.MoveNext() in C:\bundle2\bundle-interbase\backend\src\Common\Common.DataAccess.EFCore\Repositories\BaseUserRepository.cs:line 45
   at Common.Services.UserService`1.<Edit>d__5.MoveNext() in C:\bundle2\bundle-interbase\backend\src\Common\Common.Services\UserService.cs:line 45
   at Common.WebApiCore.Controllers.UsersController.<Create>d__7.MoveNext() in C:\bundle2\bundle-interbase\backend\src\Common\Common.WebApiCore\Controllers\UsersController.cs:line 75
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.<Execute>d__0.MoveNext()
   at System.Threading.Tasks.ValueTask`1.get_Result()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<<InvokeActionMethodAsync>g__Awaited|12_0>d.MoveNext()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<<InvokeNextActionFilterAsync>g__Awaited|10_0>d.MoveNext()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<<InvokeFilterPipelineAsync>g__Awaited|20_0>d.MoveNext()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<<InvokeAsync>g__Logged|17_1>d.MoveNext()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<<InvokeAsync>g__Logged|17_1>d.MoveNext()
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<<Invoke>g__AwaitRequestTask|6_0>d.MoveNext()
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.<Invoke>d__9.MoveNext()
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.<Invoke>d__6.MoveNext()
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.<Invoke>d__5.MoveNext()
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.<Invoke>d__4.MoveNext()
   at Common.WebApiCore.Setup.ErrorHandlingMiddleware.<Invoke>d__3.MoveNext() in C:\bundle2\bundle-interbase\backend\src\Common\Common.WebApiCore\Setup\ErrorHandlingMiddleware.cs:line 32

  This exception was originally thrown at this call stack:
    [External Code]

Inner Exception 1:
IBException: Dynamic SQL Error
SQL error code = -303
internal error

内部嵌套异常 #

Inner Exception 2:
IscException: Dynamic SQL Error
SQL error code = -303
internal error

解决建议 #

针对错误码-104（Token unknown） #

• 开启EF Core SQL日志，查看生成的SQL语句，定位第3行第29位的未知Token。可在DbContext配置中添加LogTo(Console.WriteLine, LogLevel.Information)输出SQL。
• 检查生成的SQL是否包含InterBase保留关键字（如USER、ROLE），这类标识符需用双引号包裹。
• 确认InterBase EF Core驱动版本与EF Core版本兼容，检查参数占位符格式是否符合InterBase要求（InterBase默认用?作为占位符）。

针对错误码-303（Internal Error） #

• 检查InterBase服务器版本与7.13.1版本驱动的兼容性，优先升级服务器到对应兼容版本。
• 查看EF生成的插入/更新SQL，排查是否存在多对多关联（用户、角色、声明）导致的语法错误或数据类型不匹配问题。
• 禁用EF Core批量更新功能，尝试单条保存。可在DbContextOptionsBuilder中配置UseInterBase().DisableBatchUpdates()。
• 查看InterBase服务器日志文件（通常为interbase.log），获取更详细的内部错误信息。
• 尝试回退驱动版本至之前可用版本，确认是否为7.13.1版本驱动引入的兼容性问题，同时查看驱动发布日志排查已知问题。

内容的提问来源于stack exchange，提问作者Craig Cookesley