topic Re: Delete completed workflows? in Alfresco Forum

Delete completed workflows?

alecima — Mon, 15 May 2017 08:10:24 GMT

Hi,We have a system with activiti engine that does 200k workflows per day.We need to delete old completed workflow and we try use activiti api but the java batch is too slow.So we have to write this pl/sql procedure:create or replace PROCEDURE MNT_CLEAN_FINISHED_WF AS BEGINdbms_output.enable; DBMS_O

Re: Delete completed workflows?

gdharley — Mon, 15 May 2017 17:26:22 GMT

This query looks correct.

You can limit the amount of history records you want to capture by setting the historyLevel in your process engine configuration. Lower level history will not save variable updates and form data submissions. This may reduce the number of records you need to delete on a daily basis.

Greg

‌

Re: Delete completed workflows?

alecima — Tue, 16 May 2017 08:48:03 GMT

Thank you.

We can't set a lower level of historyLevel because we need audit level for troubleshooting purpouse.