物料盘点作业审核时报错提示dbo.T_DIN_StockCountDate中插入重复键

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-23浏览：2

问题描述：

解决方案：

cloud中执行脚本

----盘点时间表修改主键

IF NOT EXISTS (SELECT 1 FROM SYSCONSTRAINTS CONST INNER JOIN SYSOBJECTS CONST_OBJ ON CONST.CONSTID = CONST_OBJ.ID WHERE CONST_OBJ.NAME = 'PK_StockCountDate_N') BEGIN DELETE FROM T_DIN_StockCountDate; ALTER TABLE T_DIN_StockCountDate DROP CONSTRAINT PK_StockCountDate; ALTER TABLE T_DIN_StockCountDate ALTER COLUMN FStockCountDate DATETIME NOT NULL; ALTER TABLE T_DIN_StockCountDate ADD CONSTRAINT PK_StockCountDate_N PRIMARY KEY CLUSTERED(FStockOrgID,FStockCountDate,FID); END GO