【问题描述】

商贸版单个用户打开序时簿或选择源单单据时提示行：1，字段：日期比较值不能为空。如下图所示：

单用户缓存异常导致。

【解决方案】

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

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='ICClassProfile' and xtype='u')

begin

delete from ICClassProfile 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

正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。