【问题描述】
商贸版打开销售单明细表提示正在服务器获取数据。
如下图所示：
【原因分析】
单用户缓存异常导致。
【解决方案】
可参考以下脚本执行处理：
set nocount on
declare @Fuserid int
select @Fuserid=Fuserid from t_user
--在这里修改需要清理个人信息的用户名
where fname='用户名'
--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
【注意事项】
正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。