用友软件免费下载(www.yyxxoo.com)旨在提供全系列最新最全的用友财务软件免费下载地址。QQ群:217170732,密:ufsoft

网站首页 用友解决方案 正文

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

admin 2017-04-23 用友解决方案 835 ℃ 0 评论

问题现象:用友畅捷通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.ufidawhy.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)

Tags:T+升级报错T+升级错误

本文暂时没有评论,来添加一个吧(●'◡'●)

欢迎 发表评论:

标签列表
最近发表