旗舰版7.0安装包：2022-09-23的安装包

安装过程出现一个报错，点确认能通过；

安装完成进行账套升级，遇到了报错

问题1：打开账套管理提示用户验证错误，在对应所需名称或序数的集合中，未找到项目

处理：

对数据库实体【AcctCtl_KEE】执行以下SQL：

IF NOT EXISTS ( SELECT TOP 1 1 FROM [AcctCtl_KEE].INFORMATION_SCHEMA.COLUMNS WHERE [TABLE_NAME] = 't_Users' AND [COLUMN_NAME] = 'FWrongPsdQty' )

BEGIN

ALTER Table [AcctCtl_KEE].dbo.t_Users Add [FWrongPsdQty] [int] Not NULL DEFAULT (0)

END

GO

--增加字段

IF NOT EXISTS ( SELECT TOP 1 1 FROM [AcctCtl_KEE].INFORMATION_SCHEMA.COLUMNS WHERE [TABLE_NAME] = 't_Users' AND [COLUMN_NAME] = 'FLockedUntil' )

BEGIN

ALTER Table [AcctCtl_KEE].dbo.t_Users Add [FLockedUntil] [datetime] NULL

END

GO

--增加字段

IF NOT EXISTS ( SELECT TOP 1 1 FROM [AcctCtl_KEE].INFORMATION_SCHEMA.COLUMNS WHERE [TABLE_NAME] = 't_Users' AND [COLUMN_NAME] = 'FPwCreateDay' )

BEGIN

Alter Table [AcctCtl_KEE].dbo.t_Users Add [FPwCreateDay] [datetime] NULL

END

GO

Update [AcctCtl_KEE].dbo.t_Users Set FPwCreateDay = GETDATE() where FPwCreateDay is null

GO

问题2：账套升级报错

数据库升级失败！SQL文件不全或SQL语句有误!

错误描述:'GO' 附近有语法错误。

Sql文件名:C:\PROGRAM FILES (X86)\KINGDEE\K3ERP\K3EXPRESS\KDSYSTEM\KDCOM\SqlSrv\SP_KISUEV7.0.1NewData.sql

Sql内容:

--[NO SQL FILE INFOMATION]

/****** Object:Data   单据编号：t_BillCodeRule    Script Date: 2019-10-22 ******/

 IF NOT EXISTS (SELECT * FROM  t_BillCodeRule WHERE FBillTypeID=1014325) 

 BEGIN 

INSERT INTO t_BillCodeRule(FBillTypeID,FClassIndex,FProjectID,FProjectVal,FFormatIndex,FLength,FAddChar,FReChar,FBillType,FIsBy) 

VALUES ('1014325',1,1,'PDMB',0,4,'','','',0) 

INSERT INTO t_BillCodeRule(FBillTypeID,FClassIndex,FProjectID,FProjectVal,FFormatIndex,FLength,FAddChar,FReChar,FBillType,FIsBy) 

VALUES ('1014325',2,3,'18',0,

...

处理：

打开这个SQL文件把后面的语句删掉再升级C:\PROGRAM FILES (X86)\KINGDEE\K3ERP\K3EXPRESS\KDSYSTEM\KDCOM\SqlSrv\SP_KISUEV7.0.1NewData.sql，后面的INSERT INTO t_BillCodeRule(FBillTypeID,FClassIndex,FProjectID,FProjectVal,FFormatIndex,FLength,FAddChar,FReChar,FBillType,FIsBy) VALUES ('1014325',2,3,'18',0, ...是多余的

继续升级账套，不知道是否还会报错