专业版9.1升级到12.3 报错,升不了级。
金蝶云社区-钟秋生身份
钟秋生
0人赞赏了该文章 3,846次浏览 未经作者许可,禁止转载编辑于2014年05月30日 08:50:50

专业版 9.1升级12.3时,报错。报错的sql如下。
帐套报错信息

数据库升级失败!SQL文件不全或SQL语句有误!
错误描述:插入错误: 列名或所提供值的数目与表定义不匹配。
Sql文件名:C:\WINDOWS\system32\KIScom\SqlSrv\SP_KISV10_IndustryData.sql
Sql内容:--JXP--20081026--End
--JXP--20081203--Begin
--采购订单变更
if not exists(select C.name from syscolumns C inner join sysobjects T on c.id=t.id where t.name='POOrder' and c.name='FAlterID')
Begin
Alter Table POOrder Add FAlterID [int] NULL
Alter Table POOrder Add FAlterDate [datetime] NULL
Update ICTransactionType
Set FFormHeight=FFormHeight+435
Where FID=71
Declare @InterID int
Select @InterID=FCtlIndex From ICTemplate Where FID='P02' And FFieldName='FCheckerID'

Update ICTemplate Set FCtlIndex=FCtlIndex+1
Where FID='P02' And FCtlIndex>@InterID
Insert Into ICTemplate Values ('P02',@InterID+1,17,'变更:',8,-1,0,1,1,'FAlterID',160,7280,2034,330,0,1,'宋体',9,0,0,'','','',0,3,1,31,'Kdtext',0,0,'','',0,0,1,1,1,'','','','',1)

Select @InterID=FCtlIndex From ICTemplate Where FID='P02' And FFieldName='FCheckDate'

Update ICTemplate Set FCtlIndex=FCtlIndex+1
Where FID='P02' And FCtlIndex>@InterID
Insert Into ICTemplate Values ('P02',@InterID+1,18,'变更日期:',17,-1,1,2,0,'FAlterDate',4348,7280,2034,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=81 And FColName='FCheckerIDName'

Update ICChatBillTitle Set FInterID=FInterID+1
Where FTypeID=81 And FInterID>@InterID

Insert Into ICChatBillTitle Values(@InterID+1,81,'变更人$',' ','FAlterIDName','t_User',1,1000,1,-5,1,0,1,0,'FName','t15',' ',0,0,' ',1,1,1,'','',0,0,5,'',0,0,'',0,1)
Select @InterID=FinterID From ICChatBillTitle Where FTypeID=81 And FColName='FCheckDate'

Update ICChatBillTitle Set FInterID=FInterID+1
Where FTypeID=81 And FInterID>@InterID

Insert Into ICChatBillTitle Values(@InterID+1,81,'变更日期$',' ','FAlterDate','POOrder',0,1000,1,-1,1,0,0,0,'FAlterDate','v1',' ',0,0,' ',1,1,0,'','',0,0,5,'',0,0,'',0,1)
Insert Into ICTableRelation Values(81,15,'POOrder','v1','FAlterID','t_User','t15','FUserID','*=',0,0,1,0,'','','','=',0,0,'')

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

Insert Into GLNoteCitation Values ('P02',@InterID+1,50,'FAlterID','变更$',0,0,6,0,'FAlterID','','',1,'','')
Insert Into GLNoteCitation Values ('P02',@InterID+2,50,'FAlterDate','变更日期$',0,0,6,0,'FAlterDate','','',1,'','')

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='P02' And FFieldName='Fauxqty'
End