T+升级报错对象名称'dbo.GLReferenceDocClass'和索引名称'ixcode'有重复的键

问题现象：用友畅捷通T+财务软件升级报错，具体提示如下：因为发现对象名称 'dbo.GL_RefereceDocClass' 和索引名称 'ix_code' 有重复的键，重复数据问题SQL 脚本: 11.510.000.0000 DATA_DSTR_FI_Vou_L.sql 出错：因为发现对象名称 'dbo.GL_RefereceDocClass' 和索引名称 'ix_code' 有重复的键，所以 CREATE UIQUE IDEX 语句终止。重复的键值为 (01)。语句已终止。

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

     if((select COUT(code) from GL_RefereceDocClass where code ='01')>1)

     begi

     delete from GL_RefereceDocClass where code ='01' ad ts i

     (select top 1 ts from GL_RefereceDocClass where code ='01')

     ed

     if((select COUT(code) from GL_RefereceDocClass where code ='02')>1)

     begi

     delete from GL_RefereceDocClass where code ='02' ad ts i

     (select top 1 ts from GL_RefereceDocClass where code ='02')

     ed

     if((select COUT(code) from GL_RefereceDocClass where code ='03')>1)

     begi

     delete from GL_RefereceDocClass where code ='03' ad ts i

     (select top 1 ts from GL_RefereceDocClass where code ='03')

     ed

     if((select COUT(code) from GL_RefereceDocClass where code ='04')>1)

     begi

     delete from GL_RefereceDocClass where code ='04' ad ts i

     (select top 1 ts from GL_RefereceDocClass where code ='04')

     ed

     if((select COUT(code) from GL_RefereceDocClass where code ='05')>1)

     begi

     delete from GL_RefereceDocClass where code ='05' ad ts i

     (select top 1 ts from GL_RefereceDocClass where code ='05')

     ed

     if((select COUT(code) from GL_RefereceDocClass where code ='06')>1)

     begi

     delete from GL_RefereceDocClass where code ='06' ad ts i

     (select top 1 ts from GL_RefereceDocClass where code ='06')

     ed

     if((select COUT(code) from GL_RefereceDocClass where code ='07')>1)

     begi

     delete from GL_RefereceDocClass where code ='07' ad ts i

     (select top 1 ts from GL_RefereceDocClass where code ='07')

     ed

     if((select COUT(code) from GL_RefereceDocClass where code ='08')>1)

     begi

     delete from GL_RefereceDocClass where code ='08' ad ts i

     (select top 1 ts from GL_RefereceDocClass where code ='08')

     ed