生产入库单保存报错

发生时间: 2019-06-28 10:37:01
错误编号: BOS_ExecuteNonQuery
错误信息: 不能在具有唯一索引“IDX_STK_INVENTORY_CLUST”的对象“dbo.T_STK_INVENTORY”中插入重复键的行。重复键值为 (184482_1_142119BD_KeeperOrg1BD_OwnerOrg1_0_0_10000_0_0, <NULL>, , <NULL>, )。
语句已终止。
Sql语句: INSERT INTO T_STK_INVENTORY (FID, FSTOCKORGID, FKEEPERTYPEID, FKEEPERID, FOWNERTYPEID, FOWNERID, FSTOCKID, FSTOCKLOCID, FAUXPROPID, FSTOCKSTATUSID, FLOT, FBOMID, FMTONO, FPROJECTNO, FPRODUCEDATE, FEXPIRYDATE, FBASEUNITID, FSTOCKUNITID, FMATERIALID, FSECUNITID, FOBJECTTYPEID) SELECT IT.FINVENTORYID, IT.FSTOCKORGID, IT.FKEEPERTYPEID, IT.FKEEPERID, IT.FOWNERTYPEID, IT.FOWNERID, IT.FSTOCKID, IT.FSTOCKLOCID, IT.FAUXPROPID, IT.FSTOCKSTATUSID, IT.FLOT, IT.FBOMID, IT.FMTONO, IT.FPROJECTNO, IT.FPRODUCEDATE, IT.FEXPIRYDATE, IT.FBASEUNITID, IT.FSTOCKUNITID, IT.FMATERIALID, IT.FSECUNITID, ‘STK_Inventory’ FROM (SELECT MIN(FINVENTORYID) finventoryid, FSTOCKORGID, FKEEPERTYPEID, FKEEPERID, FOWNERTYPEID, FOWNERID, FSTOCKID, FSTOCKLOCID, FAUXPROPID, FSTOCKSTATUSID, FLOT, FBOMID,
请老师帮忙看一下,啥问题。谢谢

 

问题名称:生产入库单保存报错

点击链接查看答案:

https://club.kingdee.com/forum.php?mod=viewthread&tid=1497586

未经允许不得转载:友商问答 » 生产入库单保存报错

赞 (0)