（本文仅供参考，如需操作，请务必先做好相关数据备份，再执行。）
场景一：
存在个别测试流程数据需要清理。
操作步骤：
1、右键待办、已办或我发起页面的记录，获取实例ID，之后将获取到的实例ID代入到2、3步骤中的SQL。
2、执行以下SQL备份数据：
SELECT * FROM ACT_BI_FLOW_STATE WHERE INSTANCE_ID_='XX';
SELECT * FROM ACT_HI_ACTINST WHERE PROC_INST_ID_='XX';
SELECT * FROM ACT_HI_COMMENT WHERE PROC_INST_ID_='XX';
SELECT * FROM ACT_HI_INCIDENT WHERE PROC_INST_ID_='XX';
SELECT * FROM ACT_HI_PROCINST WHERE PROC_INST_ID_='XX';
SELECT * FROM ACT_HI_TASKINST WHERE PROC_INST_ID_='XX';
SELECT * FROM ACT_RU_TASK WHERE PROC_INST_ID_='XX';
SELECT * FROM ACT_GE_BYTEARRAY WHERE ID_ IN (SELECT BYTEARRAY_ID_ FROM ACT_HI_VARINST WHERE PROC_INST_ID_='XX');
SELECT * FROM ACT_HI_VARINST WHERE PROC_INST_ID_='XX';
SELECT * FROM ACT_RU_VARIABLE WHERE PROC_INST_ID_='XX';
通过以上SQL语句查询出相关数据后，进行备份。
3、执行以下SQL删除数据：
DELETE FROM ACT_BI_FLOW_STATE WHERE INSTANCE_ID_='XX';
DELETE FROM ACT_HI_ACTINST WHERE PROC_INST_ID_='XX';
DELETE FROM ACT_HI_COMMENT WHERE PROC_INST_ID_='XX';
DELETE FROM ACT_HI_INCIDENT WHERE PROC_INST_ID_='XX';
DELETE FROM ACT_HI_PROCINST WHERE PROC_INST_ID_='XX';
DELETE FROM ACT_HI_TASKINST WHERE PROC_INST_ID_='XX';
DELETE FROM ACT_RU_TASK WHERE PROC_INST_ID_='XX';
DELETE FROM ACT_GE_BYTEARRAY WHERE ID_ IN (SELECT BYTEARRAY_ID_ FROM ACT_HI_VARINST WHERE PROC_INST_ID_='XX');
DELETE FROM ACT_HI_VARINST WHERE PROC_INST_ID_='XX';
DELETE FROM ACT_RU_VARIABLE WHERE PROC_INST_ID_='XX';
