topic Re: Best way to cleanup history? in Alfresco Archive

Best way to cleanup history?

rufini — Tue, 28 Jun 2011 20:59:42 GMT

Hi all;I'm an Activiti newbie and I would like to know what could be the best way to cleanup history tables. I'm planning to write a SQL query to delete records from ACT_HI_* previous to certain date. Is that the best way? Any suggestion?Thanks in advance!rufini

Re: Best way to cleanup history?

jbarrez — Wed, 29 Jun 2011 10:26:35 GMT

Yes, that would be the easiest way to do it.

Re: Best way to cleanup history?

rufini — Wed, 29 Jun 2011 13:33:43 GMT

Thanks for your quick reply, jbarrez.

Is it sure to delete from that tables? Can I break something?

I'm thinking to do something like


DELETE FROM ACT_HI_ACTINST  WHERE END_TIME_ < '2011-06-22';
    
DELETE FROM ACT_HI_PROCINST WHERE END_TIME_ < '2011-06-22'; 

DELETE FROM ACT_HI_TASKINST WHERE END_TIME_ < '2011-06-22';

Thanks again,
rufini

Re: Best way to cleanup history?

jbarrez — Thu, 30 Jun 2011 08:18:54 GMT

Depends on what queries you have written. If you have any logic dependent on the history data, then it might break something 😉

But if not, then you can just delete the history data. If you are not using the history data, it might be good to set the history level to 'none'.

Re: Best way to cleanup history?

sharad — Thu, 27 Mar 2014 12:54:29 GMT

We have seen deleteHistoricProcessInstance and deleteHistoricTaskInstance api's avaliable for deleting process instances and task from history table. Do we still need to Delete SQL queries for History Cleanup ?

Re: Best way to cleanup history?

trademak — Mon, 31 Mar 2014 14:54:03 GMT

You can use these APIs as well, yes.