问题现象: | u8.61升级到u810.0出错数据已经上传125.35.5.138公司名称是青岛博辰智和科技有限公司 |
问题原因: | |
解决方案: | 您好,执行如下语句后再作升级(数据库名请改为实际数据库名,单引号改为英文状态单引号): use ufdata_006_1999 go alter table fa_cards drop constraint FK__fa_Cards__sDeprS__09003183 go use ufdata_006_2000 go alter table fa_cards drop constraint FK__fa_Cards__sDeprS__09003183 go use ufdata_006_2001 go alter table fa_cards drop constraint FK__fa_Cards__sDeprS__09003183 go use ufdata_006_2002 go alter table fa_cards drop constraint FK__fa_Cards__sDeprS__09003183 go use ufdata_006_2007 go update AA_COLUMNDIC_BASE set LOCALEID=N'en-us' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbustype' update AA_COLUMNDIC_BASE set LOCALEID=N'zh-TW' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbillcode' go use ufdata_006_2008 go update AA_COLUMNDIC_BASE set LOCALEID=N'en-us' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbustype' update AA_COLUMNDIC_BASE set LOCALEID=N'zh-TW' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbillcode' go use ufdata_006_2009 go update AA_COLUMNDIC_BASE set LOCALEID=N'en-us' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbustype' update AA_COLUMNDIC_BASE set LOCALEID=N'zh-TW' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbillcode' go use ufdata_006_2010 go update AA_COLUMNDIC_BASE set LOCALEID=N'en-us' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbustype' update AA_COLUMNDIC_BASE set LOCALEID=N'zh-TW' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbillcode' go use ufdata_006_2011 go update AA_COLUMNDIC_BASE set LOCALEID=N'en-us' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbustype' update AA_COLUMNDIC_BASE set LOCALEID=N'zh-TW' WHERE CKEY =N'99' AND LOCALEID=N'zh-cn' and cfld='cbillcode' go 若有问题,请及时反馈! U8/CRM/PLM |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 总账 |
产品: | 财务会计 |
问题名称: | 数据升级 |
最后更新: | 2011-09-15 23:24:37 |