用友T+升级报错：对象名称 'dbo.GL_ReferenceDocClass' 和索引名称 'ix_code' 有重复的键
财务软件哪个好 免费财务软件下载 财务软件有哪些手机扫一扫
财务软件破解版免费软件用友
免费财务软件官网用友售后服务用友T+升级报错：对象名称 'dbo.GL_ReferenceDocClass' 和索引名称 'ix_code' 有重复的键

用友T+升级报错：对象名称 'dbo.GL_ReferenceDocClass' 和索引名称 'ix_code' 有重复的键

用友售后服务用友财务软件2017-05-11 21:45:061210A+A-

问题现象：用友畅捷通T+财务软件升级报错，具体提示如下：因为发现对象名称 'dbo.GL_ReferenceDocClass' 和索引名称 'ix_code' 有重复的键，

重复数据问题SQL 脚本: 11.510.000.0000 DATA_DSTR_FI_Vou_NL.sql 出错：因为发现对象名称 'dbo.GL_ReferenceDocClass' 和索引名称 'ix_code' 有重复的键，所以 CREATE UNIQUE INDEX 语句终止。重复的键值为 (01)。语句已终止。

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

if((select COUNT(code) from GL_ReferenceDocClass where code ='01')>1)

begin

delete from GL_ReferenceDocClass where code ='01' and ts in

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

end

if((select COUNT(code) from GL_ReferenceDocClass where code ='02')>1)

begin

delete from GL_ReferenceDocClass where code ='02' and ts in

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

end

if((select COUNT(code) from GL_ReferenceDocClass where code ='03')>1)

begin

delete from GL_ReferenceDocClass where code ='03' and ts in

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

end

if((select COUNT(code) from GL_ReferenceDocClass where code ='04')>1)

begin

delete from GL_ReferenceDocClass where code ='04' and ts in

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

end

if((select COUNT(code) from GL_ReferenceDocClass where code ='05')>1)

begin

delete from GL_ReferenceDocClass where code ='05' and ts in

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

end

if((select COUNT(code) from GL_ReferenceDocClass where code ='06')>1)

begin

delete from GL_ReferenceDocClass where code ='06' and ts in

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

end

if((select COUNT(code) from GL_ReferenceDocClass where code ='07')>1)

begin

delete from GL_ReferenceDocClass where code ='07' and ts in

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

end

if((select COUNT(code) from GL_ReferenceDocClass where code ='08')>1)

begin

delete from GL_ReferenceDocClass where code ='08' and ts in

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

end

  • 95%的用户还阅读了

点击这里复制本文地址 以上内容由用友财务软件免费试用版下载整理呈现，请务必在转载分享时注明本文地址！如对内容有疑问，请联系我们，谢谢！
T升级报错T升级错误

相关文章

qrcode

免费财务软件官网 © All Rights Reserved.  

copyright © 2011-2021 www.ufidaft.com 赣ICP备20006209号-5

答疑咨询 在线客服 免费试用
×
服务图片