核算纬度明细账查询报错 查询出现异常。列名 'FUseOrgId' 无...
金蝶云社区-芒果
芒果
0人赞赏了该文章 900次浏览 未经作者许可,禁止转载编辑于2018年06月20日 09:47:00

核算纬度明细账查询报错 查询出现异常。列名 'FUseOrgId' 无效。INSERT INTO TMP33B9F373742B11E89938E4A4716 (FFLEX5_ID, FFLEX5_GROUPID, FFLEX5_LEVEL, FFLEX5_FULLPARENTID) SELECT FFLEX5_ID, FFLEX5_GROUPID, FFLEX5_LEVEL, FFLEX5_FULLPARENTID FROM (SELECT FDEPTID fflex5_id, FGROUPID fflex5_groupid, FLEVEL fflex5_level, FFULLPARENTID fflex5_fullparentid FROM (SELECT FDEPTID, FMASTERID, FFORBIDSTATUS, FNUMBER, 0 fgroupid, 0 flevel, ' ' ffullparentid FROM T_BD_DEPARTMENT WHERE FGROUP = 0 UNION SELECT T0.FDEPTID, T0.FMASTERID, T0.FFORBIDSTATUS, T0.FNUMBER, BTGLL0.FID fgroupid, BTGLL0.FLEVEL, FFULLPARENTID FROM T_BD_DEPARTMENT T0 INNER JOIN T_BD_DEPARTGROUPLEVEL BTGLL0 ON BTGLL0.FID = T0.FGROUP UNION SELECT T0.FDEPTID, T0.FMASTERID, T0.FFORBIDSTATUS, T0.FNUMBER, 0 fgroupid, (BTGLL0.FLEVEL + 1) flevel, ((BTGLL0.FFULLPARENTID + '.') + CONVERT(VARCHAR(8000), T0.FMASTERID)) ffullparentid FROM T_BD_DEPARTMENT T0 INNER JOIN T_BD_DEPARTGROUPLEVEL BTGLL0 ON (BTGLL0.FID = T0.FGROUP AND (BTGLL0.FLEVEL < 3)) UNION SELECT T0.FDEPTID, T0.FMASTERID, T0.FFORBIDSTATUS, T0.FNUMBER, 0 fgroupid, 4 flevel, BTGLL0.FFULLPARENTID FROM T_BD_DEPARTMENT T0 INNER JOIN T_BD_DEPARTGROUPLEVEL BTGLL0 ON (BTGLL0.FID = T0.FGROUP AND BTGLL0.FLEVEL = 3)) bt0 WHERE (1 = 1 AND BT0.FUseOrgId IN (1))) a

Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)
在 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.GetFlexTempTable(List`1 lstFlexItemTableObject)
在 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.SetFlexDetailInfo()
在 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.SetFilterObject(DynamicObject objCustomFilter)
在 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.InitFilterObjectFromReportParams(IRptParams rptParams)
在 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.GetList(IRptParams rptParams)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)

Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass55.b__51()

7.1+5月补丁,查询条件见图