删除流程发布数据
select t.*, t.rowid from jbpm4_deployprop t where t.deployment_='1600001' or t.objname_='流程xml文件'
select t.*, t.rowid from JBPM4_LOB t where t.deployment_='1600001'
select t.*, t.rowid from jbpm4_deployment t where t.dbid_='1600001'
1、根据文件名称到对应的表单内容表找到对应的流程实例ID
2、清除流程历史表顺序是:
首先删除jbpm4_hist_actinst表,SQL语句例:selectt.*,t.rowidfromjbpm4_hist_actinsttwheret.execution_in('FaWenShenPi.1170315');
接着删除jbpm4_hist_procinst表,SQL语句例:selectt.*,t.rowidfromjbpm4_hist_procinsttwheret.id_in('FaWenShenPi.1170315');
然后删除jbpm4_hist_task表,SQL语句例:selectt.*,t.rowidfromjbpm4_hist_tasktwheret.execution_in('FaWenShenPi.1170315');
历史表删除完毕。
3、删除流程日志表:
删除jbpm_workflow_hislog表,SQL语句例:selectt.*,t.rowidfromjbpm_workflo