专业版10.0升级到11.0报错,提示数据库升级失败

服务器系统:server 2003 数据库:sql 2000 sp4
软件版本:专业版10.0
使用模块:总账、报表、仓存、核算
软件升级到11.0具体提示如下:
数据库升级失败!SQL文件不全或SQL语句有误!
错误描述:插入错误: 列名或所提供值的数目与表定义不匹配。
Sql文件名:C:\WINDOWS\system32\KIScom\SqlSrv\SP_KISV10_PT.sql
Sql内容:--RICKEY--20090617--Begin
--生产任务单变更
if not exists(select C.name from syscolumns C inner join sysobjects T on
c.id=t.id where t.name='ICMO' and c.name='FAlterID')
Begin
Alter Table ICMO Add FAlterID [int] NULL --变更人
Alter Table ICMO Add FAlterDate [datetime] NULL--变更日期
Update ICTransactionType
Set FFormHeight=FFormHeight+435
Where FID=85
Declare @InterID int
Select @InterID=FCtlIndex From ICTemplate Where FID='J01' And
FFieldName='FCheckDate'
Update ICTemplate Set FCtlIndex=FCtlIndex+1
Where FID='J01' And FCtlIndex>@InterID
Insert Into ICTemplate Values ('J01',@InterID+1,31,'变更人:',8,-
1,0,1,1,'FAlterID',160,6850,2800,330,0,1,'宋
体',9,0,0,'','','',0,3,1,31,'Kdtext',0,0,'','',0,0,1,1,1,'','','','',1)
Insert Into ICTemplate Values ('J01',@InterID+2,32,'变更日期:',17,-
1,1,2,0,'FAlterDate',3840,6850,2800,330,0,1,'宋
体',9,0,0,'','','',0,3,1,31,'Kdtext',0,0,'','',0,0,1,1,1,'','','','',1)
Select @InterID=FinterID From ICChatBillTitle Where FTypeID=90 And
FColName='FCheckDate'
Update ICChatBillTitle Set FInterID=FInterID+1
Where FTypeID=90 And FInterID>@InterID
Insert Into ICChatBillTitle Values(@InterID+1,90,'变更人$','
','FAlterIDName','t_User',1,1000,1,-5,1,0,1,0,'FName','t115',' ',0,0,'
',1,1,1,'','',0,0,5,'',0,0,'',0,1,null)
Insert Into ICChatBillTitle Values(@InterID+2,90,'变更日期$','
','FAlterDate','ICMO',0,1000,1,-1,1,0,0,0,'FAlterDate','v1',' ',0,0,'
',1,1,0,'','',0,0,5
专业版10.0升级到11.0报错,提示数据库升级失败
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



