【问题描述】

旗舰版银行存款日记账，单个用户无法用鼠标左右拖动列宽（试图拖动时没反应）

【原因分析】

系统中存在异常的用户缓存数据。

【解决方案】

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

--Administrator标红部分为功能异常的用户名，实际使用以下SQL脚本时，请以实际用户名进行替换

declare @Fuserid int

select @Fuserid=Fuserid from t_user

where fname='Administrator'

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

begin

delete from ICSchemeProfile where fuserid=@Fuserid

end

if exists (select 1 from sysobjects where name='t_UserSetting' and xtype='u')

begin

delete From t_UserSetting Where fuserid=@Fuserid

end

【注意事项】

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