topic Re: Delete Process Instance doesn't mark end of HistoricProcess instant and loses deleteReason in Alfresco Archive

Delete Process Instance doesn't mark end of HistoricProcess instant and loses deleteReason

zoenzo — Fri, 26 Apr 2013 07:59:47 GMT

Hi,I used RuntimeService.deleteProcessInstance to delete some old process instance by using the following code. The reason I add the processDefinition to the DeploymentCache is that they are some old definition and is not in the cache since the system has restarted many times.if(pi.getEndTime()==nul

Re: Delete Process Instance doesn't mark end of HistoricProcess instant and loses deleteReason

zoenzo — Sat, 27 Apr 2013 08:04:37 GMT

Currently, I use the following native sql to do the mark end. Is it Ok ? Can anyone help?
<java>
public void markProcessInstanceEnd(String processId)
{
String sql="update act_hi_procinst set END_TIME_=NOW(), DELETE_REASON_='Admin TEST' where ID_='"+processId+"'";
SQLQuery query = this.getSession().
createSQLQuery(sql);
query.executeUpdate();
}
</java>

Re: Delete Process Instance doesn't mark end of HistoricProcess instant and loses deleteReason

frederikherema1 — Tue, 30 Apr 2013 09:31:33 GMT

I've added a test to master in github, asserting that the "deleteReason" is indeed set after deleting: https://github.com/Activiti/Activiti/commit/7b3575d50bbc1620f487ae0ce172edab25ceb9cb

Why not just query the actually non-historic Processinstances and delete them instead of using the Historic?