sp8升级到M3后流程中心旧数据不兼容解决方案 升级

PS：请注意先备份数据库。
在数据库客户端执行以下sql语句：

1. update T_FLOW_INTERVENTION set STATUS = 'pending' where STATUS is null and DOCID in (select DOCID from T_FLOWSTATERT where COMPLETE=0);
   
2. update T_FLOW_INTERVENTION set STATUS = 'completed' where STATUS is null and DOCID in (select DOCID from T_FLOWSTATERT where COMPLETE=1);
   
3. update T_ACTORRT set T_ACTORRT.DOC_ID = (select DOCID from T_FLOWSTATERT where T_ACTORRT.FLOWSTATERT_ID=T_FLOWSTATERT.ID) where T_ACTORRT.DOC_ID is null;
   
4. update t_flow_intervention set status='completed' where STATUS = 'pending' and DOCID in (select id from T_DOCUMENT where STATEINT>256)

复制代码

这样流程中心的数据就可以正常显示了。