t+升级报错：脚本: 11.600.000.0000 DATA_DATA_RAP_L 出错：因为发现对象名称 'dbo.EAP_VoucherDraft' 和索引名称 'pk_EAP_VoucherDraft' 有重复的键

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

解决方案：根据重复的键值，查询到重复的记录，然后删除重复记录，（操作前请备份好您用友T+财务软件中的数据），示例语句如下：

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

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

     begi

     delete from EAP_VoucherDraft

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

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

     ed

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

     begi

     delete from EAP_VoucherDraft

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

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

     Ed

     执行这个：

     delete from EAP_VoucherDraft

     where ID i (select ID from EAP_VoucherDraft group by ID havig cout(ID) > 1)