发现对象名称 'dbo.EAP_VoucherDraft' 和索引名称 'pk_EAP_VoucherDraft' 有重复的键

问题现象：用友畅捷通T+财务软件升级报错，具体提示如下：脚本: 11.600.000.0000 DATA_DATA_RAP_NL 出错：因为发现对象名称 'dbo.EAP_VoucherDraft' 和索引名称 'pk_EAP_VoucherDraft' 有重复的键，所以 CREATE UNIQUE INDEX 语句终止。重复的键值为 (21fdb25a-952b-f9a0-6169-e271dd0edb16)。

无法创建约束。

解决方案：根据重复的键值，查询到重复的记录，然后删除重复记录，（操作前请备份好您用友T+财务软件中的数据，可参考教程：http://www.iyyrj.com/jcufida/1389.html），示例语句如下：

delete from EAP_VoucherDraft where ID='21fdb25a-952b-f9a0-6169-e271dd0edb16' and Code='2014-10-15-0002'

if((select COUNT(ts) from EAP_VoucherDraft where ID='27f8bc75-a7e1-d6f9-e867-e27b87c5e7a4')>1)

begin

delete from EAP_VoucherDraft

where ID='27f8bc75-a7e1-d6f9-e867-e27b87c5e7a4'

and ts in (select top 1 ts from EAP_VoucherDraft where ID='27f8bc75-a7e1-d6f9-e867-e27b87c5e7a4')

end

if((select COUNT(ts) from EAP_VoucherDraft where ID='186EB51E-5B8A-CA28-8546-F9B9527A9ED7')>1)

begin

delete from EAP_VoucherDraft

where ID='186EB51E-5B8A-CA28-8546-F9B9527A9ED7'

and ts in (select top 1 ts from EAP_VoucherDraft where ID='186EB51E-5B8A-CA28-8546-F9B9527A9ED7')

End

执行这个：

delete from EAP_VoucherDraft

where ID in (select ID from EAP_VoucherDraft group by ID having count(ID) > 1)

转载声明：本站发布文章及版权归原作者所有，转载本站文章请注明文章来源！

本文链接：https://www.yongyou8.com/xue/851.html