Column ‘merge_user_id’ does not belong to table .

RG3.BO.DB\\Services\\DbSqlService$ResDimRowValue.cs:line

{
    "success": false,
    "title": null,
    "error": {
        "httpTraceId": "0HMALP1JDUU4V:00000003",
        "httpMethod": "GET",
        "httpStatusCode": 200,
        "errorCode": 500,
        "errorText": "Column 'merge_user_id' does not belong to table .",
        "message": "Column 'merge_user_id' does not belong to table .",
        "stack": "   at System.Data.DataRow.GetDataColumn(String columnName)\\r\\n   at System.Data.DataRow.get_Item(String columnName)\\r\\n   at RG3.BO.DB.Services.DbSqlService.SetKVA(SqlConfig sqlConfig, SqlColumn sqlColumn, DataRow dr) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.DB\\\\Services\\\\DbSqlService$ResDimRowValue.cs:line 229\\r\\n   at RG3.BO.DB.Services.DbSqlService.SetDimRowValue(RequestModuleType rmt, SqlConfig sqlConfig, DataTable dtAll, Dictionary`2 dicChilds, Boolean kv, SqlColumn sqlColumn, ShowMethod showMethod) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.DB\\\\Services\\\\DbSqlService$ResDimRowValue.cs:line 192\\r\\n   at RG3.BO.DB.Services.DbSqlService.SetResponseFieldDimData(SqlConfig sqlConfig, DataTable dtAll, Dictionary`2 dicChilds, RequestModuleType rmtRoot) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.DB\\\\Services\\\\DbSqlService$ResDim.cs:line 420\\r\\n   at RG3.BO.DB.Services.DbSqlService.SetConvertResponseData(PFGlobalParameter pfGlobal, BCDbConnection dbConnection, List`1 dicResponseResult, Dictionary`2 dicChilds, Dictionary`2 dicSchemaDataAll, ResultObject`1& rm, SqlConfig sqlConfig, Dictionary`2 dictionaryUrl, Dictionary`2 dicSqlConfigChild, Dictionary`2 dicDimData, RequestModuleType rmtRoot, ResponseMethod responseMethod, DataTable dtAll, Boolean isInit) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.DB\\\\Services\\\\DbSqlService$ResStartUp.cs:line 309\\r\\n   at RG3.BO.Qu.Repository.ListRepository.List(PFGlobalParameter pf, String mkey, String resField, Dictionary`2 dictionaryUrl) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.Qu\\\\Repository\\\\ListRepository.cs:line 116\\r\\n   at RG3.BO.Qu.Services.ListService.ListJson(PFGlobalParameter pf, String mkey, String resField, Dictionary`2 dictionaryUrl) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.Qu\\\\Services\\\\ListService.cs:line 143\\r\\n   at RG3.BO.Qu.Services.ListService.ListUsed(String mkey, String resField, JToken jparams, HttpContext httpContext) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.Qu\\\\Services\\\\ListService.cs:line 287\\r\\n   at RG3.PF.Qu.Controller.ListController.ListPost(String mkey, String resField, JToken jparams) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.Qu\\\\Controller\\\\ListController.cs:line 109\\r\\n   at RG3.PF.Qu.Controller.ListController.List(String mkey, String resField) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.BO.Qu\\\\Controller\\\\ListController.cs:line 93\\r\\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\\r\\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)\\r\\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\\r\\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)\\r\\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\\r\\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\\r\\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)\\r\\n   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)\\r\\n   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)\\r\\n   at RG3.PF.Abstractions.Middlewares.GlobalExceptionMiddleware.Invoke(HttpContext context) in C:\\\\0_RG\\\\Code\\\\rg3-pf\\\\RG3.PF.Abstractions\\\\Middlewares\\\\GlobalExceptionMiddleware.cs:line 46",
        "help": "{error.ErrorCode}"
    }
}

查询语句添加缺失的主键别名


不在表中

文档更新时间: 2022-10-24 13:49   作者:admin