问题现象: | T6升级到U8总是提示错误。已经通过T6转U8工具转换过帐套,还是报错。 |
问题原因: | |
解决方案: | 您好, 此问题【经测试】现做如下分析与答复: 【问题原因】 一、帐套1(在引入到U872升级过程中的报错):问题1、view dbo.recordinq 出现了手工加的列caccountpid,caccountpdate; 方案1、alter view dbo.recordinq as select dbo.rdrecord.id, dbo.rdrecord.brdflag, dbo.rdrecord.cvouchtype, dbo.rdrecord.cwhcode, dbo.rdrecord.ddate, dbo.rdrecord.ccode, dbo.rdrecord.crdcode, dbo.rdrecord.cdepcode, dbo.rdrecord.cpersoncode, dbo.rdrecord.cprobatch, dbo.rdrecord.chandler, dbo.rdrecord.cmemo, dbo.rdrecord.caccounter, dbo.rdrecord.cmaker, dbo.rdrecord.cdefine1, dbo.rdrecord.cdefine2, dbo.rdrecord.cdefine3, dbo.rdrecord.cdefine4, dbo.rdrecord.cdefine5, dbo.rdrecord.cdefine6, dbo.rdrecord.cdefine7, dbo.rdrecord.cdefine8, dbo.rdrecord.cdefine9, dbo.rdrecord.cdefine10, dbo.warehouse.cwhname, dbo.department.cdepname, dbo.person.cpersonname, dbo.rd_style.crdname, dbo.rdrecord.csource, dbo.rdrecord.cbustype, dbo.rdrecord.dveridate, dbo.rdrecord.cbuscode, dbo.rdrecord.cptcode, dbo.rdrecord.cstcode, dbo.rdrecord.ccuscode, dbo.rdrecord.cvencode, dbo.rdrecord.cordercode, dbo.rdrecord.carvcode, dbo.rdrecord.cbillcode, dbo.rdrecord.cdlcode, dbo.rdrecord.darvdate, dbo.rdrecord.cchkcode, dbo.rdrecord.dchkdate, dbo.rdrecord.cchkperson, dbo.rdrecord.vt_id, dbo.rdrecord.bisstqc, dbo.rdrecord.cdefine11, dbo.rdrecord.cdefine12, dbo.rdrecord.cdefine13, dbo.rdrecord.cdefine14, dbo.rdrecord.cdefine15, dbo.rdrecord.cdefine16, dbo.rdrecord.imquantity, dbo.rdrecord.cpspcode, dbo.rdrecord.cmpocode, dbo.rdrecord.bpufirst,dbo.rdrecord.biafirst, dbo.rdrecord.ipurorderid, dbo.rdrecord.ipurarriveid, dbo.rdrecord.iproorderid, dbo.rdrecord.iarriveid, dbo.rdrecord.isalebillid, convert(char,convert(money,dbo.rdrecord.ufts),2) as ufts --,dbo.rdrecord.caccountpid, --dbo.rdrecord.caccountpdate from dbo.rdrecord left outer join dbo.department on dbo.rdrecord.cdepcode = dbo.department.cdepcode left outer join dbo.gl_bdigest on dbo.rdrecord.cmemo = dbo.gl_bdigest.cid left outer join dbo.person on dbo.rdrecord.chandler = dbo.person.cpersoncode left outer join dbo.person person1 on dbo.rdrecord.cpersoncode = person1.cpersoncode left outer join dbo.rd_style on dbo.rdrecord.crdcode = dbo.rd_style.crdcode left outer join dbo.warehouse on dbo.rdrecord.cwhcode = dbo.warehouse.cwhcode where (dbo.rdrecord.cvouchtype = '10') 问题2、查询执行的帐套数据库可以发现RDRECORDS 多了csocode,表结构不应该有这个列; 方案2、ALTER TABLE RDRECORDS DROP COLUMN csocode 问题3、注释掉下面C:U8SOFTAdminSQLFILE8710MainUfdataStructureData_STR_QM_mix_NL.sql --去掉建在rdrecord的上的外键 --ALTER TABLE dbo.GSP_VOUCHUNSALABLE --DROP CONSTRAINT FK_GSP_VOUCHUNSALABLE_RdRecord 二、帐套2升级 先通过T6升级工具导入再输出U8普及版,再引入到U852再升级到U852,最后引入到U872再升级到U872 解决方案: 通过ftp://125.35.5.138/(外网) 下载U852的帐套数据 引入到U872 继续升级 已放到FTP下载数据目录,下载账号u8xiazai 密码 u8xiazai*2009 注意要点击IE浏览器工具栏的页面选择在windows 资源管理器中打开FTP |
相关补丁: | |
版本: | 8.90 |
模块: | 总账 |
产品: | 财务会计 |
问题名称: | T6升级U8问题 |
最后更新: | 2011-07-14 23:20:13 |