可发量查询出错
金蝶云社区-云社区用户5e961234
云社区用户5e961234
0人赞赏了该文章 1,467次浏览 未经作者许可,禁止转载编辑于2015年08月04日 16:57:33
cloud5.0 7月30日补丁 销售模块查询可发量时出现如下提示:
[{"operation":"SAL_AvailableQuery_List.MBIClick.tbRefresh"}]
发生时间: 2015-08-04 04:54:35
错误编号: BOS_ExecuteNonQuery
错误信息: 违反了 PRIMARY KEY 约束“PK_SAL_AVAILABLEQTY”。不能在对象“dbo.T_SAL_AVAILABLEQTY”中插入重复键。重复键值为 (00734691-1d02-4773-95c9-482010206b21)。
语句已终止。
Sql语句: INSERT INTO T_SAL_AVAILABLEQTY (FID, FMATERIALID, FSTOCKID, FSTOCKLOCID, FSTOCKSTATUSID, FSTOCKORGID, FSTOCKUNITID, FQTY, FAVBQTY, FSECUNITID, FSECQTY, FSECAVBQTY, FBASEUNITID, FBASEQTY, FBASEAVBQTY, FBASEAWAITQTY) SELECT TBAV.FID, TBAV.FMATERIALID, TBAV.FSTOCKID, TBAV.FSTOCKLOCID, TBAV.FSTOCKSTATUSID, TBAV.FSTOCKORGID, TBAV.FSTOCKUNITID, TBAV.FQTY, TBAV.FAVBQTY, TBAV.FSECUNITID, TBAV.FSECQTY, TBAV.FSECAVBQTY, TBAV.FBASEUNITID, TBAV.FBASEQTY, TBAV.FBASEAVBQTY, ISNULL(TBAW.FBASEAWAITQTY, 0) FROM #TM_SAL_AVBQTYFORSUMMARY TBAV LEFT OUTER JOIN #TM_SAL_AWAITQTYFORSUMMARY TBAW ON ((((TBAV.FMATERIALID = TBAW.FMATERIALID AND TBAV.FSTOCKID = TBAW.FSTOCKID) AND TBAV.FSTOCKLOCID = TBAW.FSTOCKLOCID) AND (TBAV.FSTOCKSTATUSID = TBAW.FSTOCKSTATUSID OR TBAW.FSTOCKSTATUSID = 0)) AND TBAV.FSTOCKORGID = TBAW.FSTOCKORGID)
===================================================
调用堆栈:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 lstSqlObj, Int32 commandTimeout)
在 Kingdee.K3.SCM.App.Core.SaleService.GetAvailableQty(Context ctx, List`1 listColumnField, Boolean bOnlyCanSale)
在 Kingdee.K3.SCM.ServiceHelper.SaleServiceHelper.GetAvailableQty(Context ctx, List`1 listColumnField, Boolean bOnlyCanSale)
在 Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireAfterBindData(EventArgs e)
在 Kingdee.BOS.Web.List.ListView.ShowListFilter()
在 Kingdee.BOS.Web.List.ListView.LoadData()
在 Kingdee.BOS.Web.List.ListView.OnRefresh()
在 Kingdee.BOS.Web.DynamicForm.AbstractDynamicWebFormView.Refresh()
在 Kingdee.BOS.Business.Bill.Operation.Refresh.ExecuteOperation()
在 Kingdee.BOS.Core.DynamicForm.AbstractFormOperation.Execute(InvokeFormOperation4WfParam param, CallBackWfAfterOperation callbackwf)
在 Kingdee.BOS.Web.DynamicForm.OperationCaller.InvokeFormOperation(String operationNumber)
在 Kingdee.BOS.Business.DynamicForm.BusinessService.ExcuteOperation.DoAction(FormBusinessServiceArgs e)
在 Kingdee.BOS.Core.DynamicForm.FormBusinessServiceUtil.InvokeServices(IDynamicFormView view, Object source, IEnumerable`1 services, Int32 actionType, String activeEntity, DynamicObject activeRow, Int32 rowIndex)
在 Kingdee.BOS.Web.DynamicForm.BusinessServiceCaller.InvokeFormBusiness(IDynamicFormView view, Object source, List`1 formBusinessServices, Int32 actionType, String entityKey, Int32 row)
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.BarItemClick(String parentKey, String barItemKey, BarDataManager bar, Int32 bartype)
在 Kingdee.BOS.Web.List.ListView.MainBarItemClick(String barItemKey)
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.MainBarItemClick(String itemKey, JSONArray postDatas)