kis旗舰版“用户验证错误：在对应所需名称或序数的集合中，未找到项目”

金蝶总部研发原因分析：

本地账套管理数据库未执行脚本导致，本地账套管理数据库未执行脚本导致

对数据库实体【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