用友850数据库升级至U852时，出现提示升级失败: 问题描述："错误信息: -2147217873 不能在具有唯一索引 ''''citem_name'''' 的对象 ''''fitem'''' 中插入重复键的行。 执行如下语句时出错: if not exists (select * from fitem where citem_class=''''97'''') Begin delete from fitemstructure where citem_class =''''97'''' Insert fitem(citem_class,citem_name,citem_text,crule,ctable,cclasstable) Values(''''97'''',''''项目管理'''',''''项目名称'''',''''1'''',''''fitemss97'''',''''fitemss97class'''') Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''1'''',''''I_id'''',''''自动编号'''',0,1,4,0,0,0,0,0,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''2'''',''''citemcode'''',''''项目编号'''',1,3,20,0,1,0,1,0,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''3'''',''''citemname'''',''''项目名称'''',2,3,60,0,1,0,1,0,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''4'''',''''bclose'''',''''是否结算'''',3,5,1,0,0,0,1,0,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''5'''',''''citemccode'''',''''所属分类码'''',4,3,22,0,0,0,0,0,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''6'''',''''iotherused'''',''''其他系统是否使用'''',5,1,4,0,0,0,0,0,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''7'''',''''dEndDate'''',''''完工日期'''',6,4,10,0,0,0,0,0,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''1'''',''''citemcode'''',''''项目编号'''',6,3,20,0,0,0,0,1,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''2'''',''''citemname'''',''''项目名称'''',6,3,60,0,0,0,0,1,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''3'''',''''iclose'''',''''是否结算'''',6,1,2,0,0,0,0,1,NULL,0) Insert fitemstructure(citem_class,citem_sqr,cfield_name,ctext,imode,itype,ilength,iscale,blist,bsum,bref,isubitem,idefine,bprimarykey) values(''''97'''',''''4'''',''''dEndDate'''',''''完工日期'''',6,4,10,0,0,0,1,1,NULL,0) End " 问题原因：fitem项目档案有冗余项目档案 解决方案：游客无权查看 相关补丁：模块：总账产品：85x问题名称：用友850数据库升级至U852时，出现提示升级失败: 更新时间：2005-06-28 00:00:00 有用 没用84 浏览 分类 U8知识库用友U8知识库(旧)畅捷通知识库用友NC知识库用友U9知识库用友政务知识库致远OA知识库U8Cloud知识库