问题现象: | 客户从T3升级至U8V10.0,已经升级到U890版本,再往10.0升级的时候报错。客户有两个帐套,报同一个错误。 希望可以先进行远程的处理。 具体报错文件请查看附件。 [2011-7-7 15:17:28 补充] 数据已经上传 文件名 唐山分公司_问题号201107070064 升级过程:1、T3输出U6 2、在U6中进行升级 3、从U6中输出U8 4、导入U872升级,其中在升级到U872中报错 列名 'cItemName' 无效。 执行如下语句时出错: --============自定义项档案升级============================ Update Userdef_base set iDecimalDigits=6 where cType='数字' and iDecimalDigits is null 该问题通过删除userdef表的触发器后升级成功 5、导入U890进行升级,升级成功 之后从U890升级到U8V10.0后报该错误 [2011-7-7 18:04:52 补充] 您好 我已经更新了U8V10.0所有的补丁,安装补丁后升级仍出现此问题 我看到应收模块中的补丁是解决查询时报IYEAR 错误的 这个问题是在薪资模块升级中出现的 请再次给出解决方案 谢谢 |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【注意事项】修改前请务必做好数据备份; 升级报错后,执行如下脚本,再重新升级即可: ----添加年度字段 if COLUMNPROPERTY(OBJECT_ID('wa_state'),'iYear','PRECISION') IS NULL begin alter table wa_state add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('wa_dept'),'iYear','PRECISION') IS NULL begin alter table wa_dept add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('hr_wa_importitem'),'iYear','PRECISION') IS NULL begin alter table hr_wa_importitem add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('wa_fforder'),'iYear','PRECISION') IS NULL begin alter table wa_fforder add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('wa_gzdl'),'iYear','PRECISION') IS NULL begin alter table wa_gzdl add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('wa_outperiod'),'iYear','PRECISION') IS NULL begin alter table wa_outperiod add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_GZItem'),'iYear','PRECISION') IS NULL begin alter table WA_GZItem add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_Formula'),'iYear','PRECISION') IS NULL begin alter table WA_Formula add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_Bank_Set'),'iYear','PRECISION') IS NULL begin alter table WA_Bank_Set add [iYear] smallint end --if COLUMNPROPERTY(OBJECT_ID('WA_Auth'),'iYear','PRECISION') IS NULL --begin -- alter table WA_Auth add [iYear] smallint --end --if COLUMNPROPERTY(OBJECT_ID('WA_Authority'),'iYear','PRECISION') IS NULL --begin -- alter table WA_Authority add [iYear] smallint --end ----选项设置 --基数 if COLUMNPROPERTY(OBJECT_ID('WA_SDS_p'),'iYear','PRECISION') IS NULL begin alter table WA_SDS_p add [iYear] smallint end --代付税 if COLUMNPROPERTY(OBJECT_ID('WA_SDS_SLNew'),'iYear','PRECISION') IS NULL begin alter table WA_SDS_SLNew add [iYear] smallint end --代扣税 if COLUMNPROPERTY(OBJECT_ID('WA_SDS_SL'),'iYear','PRECISION') IS NULL begin alter table WA_SDS_SL add [iYear] smallint end --汇率 if COLUMNPROPERTY(OBJECT_ID('WA_currency'),'iYear','PRECISION') IS NULL begin alter table WA_currency add [iYear] smallint end ----工资分摊详细设置 if COLUMNPROPERTY(OBJECT_ID('WA_GZsumComCfg'),'iYear','PRECISION') IS NULL begin alter table WA_GZsumComCfg add [iYear] smallint end ----工资分摊名称 if COLUMNPROPERTY(OBJECT_ID('WA_FTName'),'iYear','PRECISION') IS NULL begin alter table WA_FTName add [iYear] smallint end ---个人所得税表 if COLUMNPROPERTY(OBJECT_ID('WA_SDS_Ex'),'iYear','PRECISION') IS NULL begin alter table WA_SDS_Ex add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('wa_psn'),'iyear','PRECISION') IS NULL begin alter table wa_psn add [iYear] smallint end ----报表需要添加年度字段 if COLUMNPROPERTY(OBJECT_ID('WA_GZBName'),'iYear','PRECISION') IS NULL begin alter table WA_GZBName add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_GZBItemDept'),'iYear','PRECISION') IS NULL begin alter table WA_GZBItemDept add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_GZBItemGrd'),'iYear','PRECISION') IS NULL begin alter table WA_GZBItemGrd add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_GZBItemTitle'),'iYear','PRECISION') IS NULL begin alter table WA_GZBItemTitle add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_GZSectionItem'),'iYear','PRECISION') IS NULL begin alter table WA_GZSectionItem add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_Sectionformula'),'iYear','PRECISION') IS NULL begin alter table WA_Sectionformula add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_TaxArea'),'iYear','PRECISION') IS NULL begin alter table WA_TaxArea add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('wa_taxbb'),'iYear','PRECISION') IS NULL begin alter table wa_taxbb add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('wa_taxformat'),'iYear','PRECISION') IS NULL begin alter table wa_taxformat alter column cDataSource nvarchar(3500) alter table wa_taxformat add [iYear] smallint end if COLUMNPROPERTY(OBJECT_ID('WA_TaxMailSet'),'iYear','PRECISION') IS NULL begin alter table WA_TaxMailSet add [iYear] smallint end ----结束报表需要添加年度字段 IF not EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[dbo].[WA_GZItemStop]')) begin CREATE TABLE [dbo].[WA_GZItemStop]( [iGZItem_id] [int] NOT NULL, [iYear] [int] NOT NULL, [iMonth] [int] NOT NULL) ALTER TABLE [dbo].[WA_GZItemStop] ADD CONSTRAINT [WA_GZItemStop_PK] PRIMARY KEY NONCLUSTERED ( [iGZItem_id], [iYear], [iMonth] ) ON [PRIMARY] end update WA_Bank_Set set iyear=2011 |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 数据库 |
产品: | 系统工具及环境 |
问题名称: | 从T3升级到U8V10.0报错 |
最后更新: | 2011-07-11 13:37:14 |