核算维度余额表联查核算维度明细账问题
994次浏览
编辑于2015年07月29日 15:46:47
K3 Cloud 5.0 在更新了7月9日补丁以后核算余额表联查核算维度明细账出现中段提示:
查询出现异常。MERGE 语句试图多次更新或删除同一行。目标行与多个源行匹配时会出现这种情况。MERGE 语句无法多次更新/删除目标表的同一行。请简化 ON 子句,以确保目标行最多与一个源行匹配,也可以使用 GROUP BY 子句对源行分组
MERGE INTO TMP56BFE32A35C511E5BF0FB82A72D B
USING #TM_GL_VOUCHERPOSTBALANCEQTY E
ON (B.FACCOUNTBOOKID = E.FACCOUNTBOOKID AND B.FYEAR = E.FYEAR AND B.FPERIOD = E.FPERIOD
AND B.FADJUSTPERIOD = E.FADJUSTPERIOD AND B.FACCOUNTID = E.FACCOUNTID AND B.FDETAILID = E.FDETAILID AND B.FCURRENCYID = E.FCURRENCYID)
WHEN MATCHED THEN
UPDATE
SET B.FBEGINQTY= B.FBEGINQTY + E.FBEGINQTY,
B.FBEGINBASEUNITQTY= B.FBEGINBASEUNITQTY + E.FBEGINBASEUNITQTY,
B.FDEBITQTY= B.FDEBITQTY + E.FDEBITQTY,
B.FDEBITBASEUNITQTY= B.FDEBITBASEUNITQTY + E.FDEBITBASEUNITQTY,
B.FCREDITQTY= B.FCREDITQTY + E.FCREDITQTY,
B.FCREDITBASEUNITQTY= B.FCREDITBASEUNITQTY + E.FCREDITBASEUNITQTY,
B.FYTDDEBITQTY = B.FYTDDEBITQTY + E.FYTDDEBITQTY,
B.FYTDDEBITBASEUNITQTY = B.FYTDDEBITBASEUNITQTY + E.FYTDDEBITBASEUNITQTY,
B.FENDQTY= B.FENDQTY + E.FENDQTY,
B.FENDBASEUNITQTY= B.FENDBASEUNITQTY + E.FENDBASEUNITQTY,
B.FYTDCREDITQTY= B.FYTDCREDITQTY + E.FYTDCREDITQTY,
B.FYTDCREDITBASEUNITQTY=B.FYTDCREDITBASEUNITQTY + E.FYTDCREDITBASEUNITQTY;
Server stack trace:
at Kingdee.K3.FIN.GL.App.Core.AbstractVoucherPost.PostVoucher(Context ctx, VoucherPostParameters postParam)
at Kingdee.K3.FIN.GL.App.Core.AbstractVoucherPost.Post(Context ctx, VoucherPostParameters postParam)
at Kingdee.K3.FIN.GL.App.Core.VirtualVoucherPost.VirtualPostVoucherContainQty(Context ctx, VoucherPostParameters postParam)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.SetFilterValueFromAccountingItemsBalance(Dictionary`2 dic)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.SetFilterValueFromOtherReport(Dictionary`2 dic)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.Paging(IRptParams filter)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.CurrentDataRow(IRptParams filter, String tableName)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.BuilderSql(IRptParams filter, String tableName)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass36.b__32()
查询出现异常。MERGE 语句试图多次更新或删除同一行。目标行与多个源行匹配时会出现这种情况。MERGE 语句无法多次更新/删除目标表的同一行。请简化 ON 子句,以确保目标行最多与一个源行匹配,也可以使用 GROUP BY 子句对源行分组
MERGE INTO TMP56BFE32A35C511E5BF0FB82A72D B
USING #TM_GL_VOUCHERPOSTBALANCEQTY E
ON (B.FACCOUNTBOOKID = E.FACCOUNTBOOKID AND B.FYEAR = E.FYEAR AND B.FPERIOD = E.FPERIOD
AND B.FADJUSTPERIOD = E.FADJUSTPERIOD AND B.FACCOUNTID = E.FACCOUNTID AND B.FDETAILID = E.FDETAILID AND B.FCURRENCYID = E.FCURRENCYID)
WHEN MATCHED THEN
UPDATE
SET B.FBEGINQTY= B.FBEGINQTY + E.FBEGINQTY,
B.FBEGINBASEUNITQTY= B.FBEGINBASEUNITQTY + E.FBEGINBASEUNITQTY,
B.FDEBITQTY= B.FDEBITQTY + E.FDEBITQTY,
B.FDEBITBASEUNITQTY= B.FDEBITBASEUNITQTY + E.FDEBITBASEUNITQTY,
B.FCREDITQTY= B.FCREDITQTY + E.FCREDITQTY,
B.FCREDITBASEUNITQTY= B.FCREDITBASEUNITQTY + E.FCREDITBASEUNITQTY,
B.FYTDDEBITQTY = B.FYTDDEBITQTY + E.FYTDDEBITQTY,
B.FYTDDEBITBASEUNITQTY = B.FYTDDEBITBASEUNITQTY + E.FYTDDEBITBASEUNITQTY,
B.FENDQTY= B.FENDQTY + E.FENDQTY,
B.FENDBASEUNITQTY= B.FENDBASEUNITQTY + E.FENDBASEUNITQTY,
B.FYTDCREDITQTY= B.FYTDCREDITQTY + E.FYTDCREDITQTY,
B.FYTDCREDITBASEUNITQTY=B.FYTDCREDITBASEUNITQTY + E.FYTDCREDITBASEUNITQTY;
Server stack trace:
at Kingdee.K3.FIN.GL.App.Core.AbstractVoucherPost.PostVoucher(Context ctx, VoucherPostParameters postParam)
at Kingdee.K3.FIN.GL.App.Core.AbstractVoucherPost.Post(Context ctx, VoucherPostParameters postParam)
at Kingdee.K3.FIN.GL.App.Core.VirtualVoucherPost.VirtualPostVoucherContainQty(Context ctx, VoucherPostParameters postParam)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.SetFilterValueFromAccountingItemsBalance(Dictionary`2 dic)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.SetFilterValueFromOtherReport(Dictionary`2 dic)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.Paging(IRptParams filter)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.CurrentDataRow(IRptParams filter, String tableName)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.BuilderSql(IRptParams filter, String tableName)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass36.
推荐阅读