问题现象: | T3财务数据要升到U8100,通过升级工具升到U861正常,U861再升到U8100出现如下错误,请帮我分析一下是什么原因? 数据库名: UFDATA_001_2009 E:U8SOFTAdminSQLFILE8700MainUfdatadataNLDATA_UPDA_SA_MIX_NL.sql 错误信息:-2147217873违反了 PRIMARY KEY 约束 'PK_AA_ColumnDic_base'。不能在对象 'AA_ColumnDic_base' 中插入重复键。 执行如下语句时出错:--退货单 --单据字段权限 delete from aa_busobject_base where cBusObId=N'VCH_03' and langid=N'zh-CN' insert into aa_busobject_base (cBusObId, cBusObName, iAuthType, bAuthControl, cSub_Id, cMark, langid,iorder,ifunctype)Values('VCH_03',N'销售退货单',1,0,N'SA',N'销售退货单',N'zh-CN',1,2) delete from aa_columndic_base where ckey='VCH_03' and LocaleID=N'zh-cn' insert into aa_columndic_base (cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge) select 'VCH_03',cardsection+';'+fieldname,N'',carditemnum,carditemname,N'',0,showit,800,4,N'',0,0,1,0,N'zh-cn',null,null,null,null,null from voucheritems where cardnum=N'03' and LocaleID=N'zh-CN' and vt_id=(select def_id from vouchers where cardnumber=N'03') |
问题原因: | |
解决方案: | 请检查AA_ColumnDic_base表中数据是否有重复记录。删除重复记录后再升级 |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 总账 |
产品: | 财务会计 |
问题名称: | T3升级到U8100出错 |
最后更新: | 2012-02-11 23:17:35 |