分析过程:
1、重现问题,服务工具平台-日志收集-取【错误日志】,包含客户端client.log,log4j.log,当前实例的apusic.log
2、分析log4j.log
3、查看rpc线程堆栈和ksql线程
![](C:\Users\Administrator\AppData\Local\YNote\data\qq8A8876B4EA119CB434131E5E15A6B8A3\116d29ab2eb04c32b04661710d8814aa\clipboard.png)
![](C:\Users\Administrator\AppData\Local\YNote\data\qq8A8876B4EA119CB434131E5E15A6B8A3\0b85e98339e24883b7914ffb7ca20a7f\clipboard.png)
![](C:\Users\Administrator\AppData\Local\YNote\data\qq8A8876B4EA119CB434131E5E15A6B8A3\1f8279b9855e48e6852c0dcd6c5291bf\clipboard.png)
![](C:\Users\Administrator\AppData\Local\YNote\data\qq8A8876B4EA119CB434131E5E15A6B8A3\1e910a3a70884038980f231cdcf3e5ac\clipboard.png)
![](C:\Users\Administrator\AppData\Local\YNote\data\qq8A8876B4EA119CB434131E5E15A6B8A3\ec77cd78cada4aba884f54ee2ce51614\clipboard.png)
SELECT FID, FName_l2, FLongNumber, FIsLeaf, FShortCutCode, FOpenMethod, FUiClassName, FImagePath, FFunction,FEnabled,FNumber,FUiClassParam,FUiOprt FROM T_PM_MAINMENUITEM MAIN1 WHERE MAIN1.FPARENT IS NULL AND MAIN1.FIsLeaf = 0 AND EXISTS (SELECT 1 FROM T_PM_MAINMENUITEM MAIN2 WHERE MAIN2.FUICLASSNAME IS NOT NULL AND MAIN2.FUICLASSNAME <> ' ' AND MAIN2.FEnabled = 1 AND MAIN2.FVisible = 1 AND MAIN2.FIsLeaf = 1 AND (MAIN2.FMenuType = 10 OR MAIN2.FMENUTYPE IS NULL) AND MAIN2.FLONGNUMBER||'!' LIKE CONCAT (MAIN1.FLONGNUMBER, '!%') AND ( EXISTS(SELECT 1 FROM ( SELECT FID AS FPermItemID FROM T_PM_PermItem permitem where permitem.FISLEAF = 1 and ( exists ( SELECT 1 from t_pm_userorgperm UserOrgPerm where UserOrgPerm.FOWNER ='JN8/TYLvQzWQmXwJ+NKFTRO33n8=' and UserOrgPerm.FPERMITEMID = permitem.fid AND UserOrgPerm.FPermType = 10) or exists( SELECT 1 FROM t_pm_role role inner join t_pm_roleperm RolePerm on role.FID =RolePerm.FRoleID where RolePerm.FPERMITEMID =permitem.fid and RolePerm.FPermType = 10 and exists (select 1 from T_PM_UserRoleOrg USERROLEORG where USERROLEORG.FUSERID = 'JN8/TYLvQzWQmXwJ+NKFTRO33n8=' and USERROLEORG.FROLEID = role.FID)))) A WHERE MAIN2.FFUNCTION = A.FPermItemID ) OR MAIN2.FFUNCTION IS NULL OR MAIN2.FFUNCTION = ' ' OR MAIN2.FFUNCTION = '') AND (MAIN2.FUiClassName NOT IN ('com.kingdee.eas.rpts.sumreport.client.SumTaskListUI','com.kingdee.eas.rpts.sumreport.client.UploadTaskListUI','com.kingdee.eas.rpts.ctrlreport.client.ExtReportRunUI','com.kingdee.eas.rpts.ctrlreport.client.ReportRunTimeUI') OR MAIN2.FID IN ('NO_SUIT')) AND (MAIN2.FUiClassName NOT IN ('/easweb/bos/qing/publish/analysis.do','com.kingdee.eas.rpts.qinganalysis.ui.PublishedQingAnalysisExplorer') OR MAIN2.FID IN ('NO_SUIT')) ) order by MAIN1.FORDER, MAIN1.flongnumber
![](C:\Users\Administrator\AppData\Local\YNote\data\qq8A8876B4EA119CB434131E5E15A6B8A3\143362f662304dc18b6245cae204140b\clipboard.png)
目前看怀疑该表t_pm_userorgperm表的执行计划没有被分析更新,需要检查
推荐阅读