问题现象: | 客户是T3的数据,已经输出U8,现在升级到U810.1的时候出错。列名 'iyear' 无效。 执行如下语句时出错: CREATE PROCEDURE [dbo].[WA_iniTaxBBFormat] ( @cgzgradenum varchar(3), @iyear int ) AS BEGIN 详细的报错提示放在附件中,有几个账套都出现这样的报错情况,尝试增加账套005的列信息,在升级。又报另外的问题:列名 'dEmployDate' 无效。 执行如下语句时出错: ----招聘进度分析 create proc [dbo].[HR_ZPFX] @date as nvarchar(20) ,@deptCode as nvarchar(60) ='' as declare @year int declare @month int set @year=year(@date) DECLARE @MyTable table( yf int NOT NULL, --月份 jhrs int , --计划招聘人数 yprs int, ---应聘人数 lyrs int, --录用人数 lyl numeric(10,2),----录用率 wcl numeric(10,2) ); ----1月 set @month=1 WHILE @month<=12 begin insert into @MyTable(yf,jhrs,yprs,lyrs,lyl,wcl) select yf,jhrs,yprs,lyrs,case yprs when 0 then 0 else lyrs * 100.0/yprs end as lyl, case jhrs when 0 then 0 else lyrs * 100.0/jhrs end as wcl from (select @month as yf, (select count(*) from hr_rt_planreq where cReqDepCode like @deptCode+'%' and year(dArriveDate)=@year and month(dArriveDate)=1) as jhrs ,(select count(*) from hr_rt_register where cDeptCode like @deptCode+'%' and year(dMakeDate)=@year and month(dMakeDate)=1) as yprs ,(select count(*) from hr_rt_register where cDeptCode like @deptCode+'%' and year(dEmployDate)=@year and month(dEmployDate)=1) as lyrs ) as b set @month=@month+1 end select * from @MyTable 请帮忙看看,谢谢! 分公司赵秀娟18903816450 [2012-1-13 10:54:56 补充] 上传的数据名称:“蒙妮坦升级账套备份”FTP://192.168.8.180 |
问题原因: | |
解决方案: | 您好,升级方案如下: 005账套:1.删除“UserDef”表上的触发器“UpRpt_FltdefNote” 2.data库执行: delete from WA_Bank_Set delete from WA_Bank 006账套:1.data库执行:update gl_msysname set sysseq=sysseq+10 where sysseq>=13 2.删除“UserDef”表上的触发器“UpRpt_FltdefNote” 3.data库执行: delete from WA_Bank_Set delete from WA_Bank 206账套:1.删除“UserDef”表上的触发器“UpRpt_FltdefNote” 若有问题,请及时反馈,谢谢! U8/CRM/PLM |
相关补丁: | |
版本: | U8 V10.1 |
模块: | 系统管理 |
产品: | 公共平台 |
问题名称: | 升级出错列名 'iyear' 无效 |
最后更新: | 2012-01-23 23:56:25 |