专业版10.0升级到11.0报错,提示数据库升级失败
金蝶云社区-朵小米
朵小米
0人赞赏了该文章 697次浏览 未经作者许可,禁止转载编辑于2017年01月18日 22:38:41

服务器系统: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,'',0,0,'',0,1,null)
Insert Into ICTableRelation Values
(90,51,'ICMO','v1','FAlterID','t_User','t115','FUserID','*=',0,0,1,0,'','','
','=',0,0,'')

Select @InterID=Max(FID) From GLNoteCitation Where FTemplateID='J01'

Insert Into GLNoteCitation Values ('J01',@InterID+1,48,'FAlterID','
变更人$',0,0,6,0,'FAlterID','','',1,'','')
Insert Into GLNoteCitation Values
('J01',@InterID+2,48,'FAlterDate','变更日期
$',0,0,6,0,'FAlterDate','','',1,'','')
--权限

update t_ObjectAccessType set findex=findex+1 Where FObjectType=1022
And FObjectID=10 and FIndex>7
insert into t_ObjectAccessType
(FObjectType,fobjectid,findex,faccessmask,faccessuse,fname) values
(1022,10,8,1024,7340033,'变更')
/*
Update t_ObjectAccessType Set FAccessUse=7340033
Where FObjectType=1088 And FObjectID=2 And FIndex=11
update t_accesscontrol
set faccessmask=faccessmask-1024
where fobjecttype=1088 and fobjectid=2 and (faccessmask & 1024=1024)

Update ictemplateentry
Set FAction=replace(FAction,'N>=,FAuxCommitQty;','')
where fid='J01' And FFieldName='Fauxqty'

请问谁遇到过这个问题?求指导。。。。