nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Best way to cleanup history?

rufini

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

Find more posts tagged with

Comments

jbarrez

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

rufini

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

<br>DELETE FROM ACT_HI_ACTINST&nbsp; WHERE END_TIME_ < '2011-06-22';<br>&nbsp;&nbsp;&nbsp; <br>DELETE FROM ACT_HI_PROCINST WHERE END_TIME_ < '2011-06-22'; <br><br>DELETE FROM ACT_HI_TASKINST WHERE END_TIME_ < '2011-06-22';<br>

Thanks again,
rufini

jbarrez

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'.

sharad

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 ?

trademak

You can use these APIs as well, yes.