金蝶KIS专业版单用户打开凭证管理提示运行时错误，无法从指定的源创建记录集………?

【问题描述】

专业版单用户打开凭证管理提示运行时错误，无法从指定的源创建记录集，源文件或流必须包含XML或ADTG格式的记录集数据。如下图所示：

【原因分析】

单用户缓存异常，导致查询凭证管理报错，清除异常用户数据问题可解决。

【解决方案】

操作前一定要备份，建议联系专业人士处理

可参考以下脚本执行处理：

set nocount on
declare @Fuserid int
select @Fuserid=Fuserid from t_user

--在这里修改需要清理个人信息的用户名
where fname='manager'
--select @Fuserid
if exists (select 1 from sysobjects where name='ICClassUserProfile' and xtype='u')
begin
delete from ICClassUserProfile where fuserid=@Fuserid
end
if exists (select 1 from sysobjects where name='t_UserProfile' and xtype='u')
begin
delete from t_UserProfile where fuserid=@Fuserid
end
if exists (select 1 from sysobjects where name='ICReportProfile' and xtype='u')
begin
delete from ICReportProfile where fuserid=@Fuserid
end
if exists (select 1 from sysobjects where name='ICPlanProfile' and xtype='u')
begin
delete from ICPlanProfile where fuserid=@Fuserid
end
if exists (select 1 from sysobjects where name='ICPlanProfile' and xtype='u')
begin
delete from ICPlanProfile where fuserid=@Fuserid
end
if exists (select 1 from sysobjects where name='ICSchemeProfile' and xtype='u')
begin
delete from ICSchemeProfile where fuserid=@Fuserid
end
if exists (select 1 from sysobjects where name='icreportprofile' and xtype='u')
begin
delete from icreportprofile where fuserid=@Fuserid
end
if exists (select 1 from sysobjects where name='icreportformat' and xtype='u')
begin
delete from icreportformat where fuserid=@Fuserid
end
go
select '清除账套中的用户个人信息的数据完成。' 备注
go

操作前一定要备份，建议联系专业人士处理