老师好!
我们这边升级了7.0后,产成品成本计算每月核算都出现如下异常提示,请帮忙分析是什么原因。
系统版本:7.0.352.16
最新补丁是:PT116278
[tr] [td=976]Message:MERGE 语句试图多次更新或删除同一行。目标行与多个源行匹配时会出现这种情况。MERGE 语句无法多次更新/删除目标表的同一行。请简化 ON 子句,以确保目标行最多与一个源行匹配,也可以使用 GROUP BY 子句对源行分组。;StackTrace: at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.K3.FIN.CB.App.Core.ProductingCountService.CreateAutoWipData(Context ctx, CommonBillRptCondition condition, Int64 pkId, String tempTable)
at Kingdee.K3.FIN.CB.App.Core.ProductingCountService.GetAutoWipData(Context ctx, CommonBillRptCondition condition)
at Kingdee.K3.FIN.CB.App.Core.CostCal.AcctgBillData.GetWipCountQty(Context ctx, CostCalParameters parameters)
at Kingdee.K3.FIN.CB.App.Core.CostCal.Cal.ProductCostAcctgService.BeforeCostAcctgOnlyCalOnce(Context ctx, CostCalParameters parameters)
at Kingdee.K3.FIN.App.Core.OutAcctg.AbstractAcctgService.BeforeExecution[T](Context ctx, T acctgParameters)
at Kingdee.K3.FIN.App.Core.OutAcctg.AcctgStencil.BeforeExecuteServiceForShedule[T,K](Context ctx, T acctgParameters, CostAcctgServiceObject`1 service)
at Kingdee.K3.FIN.App.Core.OutAcctg.AcctgStencil.ExecutionBatchServiceObject[T,K](Context ctx, T acctgParameters, Dictionary`2 services, CostCalType calType, List`1 checkAttrs, Boolean isLast)
at Kingdee.K3.FIN.App.Core.OutAcctg.AcctgStencil.LevelCaling(CostCalParameters acctgParameters, Context bosctx, Dictionary`2 calservice)
at Kingdee.K3.FIN.App.Core.OutAcctg.AcctgStencil.ExecutionCostCal(CostCalGlobalContext costCalGlobalContext, Context bosctx, Dictionary`2 calservice)
at Kingdee.K3.FIN.App.Core.OutAcctg.AcctgStencil.CostCal(ComputeContext ctx, CostCalGlobalContext costCalGlobalContext)
at Kingdee.K3.FIN.App.Core.OutAcctg.AcctgStencilService.CostAcctg(ComputeContext ctx, OutStockAcctgParameters acctgParameters)