常见场合：1.打开系统控制状态报错。2.系统控制状态保存提示数据库查询异常。请参考方案执行，注意方案中bostype的值。方案：步骤一：--查看错误数据select*fromt_sys_checkerswherefbostype='2FFBE5AC'andfcheckerlike'%fdc%';--备份数据select*intobk20160304_checkersfromt_sys_checkerswherefbostype='2FFBE5AC'andfcheckerlike'%fdc%';--删除deletefromt_sys_checkerswherefbostype='2FFBE5AC'andfcheckerlike'%fdc%';步骤二：--以下备份数据脚本select*intobk20160304_SYSTEMSTATUSCTROLfromT_BD_SYSTEMSTATUSCTROLwherefsystemstatusid='uuI0tl2aTYmFvvzVc0WVTC/75aw=';--备份select*intobk20160304_SYSTEMSTATUSfromT_BD_SYSTEMSTATUSwherefid='uuI0tl2aTYmFvvzVc0WVTC/75aw=';---以下删除垃圾数据deletefromT_BD_SYSTEMSTATUSCTROLwherefsystemstatusid='uuI0tl2aTYmFvvzVc0WVTC/75aw=';--删除deletefromT_BD_SYSTEMSTATUSwherefid='uuI0tl2aTYmFvvzVc0WVTC/75aw=';步骤三：--备份select*intobk20160304_SYS_Checkersfromt_sys_checkersawherea.FBosType='2FFBE5AC'anda.FInterface='com.kingdee.eas.common.app.IBizHasDeal'and(a.FChecker='com.kingdee.eas.fdc.finance.app.ProjectPeriodChecks'ora.FChecker='com.kingdee.eas.fdc.sellhouse.app.SellProjectPeriodChecks')anda.FObjectName='SystemStatusCtrol'anda.FAction='0'anda.FProperty='*'--删除deletefromT_SYS_CheckerswhereFBosType='2FFBE5AC'andFInterface='com.kingdee.eas.common.app.IBizHasDeal'and(FChecker='com.kingdee.eas.fdc.finance.app.ProjectPeriodChecks'orFChecker='com.kingdee.eas.fdc.sellhouse.app.SellProjectPeriodChecks')andFObjectName='SystemStatusCtrol'andFAction='0'andFProperty='*'
