【急】K/3 rise 12.2专业版V12.2如何升级到旗舰版4.2
金蝶云社区-Kinmelodyy
Kinmelodyy
0人赞赏了该文章 1,193次浏览 未经作者许可,禁止转载编辑于2016年07月13日 14:53:57

K/3 rise 专业版V12.2如何升级到旗舰版4.2
直接升级到99%时提示有报错,去安装路径下的D:\KIS\Path\qijian\Kingdee\K3ERP\K3Express\KDSYSTEM\KDCOM\account.log进行查看,打开,如下文:
执行文件D:\KIS\PATH\QIJIAN\KINGDEE\K3ERP\K3EXPRESS\KDSYSTEM\KDCOM\SqlSrv\SP_KISUEV4.2ICData_Public.sql出错。错误描述:INSERT 语句与 FOREIGN KEY 约束"FK_FItemClassID"冲突。该冲突发生于数据库"AIS20150710090228",表"dbo.t_ItemClass", column 'FItemClassID'。
错误语句:
--[NO SQL FILE INFOMATION]
---增加微商城虚拟门店
if not exists(SELECT TOP 1 1 FROM t_Item WHERE FItemClassID=10 AND FNumber='OlineStore')
begin
declare @itemid int
INSERT INTO t_Item (FItemClassID,FParentID,FLevel,FName,FNumber,FShortNumber,FFullNumber,FDetail,UUID,FDeleted)
SELECT 10,0,1,'KIS微商城','OlineStore','OlineStore','OlineStore',1,NEWID(),0
SELECT @itemid=FItemID FROM t_Item WHERE FItemClassID=10 AND FNumber='OlineStore'
INSERT INTO t_SonCompany (FTrade,FRegionID,FAcctModeID,FOwnershipID,FAssetshipID,FSuperDeptID,
FInvestAmt,FInvestRate,FBadDebtsRate,FBondInvestAmt,FRetailStockID,
FStockPlaceID,FCorProvider,FCorCustomer,FDepartmentID,FSuperiorID,
FAgencyStockID,FAgencySPID,FBranchNumber,FBranchIP,FBranchType,
FBranchArea,FEmpCount,FPointsRate,FPhone,FAddress,FIsLeague,FNote,
FZoneID,FOutInStore,FShortNumber,FNumber,FName,FParentID,FItemID)
SELECT 0,0,553,0,0,0,
0,0,0,0,0,
0,0,0,0,0,
0,0,'WSC',NULL,0,
0,0,0,NULL,'KIS微商城',0,'微商城虚拟门店(注:请勿用于门店开单)',
0,0,'OlineStore','OlineStore','KIS微商城',0,@itemid
end