旗舰版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, ...是多余的
继续升级账套，不知道是否还会报错