系统状态控制页面报错处理方法

常见场合：

1.打开系统控制状态报错。

2.系统控制状态保存提示数据库查询异常。

请参考方案执行，注意方案中bostype的值。

方案：

步骤一：

--查看错误数据

select * from t_sys_checkers where fbostype='2FFBE5AC' and fchecker like '%fdc%';

--备份数据

select * into bk20160304_checkers from t_sys_checkers where fbostype='2FFBE5AC' and fchecker like '%fdc%';

--删除

delete from t_sys_checkers where fbostype='2FFBE5AC' and fchecker like '%fdc%';

步骤二：

--以下备份数据脚本

select * into bk20160304_SYSTEMSTATUSCTROL from T_BD_SYSTEMSTATUSCTROL where fsystemstatusid='uuI0tl2aTYmFvvzVc0WVTC/75aw=';

--备份

select * into bk20160304_SYSTEMSTATUS from T_BD_SYSTEMSTATUS where fid ='uuI0tl2aTYmFvvzVc0WVTC/75aw=';

---以下删除垃圾数据

delete from T_BD_SYSTEMSTATUSCTROL where fsystemstatusid ='uuI0tl2aTYmFvvzVc0WVTC/75aw=';

--删除

delete from T_BD_SYSTEMSTATUS where fid ='uuI0tl2aTYmFvvzVc0WVTC/75aw=';

步骤三：

--备份

select * into bk20160304_SYS_Checkers from t_sys_checkers a

where a.FBosType = '2FFBE5AC'

and a.FInterface = 'com.kingdee.eas.common.app.IBizHasDeal'

and ( a.FChecker = 'com.kingdee.eas.fdc.finance.app.ProjectPeriodChecks'

or a.FChecker = 'com.kingdee.eas.fdc.sellhouse.app.SellProjectPeriodChecks')

and a.FObjectName = 'SystemStatusCtrol'

and a.FAction = '0'

and a.FProperty = '*'

--删除

delete from T_SYS_Checkers where FBosType = '2FFBE5AC'

and FInterface = 'com.kingdee.eas.common.app.IBizHasDeal'

and ( FChecker = 'com.kingdee.eas.fdc.finance.app.ProjectPeriodChecks'

or FChecker = 'com.kingdee.eas.fdc.sellhouse.app.SellProjectPeriodChecks')

and FObjectName = 'SystemStatusCtrol'

and FAction = '0'

and FProperty = '*'