锁库报错,提示插入重复键
金蝶云社区-FBJ_bing
FBJ_bing
0人赞赏了该文章 1,572次浏览 未经作者许可,禁止转载编辑于2016年04月07日 15:50:13

即时库存明细锁库报错,提示插入重复键
已做过即时库存校对,还是一样
请问该怎么解决?
6.0
3月18号补丁
谢谢


[{"operation":"STK_InventoryLock.MBIClick.tbSave"}]
发生时间: 2016-04-07 03:47:00
错误编号: BOS_ExecuteNonQuery
错误信息: 违反了 PRIMARY KEY 约束 'PK_STK_LOCKSTOCKLOG'。不能在对象 'dbo.T_STK_LOCKSTOCKLOG' 中插入重复键。
语句已终止。
Sql语句: INSERT INTO T_STK_LOCKSTOCKLOG (FID, FLOCKTYPE, FOPERATETYPE, FOPERATORID, FOPERATEDATE, FSTOCKORGID, FOBJECTID, FBILLTYPEID, FBIZBILLNO, FBILLID, FBILLSEQ, FENTIRYKEY, FBILLDETAILID, FMATERIALID, FBOMID, FMTONO, FPROJECTNO, FAUXPROPID, FLOT, FPRODUCEDATE, FEXPIRYDATE, FSTOCKID, FSTOCKLOCID, FOWNERTYPEID, FOWNERID, FKEEPERTYPEID, FKEEPERID, FSTOCKSTATUSID, FUNITID, FQTY, FBASEUNITID, FBASEQTY, FSECUNITID, FSECQTY, FLOCKSTOCKID, FBILLNO, FRESERVEDATE, FRESERVEDAYS, FRELEASEDATE, FRESERVELINKENTRYID, FREQUESTNOTE, FSUPPLYNOTE) SELECT FID, @LockType, @OperateType, @OperatorId, @LockDate, FSTOCKORGID, FOBJECTID, FBILLTYPEID, FBILLNO, FBILLID, FBILLSEQ, FENTIRYKEY, FBILLDETAILID, FMATERIALID, FBOMID, FMTONO, FPROJECTNO, FAUXPROPID, FLOT, FPRODUCEDATE, FEXPIRYDATE, FSTOCKID, FSTOCKLOCID, FOWNERTYPEID, FOWNERID, FKEEPERTYPEID, FKEEPERID, FSTOCKSTATUSID, FUNITID, FLOCKQTY, FBASEUNITID, FBASELOCKQTY, FSECUNITID, FSECLOCKQTY, FLINKENTRYID, ' ', FRESERVEDATE, FRESERVEDAYS, FRELEASEDATE, FLINKENTRYID, FREQUESTNOTE, FSUPPLYNOTE FROM #TM_STK_LOCKSTK
===================================================
调用堆栈:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)
at Kingdee.K3.SCM.App.Core.StockLockService.WriteLockStockLog(Context ctx, String tmpDataTable, String lockType, String operateType)
at Kingdee.K3.SCM.App.Core.StockLockService.SaveLockInfo(Context ctx, List`1 lockArgs, String opType, Boolean ignoreOrdercheck)
at Kingdee.K3.SCM.ServiceHelper.StockServiceHelper.SaveLockInfo(Context ctx, List`1 lockArgs, String opType, Boolean ignoreOrdercheck)
at Kingdee.K3.SCM.Stock.Business.PlugIn.LockOperate.SaveLockInfo()
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireBarItemClick(BarItemClickEventArgs e)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.BarItemClick(String parentKey, String barItemKey, BarDataManager bar, Int32 bartype)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.MainBarItemClick(String barItemKey)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.MainBarItemClick(String itemKey, JSONArray postDatas)

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

请选择打赏金币数 *

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