金蝶吧 关注:13,248贴子:47,851
  • 5回复贴,共1

金蝶KIS专业版12.0迁到12.3,账套升级出现这个错误

只看楼主收藏回复

各路大神,路过帮帮忙。指点下小弟,小弟万分感激

数据库升级失败!SQL文件不全或SQL语句有误!
错误描述:不能将值 NULL 插入列 'FItemID',表 'AIS20190619104505.dbo.ICSEOrderToWWSC';列不允许有 Null 值。INSERT 失败。
Sql文件名:C:\Program Files (x86)\Kingdee\KIS\Profession\Common\SqlSrv\SP_KISV12_3_IndustryData.sql
Sql内容:--对旧数据进行升级
declare @FCoefficient decimal(23,10)
declare @fqty decimal(23,10)
declare @FOrderInterID int
declare @FSourceEntryID int
declare @FInterID int
declare @FBillNo varchar(255)
declare @ssFUnitID int
declare @ssFItemID int
declare @ssFAuxPropID int
declare @ssFBillNo varchar(255)
--委外加工单
declare @WWRelation_cursor cursor
Set @WWRelation_cursor = cursor for
SELECT FQty,FOrderInterID,FSourceEntryID,FInterID,FBillNo FROM ICOutMO WHERE FOrderInterID>0
open @WWRelation_cursor
fetch @WWRelation_cursor into @FQty,@FOrderInterID,@FSourceEntryID,@FInterID,@FBillNo
while @@fetch_status=0
Begin
select @ssFUnitID=a.FUnitID,@ssFItemID=a.FItemID,@ssFAuxPropID=a.FAuxPropID,@ssFBillNo=b.FBillNo from SEOrderEntry a
inner join SEOrder b on a.FInterID = b.FInterID
where a.FInterID =@FOrderInterID and a.FEntryID = @FSourceEntryID
select @FCoefficient = sum (f1)/sum(f2) from (
select 0 as f1,FCoefficient as f2 from t_MeasureUnit where FItemID= @ssFUnitID
Union All
select FCoefficient as f1,0 as f2 from t_MeasureUnit where FUnitGroupID =(select FUnitGroupID from t_MeasureUnit where FItemID= @ssFUnitID ) and FStandard = 1) t
insert into ICSEOrderToWWSC (FInterID,FBillNo,FEntryID,FTransType,FWWSCInterID,FWWSCBillNo,FItemID,
FAuxPropID,FUnitID,FAuxQty,FQty) values (
@FOrderInterID,'',@FSourceEntryID,91,@FInterID,@FBillNo,@ssFItemID,@ssFAuxPropID,@ssFUnitID,@FQty*@FCoefficient,@FQty)
update ICOutMO set FOrderBillNo = @ssFBillNo where FInterID = @FInterID
fetch next from @WWRelation_cursor into @FQty,@FOrderInterID,@FSourceEntryID,@FInterID,@FBillNo
End
close @WWRelation_cursor
deallocate @WWRelation_cursor
--生产任务单
declare @SCRelation_cursor cursor
Set @SCRelation_cursor = cursor for
SELECT FQty,FOrderInterID,FSourceEntryID,FInterID,FBillNo FROM icmo WHERE FOrderInterID>0
open @SCRelation_cursor
fetch @SCRelation_cursor into @FQty,@FOrderInterID,@FSourceEntryID,@FInterID,@FBillNo
while @@fetch_status=0
Begin
select @ssFUnitID=a.FUnitID,@ssFItemID=a.FItemID,@ssFAuxPropID=a.FAuxPropID,@ssFBillNo=b.FBillNo from SEOrderEntry a
inner join SEOrder b on a.FInterID = b.FInterID
where a.FInterID =@FOrderInterID and a.FEntryID = @FSourceEntryID
select @FCoefficient = sum (f1)/sum(f2) from (
select 0 as f1,FCoefficient as f2 from t_MeasureUnit where FItemID= @ssFUnitID
Union All
select FCoefficient as f1,0 as f2 from t_MeasureUnit where FUnitGroupID =(select FUnitGroupID from t_MeasureUnit where FItemID= @ssFUnitID ) and FStandard = 1) t
insert into ICSEOrderToWWSC (FInterID,FBillNo,FEntryID,FTransType,FWWSCInterID,FWWSCBillNo,FItemID,
FAuxPropID,FUnitID,FAuxQty,FQty) values (
@FOrderInterID,'',@FSourceEntryID,85,@FInterID,@FBillNo,@ssFItemID,@ssFAuxPropID,@ssFUnitID,@FQty*@FCoefficient,@FQty)
update icmo set FOrderBillNo = @ssFBillNo where FInterID = @FInterID
fetch next from @SCRelation_cursor into @FQty,@FOrderInterID,@FSourceEntryID,@FInterID,@FBillNo
End
close @SCRelation_cursor
deallocate @SCRelation_cursor


IP属地:广东1楼2019-07-24 15:48回复
    方便远程吗?我可以帮忙看看。目前看到的情况是委外加工单有字段存在为空的情况


    IP属地:广东2楼2019-07-24 16:32
    收起回复
      用业务模块了吗?提供升级服务


      IP属地:河南3楼2019-07-24 16:46
      回复