打4.21号补丁,销售所有报表查询错误(BUG)
金蝶云社区-正在输入。。。
正在输入。。。
0人赞赏了该文章 678次浏览 未经作者许可,禁止转载编辑于2017年07月04日 14:20:04

业务场景:客户有5个销售组,每个组只能看自己组的订单,报表查看也是一样; 原来通过角色授权的时候,在数据范围用销售组隔离,打了4.21号补丁,现在查询报错,去除数据范围可以正常查询,请尽快解决?
SELECT * INTO TMP36600878608011E780C91418776 FROM (SELECT FSETTLEORGID fsettleorgid, MAX(CAST(CONVERT(FLOAT, 0) AS INT)) fsaleorgid, MAX(FSALEORGNAME) fsaleorgname, MAX(FSETTLEORGNAME) fsettleorgname, MAX(CAST(CONVERT(FLOAT, 0) AS INT)) fdeptid, MAX(CONVERT(NVARCHAR(100), N' ')) fdeptnumber, MAX(CONVERT(NVARCHAR(100), N' ')) fdeptname, FCUSTOMERID fcustomerid, MAX(FCUSTOMERNUMBER) fcustomernumber, MAX(FCUSTOMERNAME) fcustomername, FMATERIALID fmaterialid, MAX(FMATERIALNUMBER) fmaterialnumber, MAX(FMATERIALNAME) fmaterialname, MAX(CONVERT(NVARCHAR(255), N' ')) fstockname, MAX(CAST(CONVERT(FLOAT, 0) AS INT)) fstocklocid, MAX(FSTOCKLOCNAME) fstocklocname, MAX(FLOT) flot, MAX(FMATERIALMODEL) fmaterialmodel, MAX(FUNITNAME) funitname, MAX(CONVERT(NVARCHAR(30), N' ')) funitname_base, MAX(FCURRENCYNAME) fcurrencyname, SUM(CASE WHEN (FOUTSTOCKQTY IS NULL) THEN 0.0 ELSE FOUTSTOCKQTY END) foutstockqty, SUM(CASE WHEN (FOUTSTOCKQTY_BASE IS NULL) THEN 0.0 ELSE FOUTSTOCKQTY_BASE END) foutstockqty_base, MAX(FOUTSTOCKPRICE) foutstockprice, MAX(FOUTSTOCKPRICE_TAX) foutstockprice_tax, SUM(CASE WHEN (FOUTSTOCKAMOUNT IS NULL) THEN 0.0 ELSE FOUTSTOCKAMOUNT END) foutstockamount, SUM(CASE WHEN (FOUTSTOCKAMOUNT_TAX IS NULL) THEN 0.0 ELSE FOUTSTOCKAMOUNT_TAX END) foutstockamount_tax, MAX(FOUTSTOCKCOST) foutstockcost, SUM(CASE WHEN (FOUTSTOCKTOTALCOST IS NULL) THEN 0.0 ELSE FOUTSTOCKTOTALCOST END) foutstocktotalcost, SUM(CASE WHEN (FRECQTY IS NULL) THEN 0.0 ELSE FRECQTY END) frecqty, SUM(CASE WHEN (FRECQTY_BASE IS NULL) THEN 0.0 ELSE FRECQTY_BASE END) frecqty_base, SUM(CASE WHEN (FRECAMOUNT IS NULL) THEN 0.0 ELSE FRECAMOUNT END) frecamount, SUM(CASE WHEN (FRECAMOUNT_TAX IS NULL) THEN 0.0 ELSE FRECAMOUNT_TAX END) frecamount_tax, SUM(CASE WHEN (FDIFFQTY IS NULL) THEN 0.0 ELSE FDIFFQTY END) fdiffqty, SUM(CASE WHEN (FDIFFQTY_BASE IS NULL) THEN 0.0 ELSE FDIFFQTY_BASE END) fdiffqty_base, SUM(CASE WHEN (FDIFFAMOUNT IS NULL) THEN 0.0 ELSE FDIFFAMOUNT END) fdiffamount, SUM(CASE WHEN (FDIFFAMOUNT_TAX IS NULL) THEN 0.0 ELSE FDIFFAMOUNT_TAX END) fdiffamount_tax, MAX(FPRICEPRECISION) fpriceprecision, MAX(FQTYPRECISION) fqtyprecision, MAX(FAMOUNTPRECISION) famountprecision, MAX(FCURRENCYID) fcurrencyid, MAX(CAST(CONVERT(FLOAT, 0) AS INT)) fbaseunitid_id, MAX(CONVERT(NVARCHAR(100), N' ')) fbaseunitid, MAX(CAST(CONVERT(FLOAT, 0) AS INT)) fstockdeptid, MAX(CAST(CONVERT(FLOAT, 0) AS INT)) fstockorgid, MAX(CONVERT(NVARCHAR(100), N' ')) fsettletypename, MAX(CAST(CONVERT(FLOAT, 0) AS INT)) fsalerid, FSALERNAME fsalername, FMATERIALGROUP fmaterialgroup, FERPCLSID ferpclsid, FCATEGORYID fcategoryid, MAX(FMATERIALGROUPNAME) fmaterialgroupname, MAX(FCATEGORYIDNAME) fcategoryidname, MAX(FMATERIALAUXID) fmaterialauxid, MAX(FMATERIALAUXNAME) fmaterialauxname, MAX(CAST(CONVERT(FLOAT, 0) AS INT)) fsalgroupid, MAX(FSALGROUPNAME) fsalgroupname FROM TMP36600877608011E780C91418776 WHERE (1 = 1 AND VGR.FEntryId IN (SELECT FEntryId FROM Vd9a626d54b4632146a1d0dab4daa8)) GROUP BY FSETTLEORGID, FCUSTOMERID, FMATERIALID, FSALERNAME, FMATERIALGROUP, FERPCLSID, FCATEGORYID, FLot) agt

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)

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.IDBService.Execute(Context ctx, String strSQL)
在 Kingdee.K3.SCM.App.Sal.Report.SaleOutStockSummaryRpt.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)

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

1.png(149.97KB)

您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!

请选择打赏金币数 *

10金币20金币30金币40金币50金币60金币
可用金币: 0