发生时间： 2018-10-25 03:15:13
错误编号： BOS_ExecuteNonQuery
错误信息： MERGE 语句试图多次更新或删除同一行。目标行与多个源行匹配时会出现这种情况。MERGE 语句无法多次更新/删除目标表的同一行。请简化 ON 子句，以确保目标行最多与一个源行匹配，也可以使用 GROUP BY 子句对源行分组。
Sql语句： merge into T_BD_MATERIALSTOCK u1 using(SELECT UM.FMATERIALID, CASE WHEN T4.FUNITGROUPID = T6.FUNITGROUPID THEN CAST((BD1.FCONVERTNUMERATOR * BD2.FCONVERTDENOMINATOR) AS NUMERIC(23, 10)) ELSE ISNULL(CAST((CAST((CAST((BD1.FCONVERTNUMERATOR * T8.FCONVERTNUMERATOR) AS NUMERIC(23, 10)) * BD2.FCONVERTDENOMINATOR) AS NUMERIC(23, 10)) * T9.FCONVERTDENOMINATOR) AS NUMERIC(23, 10)), -1.0) END num, CASE WHEN T4.FUNITGROUPID = T6.FUNITGROUPID THEN CAST((BD1.FCONVERTDENOMINATOR * BD2.FCONVERTNUMERATOR) AS NUMERIC(23, 10)) ELSE ISNULL(CAST((CAST((CAST((BD1.FCONVERTDENOMINATOR * T8.FCONVERTDENOMINATOR) AS NUMERIC(23, 10)) * BD2.FCONVERTNUMERATOR) AS NUMERIC(23, 10)) * T9.FCONVERTNUMERATOR) AS NUMERIC(23, 10)), -1.0) END nom FROM (SELECT TB.FMATERIALID, TB.FBASEUNITID, TP.FSTOREUNITID FROM T_BD_MATERIALBASE TB INNER JOIN T_BD_MATERIAL TM ON TB.FMATERIALID = TM.FMATERIALID INNER JOIN T_BD_MATERIALSTOCK TP ON TB.FMATERIALID = TP.FMATERIALID INNER JOIN @FMTRLID_udt1 T ON T.FID = TM.FMASTERID) um LEFT OUTER JOIN T_BD_MATERIAL TM ON UM.FMATERIALID = TM.FMaterialId LEFT OUTER JOIN T_BD_MATERIALBASE TB ON UM.FMATERIALID = TB.FMaterialId LEFT OUTER JOIN T_BD_UNIT T2 ON UM.FSTOREUNITID = T2.FUNITID LEFT OUTER JOIN T_BD_UNIT T3 ON UM.FBASEUNITID = T3.FUNITID LEFT OUTER JOIN T_BD_UNITGROUP T4 ON T4.FUNITGROUPID = T2.FUNITGROUPID LEFT OUTER JOIN T_BD_UNIT T5 ON (T4.FUNITGROUPID = T5.FUNITGROUPID AND T5.FISBASEUNIT = '1') LEFT OUTER JOIN T_BD_UNITCONVERTRATE BD1 ON ((BD1.FCURRENTUNITID = UM.FSTOREUNITID AND BD1.FDESTUNITID = T5.FUNITID) AND BD1.FMASTERID = 0) LEFT OUTER JOIN T_BD_UNITGROUP T6 ON T6.FUNITGROUPID = T3.FUNITGROUPID LEFT OUTER JOIN T_BD_UNIT T7 ON (T6.FUNITGROUPID = T7.FUNITGROUPID AND T7.FISBASEUNIT = '1') LEFT OUTER JOIN T_BD_UNITCONVERTRATE BD2 ON ((UM.FBASEUNITID = BD2.FCURRENTUNITID AND T7.FUNITID = BD2.FDESTUNITID) AND BD2.FMASTERID = 0) LEFT OUTER JOIN T_BD_UNITCONVERTRATE T8 ON ((T5.FUNITID = T8.FCURRENTUNITID AND TB.FBASEUNITID = T8.FDESTUNITID) AND (T8.FMASTERID = TM.FMASTERID OR T8.FMASTERID = 0)) LEFT OUTER JOIN T_BD_UNITCONVERTRATE T9 ON ((T7.FUNITID = T9.FCURRENTUNITID AND TB.FBASEUNITID = T9.FDESTUNITID) AND (T9.FMASTERID = TM.FMASTERID OR T9.FMASTERID = 0))) u2 on (u1.FMATERIALID = u2.FMATERIALID) when matched then update set u1.FSTOREURNUM=u2.NUM,u1.FSTOREURNOM=u2.NOM;
===================================================
调用堆栈：

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.K3.BD.App.Core.MaterialService.UpdateUnitRatePrivate(Context ctx, List`1 tableItems)
   在 Kingdee.K3.BD.App.Common.ServicePlugIn.Material.Save.EndOperationTransaction(EndOperationTransactionArgs e)
   在 Kingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireEndOperationTransaction(EndOperationTransactionArgs e)
   在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs)
   在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs)
   在 Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete()
   在 Kingdee.BOS.App.Core.AbstractOprerationService.Excute(DynamicObject[] dataEntities)
   在 Kingdee.BOS.App.Core.SaveService.Save(Context ctx, BusinessInfo info, DynamicObject[] dataEntities, OperateOption option, String operationNumber)

Exception rethrown at [0]:
   在 Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.Save(Context ctx, BusinessInfo businessInfo, DynamicObject dataObject, OperateOption option, String operationNumber)
   在 Kingdee.BOS.Model.Bill.BillModel.Save(OperateOption option)
   在 Kingdee.BOS.Business.Bill.Operation.Save.ExecuteBillOperation(OperateOption option)
   在 Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult result)

产品问题物料修改信息报错报错

产品问题 物料修改信息报错报错

恭喜您！

产品问题
物料修改信息报错报错

产品问题物料修改信息报错报错