【9.0.4】日志，找到的记录数大于1行，可以知道具体是哪里吗？

{  "ClassName": "System.Exception",  "Message": "找到的记录数大于1行。",  "Data": null,  "InnerException": null,  "HelpURL": null,  "StackTraceString": "   at Forguncy.Server2.Controllers.HomeController.a(Dictionary`2 A_0, SetParameterCommand A_1, CalcBindingDataSourceOption A_2)   at Forguncy.Server2.Controllers.HomeController.CalcParamValue(CalcParamValueParam param)   at lambda_method1485(Closure , Object )   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)   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>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)   at Forguncy.Server2.KatanaMiddleware.CodeEditorMiddleware.InvokeAsync(HttpContext context)   at Forguncy.Server2.KatanaMiddleware.ProcessEngineMiddleware.InvokeAsync(HttpContext context, ICacheService cacheService)   at Forguncy.Server2.KatanaMiddleware.ReportsMiddleware.InvokeAsync(HttpContext context, ICacheService cacheService, IReportServerService reportServerService)   at Forguncy.KatanaMiddleware.ServerCommandMiddleware.InvokeAsync(HttpContext context)   at Forguncy.KatanaMiddleware.k.InvokeAsync(HttpContext context)   at Forguncy.KatanaMiddleware.j.InvokeAsync(HttpContext context)   at Forguncy.Server2.KatanaMiddleware.StartPageMiddleware.InvokeAsync(HttpContext context)   at ForguncyServerCommon.HttpHeaderMiddlewareBase.InvokeAsync(HttpContext context)   at Forguncy.KatanaMiddleware.q.InvokeAsync(HttpContext context)",  "RemoteStackTraceString": null,  "RemoteStackIndex": 0,  "ExceptionMethod": null,  "HResult": -2146233088,  "Source": "Forguncy.Server2",  "WatsonBuckets": null}

用户名

廖蓉

请求路径

/Home/CalcParamValue

请求Id

699ca1a0-88ed-40a1-92a5-263edd353d51

可以试着用错误信息中 请求ID  查询下其他日志，不仅仅是异常日志，看看其它日志有没有更多信息

