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

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

畅捷通T+升级报错:对象名称 'dbo.GL_ReferenceDocClass' 和索引名称 'ix_code' 有重复的键

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

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

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

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

欢迎 发表评论:

标签列表
最近发表