{"@timestamp":"2024-10-21T01:34:30.0976315Z","@m":"@I","LogType":"ServerCommandLog","RequestId":"0ca8eaa2-6ca0-4856-9d56-7aa67596083f","Log":"09:34 执行'校验_手工录入数据'命令, 请求方式OST, 用户:李红梅\n错误码: 0\n'校验_手工录入数据'命令执行结束, 用时:8毫秒。\n","ErrCode":0,"FolderName":"报表_工序汇报","StartTime":"2024-10-21T09:34:30.0894082+08:00","CommandName":"校验_手工录入数据","UserName":"李红梅"}
{"@timestamp":"2024-10-21T01:34:30.5655979Z","@m":"@I","LogType":"ServerCommandLog","RequestId":"fdae9c7c-b169-497f-87a6-98ecee2fb549","Log":"09:34 执行'新增_手工工序汇报最新'命令, 请求方式OST, 用户:李红梅\n错误码: 0\n信息: 成功\n'新增_手工工序汇报最新'命令执行结束, 用时:433毫秒。\n","Message":"成功","ErrCode":0,"FolderName":"报表_工序汇报","StartTime":"2024-10-21T09:34:30.1319598+08:00","CommandName":"新增_手工工序汇报最新","UserName":"李红梅"}
{"@timestamp":"2024-10-21T01:34:30.6936142Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"be4f70aa-b5f4-47f0-8beb-39031ab17d42","Duration":1.2814,"aramItems":"@p0=周金香","Sql":"select  a.[员工名称] as C0,a.[员工名称] as C1 from [dbo].[V_MES_ProcessDebriefing] as a Where a.[员工名称] = @p0 group by a.[员工名称],a.[员工名称]  "}
{"@timestamp":"2024-10-21T01:34:30.7057983Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"f9facbb7-8475-47d5-b9d6-ef55b9825f95","Duration":10.4134,"Sql":"select  a.[FGC_Rowversion] as C0,a.[ID] as C1 from [dbo].[T_MES_ProcessDebriefing] as a Where a.[ID] = 25191  "}
{"@timestamp":"2024-10-21T01:34:30.8112200Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"25534f6d-7496-4789-8e4a-6bbc02b3ca38","Duration":1.8398,"aramItems":"@p0=2024-10-20 上午12:00:00,@p1=2024-10-21 上午12:00:00","Sql":"select  a.[Sort] as C0,a.[ID] as C1,a.[包装ID] as C2,a.[ProcessNo] as C3,a.[EmployeeNo] as C4,a.[DataSource] as C5,a.[ERP员工编号] as C6,a.[EmpName] as C7,a.[员工部门] as C8,a.[Date] as C9,a.[ProductNo] as C10,a.[ProductName] as C11,a.[ProSpecifications] as C12,a.[工艺路线] as C13,a.[ProcessName] as C14,a.[ReportNumber] as C15,a.[HandNumber] as C16,a.[差异数量] as C17,a.[Price] as C18,a.[SysWages] as C19,a.[Wages] as C20,a.[notes] as C21,a.[FGC_Rowversion] as C22 from [dbo].[T_MES_ProcessDebriefing] as a Where a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1 AND a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1  ORDER BY a.[Date] DESC,a.[ProductNo] ASC,a.[ProcessNo] ASC,a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:30.8112685Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"25534f6d-7496-4789-8e4a-6bbc02b3ca38","Duration":1.2286,"aramItems":"@p0=2024-10-20 上午12:00:00,@p1=2024-10-21 上午12:00:00","Sql":"select  COUNT(a.[DataSource]) as C0 from [dbo].[T_MES_ProcessDebriefing] as a Where a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1 AND a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1  "}
{"@timestamp":"2024-10-21T01:34:30.8112771Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"25534f6d-7496-4789-8e4a-6bbc02b3ca38","Duration":1.3284,"aramItems":"@p0=2024-10-20 上午12:00:00,@p1=2024-10-21 上午12:00:00","Sql":"select  SUM(a.[ReportNumber]) as C0 from [dbo].[T_MES_ProcessDebriefing] as a Where a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1 AND a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1  "}
{"@timestamp":"2024-10-21T01:34:30.8112840Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"25534f6d-7496-4789-8e4a-6bbc02b3ca38","Duration":6.326,"aramItems":"@p0=2024-10-20 上午12:00:00,@p1=2024-10-21 上午12:00:00","Sql":"select  SUM(a.[HandNumber]) as C0 from [dbo].[T_MES_ProcessDebriefing] as a Where a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1 AND a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1  "}
{"@timestamp":"2024-10-21T01:34:30.8112925Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"25534f6d-7496-4789-8e4a-6bbc02b3ca38","Duration":1.4299,"aramItems":"@p0=2024-10-20 上午12:00:00,@p1=2024-10-21 上午12:00:00","Sql":"select  SUM(a.[SysWages]) as C0 from [dbo].[T_MES_ProcessDebriefing] as a Where a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1 AND a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1  "}
{"@timestamp":"2024-10-21T01:34:30.8112986Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"25534f6d-7496-4789-8e4a-6bbc02b3ca38","Duration":1.7337,"aramItems":"@p0=2024-10-20 上午12:00:00,@p1=2024-10-21 上午12:00:00","Sql":"select  SUM(a.[Wages]) as C0 from [dbo].[T_MES_ProcessDebriefing] as a Where a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1 AND a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1  "}
{"@timestamp":"2024-10-21T01:34:31.4925702Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"2eaa9abd-ced0-4988-850a-f6a76fab8ca2","Duration":3.0168,"Sql":"select  a.[ProductName] as C0,a.[ID] as C1 from [dbo].[T_MES_ProcessDebriefing] as a   ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:31.5097740Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"9c5ab14a-4a47-4bc6-9ed2-8300fa2b46bd","Duration":3.2835,"Sql":"select  a.[ProductNo] as C0,a.[ID] as C1 from [dbo].[T_MES_ProcessDebriefing] as a   ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:31.5200782Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"5d3034e4-4bc5-45a9-8a89-b1cb292a4adb","Duration":1.3751,"Sql":"select  a.[ProSpecifications] as C0,a.[ID] as C1 from [dbo].[T_MES_ProcessDebriefing] as a   ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:31.5234111Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"a090e45d-2291-4f59-8ba9-8a9e062cd186","Duration":8.8807,"Sql":"select  a.[ProcessName] as C0,a.[ID] as C1 from [dbo].[T_MES_ProcessDebriefing] as a   ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:39.8959220Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"b2a52108-5e67-4393-9a58-a2e3c4cddaa0","Duration":0.7788,"Sql":"select Top 1  a.[序号] as C0,a.[ID] as C1 from [dbo].[V_MES_CPKID_LIST] as a   ORDER BY a.[ID] DESC"}
{"@timestamp":"2024-10-21T01:34:39.9099676Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"9fbbab23-898f-477a-8513-740b3ca48f06","Duration":0.6586,"Sql":"select  a.[ID] as C0 from [dbo].[V_MES_CPKID_LIST] as a Where a.[序号] = 1  ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:39.9227764Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"43b79ad8-e1af-4587-af02-4ea9d7f5a6a0","Duration":0.4775,"Sql":"select  a.[ID] as C0,a.[编号] as C1,a.[产品型号] as C2,a.[批号] as C3,a.[设备编号] as C4,a.[公称尺寸] as C5,a.[工程名] as C6,a.[产品特性] as C7,a.[测量仪器] as C8,a.[测量人] as C9,a.[记录人] as C10,a.[上限值] as C11,a.[中心值] as C12,a.[下限值] as C13 from [dbo].[CPK配置表] as a Where a.[ID] = 5  ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:39.9467958Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"a7667198-691c-4808-90bc-2e21036d8ceb","Duration":0.5913,"Sql":"select  a.[PID] as C0,a.[第一次] as C1,a.[第二次] as C2,a.[第三次] as C3,a.[第四次] as C4,a.[第五次] as C5,a.[FGC_Rowversion] as C6,a.[ID] as C7 from [dbo].[CPK配置明细表] as a Where a.[PID] = 5  ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:39.9575528Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"eac9cd7a-2a51-40be-b641-0dc883cf3f80","Duration":0.4037,"Sql":"select  a.[FGC_Rowversion] as C0,a.[ID] as C1 from [dbo].[CPK配置明细表] as a Where a.[ID] = 73  "}
{"@timestamp":"2024-10-21T01:34:41.1318604Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"37b573f8-8abc-4f3a-94a4-1b3ca7506ac7","Duration":0.8023,"aramItems":"@p0=D212D897-53A6-4450-BBC3-9EB6523B527F","Sql":"select  a.[MOBillNO] as C0 from [dbo].[T_MES_JO] as a Where (a.[JobOrderStatus] <> 902004 OR a.[JobOrderStatus]  is null ) AND a.[Material] = @p0 group by a.[MOBillNO]  "}
{"@timestamp":"2024-10-21T01:34:41.1330923Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"d229a22c-c0f1-43f4-ad0d-2e6cdd3872a0","Duration":1.5411,"aramItems":"@p0=1a1b45e1-2892-474d-a17f-8404894cb0f3,@p1=","Sql":"select  a.[ID] as C0,a.[checkNo] as C1,a.[MaterialNo] as C2,a.[工序号] as C3,a.[Number] as C4,a.[FeatureContent] as C5,a.[Important] as C6,a.[TopValue] as C7,a.[DownValue] as C8,a.[CheckTech] as C9,a.[ContorlTech] as C10,a.[FGC_Rowversion] as C11 from [dbo].[T_MES_CheckConfig] as a Where a.[MaterialNo] = @p0 AND  1 = 0  AND (a.[CheckTech] not in (N'476e56ed-344c-4ea1-bb2f-641a1e861710') OR a.[CheckTech]  is null  OR a.[CheckTech] = @p1)  ORDER BY a.[Number] ASC,a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:41.1407843Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"bbd63a4f-c2d9-4547-a4ff-1d20921c3435","Duration":0.9762,"aramItems":"@p0=质量部,@p1=1,@p2=","Sql":"select  a.[EmployeeNo] as C0,a.[Name] as C1 from [dbo].[T_HR_PersonnelList] as a Where a.[WorkShop] = @p0 AND (a.[IsDelete] = @p1 OR a.[IsDelete]  is null  OR a.[IsDelete] = @p2) group by a.[EmployeeNo],a.[Name]  "}
{"@timestamp":"2024-10-21T01:34:41.2731003Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"893ef918-730a-40ac-a129-19a122463f29","Duration":0.9698,"ParamItems":"@p0=于蕾","Sql":"select Top 1  a.[EmployeeNo] as C0,a.[ID] as C1 from [dbo].[T_HR_PersonnelList] as a Where a.[Name] = @p0  ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:41.3039817Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"ffc4a656-3b91-433a-93f8-c70f95e3acf5","Duration":0.6555,"ParamItems":"@p0=送检内容名称","Sql":"select  a.[MName] as C0,a.[ID] as C1 from [dbo].[T_MES_Inspect_Configuration] as a Where a.[ConfigurationType] = @p0  ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:41.3893454Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"1058fefe-4f33-49a2-b451-e16fc26f7f4e","Duration":0.6131,"ParamItems":"@p0=d62846a2-69bf-4317-b637-bc250e1b45c4,@p1=","Sql":"select  a.[ID] as C0,a.[checkNo] as C1,a.[MaterialNo] as C2,a.[工序号] as C3,a.[Number] as C4,a.[FeatureContent] as C5,a.[Important] as C6,a.[TopValue] as C7,a.[DownValue] as C8,a.[CheckTech] as C9,a.[ContorlTech] as C10,a.[FGC_Rowversion] as C11 from [dbo].[T_MES_CheckConfig] as a Where a.[MaterialNo] = @p0 AND  1 = 0  AND (a.[CheckTech] not in (N'投影仪',N'三坐标',N'轮廓仪',N'齿轮检测仪',N'光扫仪') OR a.[CheckTech]  is null  OR a.[CheckTech] = @p1)  ORDER BY a.[Number] ASC,a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:43.9770149Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"7bbba073-d52b-4dc5-9e6a-618c55cb6cd7","Duration":37.7112,"Sql":"select  a.[员工名称] as C0,a.[ERP员工编号] as C1 from [dbo].[V_MES_ProcessDebriefing] as a  group by a.[员工名称],a.[ERP员工编号]  "}
{"@timestamp":"2024-10-21T01:34:47.4417075Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"5e60963d-5578-4699-8990-893b4408faf4","Duration":1.5834,"ParamItems":"@p0=2024-10-20 上午12:00:00,@p1=2024-10-21 上午12:00:00","Sql":"select  a.[Sort] as C0,a.[ID] as C1,a.[包装ID] as C2,a.[ProcessNo] as C3,a.[EmployeeNo] as C4,a.[DataSource] as C5,a.[ERP员工编号] as C6,a.[EmpName] as C7,a.[员工部门] as C8,a.[Date] as C9,a.[ProductNo] as C10,a.[ProductName] as C11,a.[ProSpecifications] as C12,a.[工艺路线] as C13,a.[ProcessName] as C14,a.[ReportNumber] as C15,a.[HandNumber] as C16,a.[差异数量] as C17,a.[Price] as C18,a.[SysWages] as C19,a.[Wages] as C20,a.[notes] as C21,a.[FGC_Rowversion] as C22 from [dbo].[T_MES_ProcessDebriefing] as a Where a.[EmpName] in (N'周金香') AND a.[Date] >= @p0 AND a.[Date] < @p1 AND a.[EmpName] in (N'刘云龙') AND a.[Date] >= @p0 AND a.[Date] < @p1  ORDER BY a.[Date] DESC,a.[ProductNo] ASC,a.[ProcessNo] ASC,a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:47.6151645Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"d24845dd-3f24-4363-accb-e13b5c405a7a","Duration":0.6719,"ParamItems":"@p0=2409200745-01-023","Sql":"select COUNT(*) from [dbo].[T_MES_JO_ProcessFlowCard] as a  Where a.[PFCNO] = @p0"}
{"@timestamp":"2024-10-21T01:34:47.6695013Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"6880518a-b828-405b-8a6b-0708ebaf07c9","Duration":0.6638,"ParamItems":"@p0=2409200745-01-023","Sql":"select COUNT(*) from [dbo].[T_MES_JO] as a  Where a.[JobOrderNo] = @p0"}
{"@timestamp":"2024-10-21T01:34:47.8075764Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"cbb42107-920d-48b8-b5eb-7beb426055de","Duration":0.7345,"ParamItems":"@p0=2409200745-01-023","Sql":"select  a1.[MOBillNO] as C0,a1.[Material] as C1,a.[operateNO] as C2,a.[ProcessNumber_Cur] as C3,a.[JobOrderNo] as C4,a.[SoftDelete] as C5,a1.[FMoEntryId] as C6,a.[Qty] as C7,a.[ID] as C8 from [dbo].[T_MES_JO_ProcessFlowCard] as a  left join [dbo].[T_MES_JO] as a1 on a.[JobOrderNo] = a1.[JobOrderNo] Where a.[PFCNO] = @p0  ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:47.8343192Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"7cb0d044-8965-4832-850d-5869928972f5","Duration":2.2507,"ParamItems":"@p0=3.12.6141521505","Sql":"select COUNT(*) from [dbo].[T_ENG_ROUTE] as a  Where a.[FMATERIALNumber] = @p0"}
{"@timestamp":"2024-10-21T01:34:47.8648036Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"06676dc9-3ad6-4eb8-87b2-313a3b79bc2f","Duration":1.7903,"ParamItems":"@p0=3.12.6141521505","Sql":"select  a.[FNumber] as C0,a.[ID] as C1 from [dbo].[T_ENG_ROUTE] as a Where a.[FMATERIALNumber] = @p0  ORDER BY a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:47.8714004Z","@m":"@E","@l":"Error","LogType":"ExceptionLog","RequestId":"06676dc9-3ad6-4eb8-87b2-313a3b79bc2f","ExceptionCallStack":"{\n  \"ClassName\": \"System.Exception\",\n  \"Message\": \"找到的记录数大于1行。\",\n  \"Data\": null,\n  \"InnerException\": null,\n  \"HelpURL\": null,\n  \"StackTraceString\": \"   at Forguncy.Server2.Controllers.HomeController.a(Dictionary`2 A_0, SetParameterCommand A_1, CalcBindingDataSourceOption A_2)\r\n   at Forguncy.Server2.Controllers.HomeController.CalcParamValue(CalcParamValueParam param)\r\n   at lambda_method1485(Closure , Object )\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.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>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\r\n   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_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.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 Forguncy.Server2.KatanaMiddleware.CodeEditorMiddleware.InvokeAsync(HttpContext context)\r\n   at Forguncy.Server2.KatanaMiddleware.ProcessEngineMiddleware.InvokeAsync(HttpContext context, ICacheService cacheService)\r\n   at Forguncy.Server2.KatanaMiddleware.ReportsMiddleware.InvokeAsync(HttpContext context, ICacheService cacheService, IReportServerService reportServerService)\r\n   at Forguncy.KatanaMiddleware.ServerCommandMiddleware.InvokeAsync(HttpContext context)\r\n   at Forguncy.KatanaMiddleware.k.InvokeAsync(HttpContext context)\r\n   at Forguncy.KatanaMiddleware.j.InvokeAsync(HttpContext context)\r\n   at Forguncy.Server2.KatanaMiddleware.StartPageMiddleware.InvokeAsync(HttpContext context)\r\n   at ForguncyServerCommon.HttpHeaderMiddlewareBase.InvokeAsync(HttpContext context)\r\n   at Forguncy.KatanaMiddleware.q.InvokeAsync(HttpContext context)\",\n  \"RemoteStackTraceString\": null,\n  \"RemoteStackIndex\": 0,\n  \"ExceptionMethod\": null,\n  \"HResult\": -2146233088,\n  \"Source\": \"Forguncy.Server2\",\n  \"WatsonBuckets\": null\n}","UserName":"于蕾","Path":"/Home/CalcParamValue"}
{"@timestamp":"2024-10-21T01:34:47.9159550Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"a0401d7f-8955-4a12-90ce-7e32978eb8a4","Duration":1.1725,"ParamItems":"@p0=3.12.6141521505","Sql":"select  a.[MOBillNO] as C0 from [dbo].[T_MES_JO] as a Where (a.[JobOrderStatus] <> 902004 OR a.[JobOrderStatus]  is null ) AND a.[Material] = @p0 group by a.[MOBillNO]  "}
{"@timestamp":"2024-10-21T01:34:47.9688117Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"adb41e69-b76e-4cef-a7b6-a6d6c17ae6b6","Duration":0.6945,"ParamItems":"@p0=3.12.6141521505,@p1=","Sql":"select  a.[ID] as C0,a.[checkNo] as C1,a.[MaterialNo] as C2,a.[工序号] as C3,a.[Number] as C4,a.[FeatureContent] as C5,a.[Important] as C6,a.[TopValue] as C7,a.[DownValue] as C8,a.[CheckTech] as C9,a.[ContorlTech] as C10,a.[FGC_Rowversion] as C11 from [dbo].[T_MES_CheckConfig] as a Where a.[MaterialNo] = @p0 AND  1 = 0  AND (a.[CheckTech] not in (N'投影仪',N'三坐标',N'轮廓仪',N'齿轮检测仪',N'光扫仪') OR a.[CheckTech]  is null  OR a.[CheckTech] = @p1)  ORDER BY a.[Number] ASC,a.[ID] ASC"}
{"@timestamp":"2024-10-21T01:34:48.0729976Z","@m":"@I","LogType":"ExecuteSqlLog","RequestId":"61e40f4e-20cc-46d1-b7bd-cb252e188421","Duration":1.4681,"ParamItems":"@p0=3.12.6141521505","Sql":"select COUNT(*) from [dbo].[T_ENG_ROUTE] as a  Where a.[FMATERIALNumber] = @p0"}

你这粘贴也不是一个请求ID 下的日志呀

感谢大佬的支持。
您可以在诊断日志里拿到上下文 ID，然后去审计日志里做过滤，审计日志里有 SQL 和页面相关信息，方便我们定位问题。
详情可以参考下面这个帖子：

活字格10.0 update1新功能解密：十九丶日志和监控模块增强
https://gcdn.grapecity.com.cn/showtopic-224899-1-1.html
(出处: 葡萄城开发者社区)

9.0  版本没有这个功能吧？

日志的检索和查看是一样的，或者您那边把服务器的错误信息收集检索下，这边看看。

服务器日志收集，已经上传。

您好，看了下日志，其中和帖子中截图的爆粗香港的执行 SQL 日志是这个：

{"@timestamp":"2024-10-21T01:39:47.1661766Z","@m":"@I","LogType":"ExecuteSqlLog",
"RequestId":"699ca1a0-88ed-40a1-92a5-263edd353d51","Duration":1.5127,
"ParamItems":"@p0=3.12.6141521505",
"Sql":"select  a.[FNumber] as C0,a.[ID] as C1 from [dbo].[T_ENG_ROUTE] as a Where a.[FMATERIALNumber] = @p0  ORDER BY a.[ID] ASC"}

可以在设计器里搜索下 T_ENG_ROUTE 这个表的使用位置，要看设置变量命令，然后用 FMATERIALNumber 做过滤，查询的是单行记录，但实际会查询出多条，所以报错。

Simon.Sun 发表于 2024-10-21 14:40
您好，看了下日志，其中和帖子中截图的爆粗香港的执行 SQL 日志是这个：

{"@timestamp":"2024-10-21T01: ...

这个我能定位出来。  问题是现在没有办法定位是哪一个页面，或者 哪一个服务端命令 打印的日志。  因为使用这张表的地方太多太多了。  搜索这个表的引用 几十个。