History Clean Up does not delete old process instance

Camunda 7 Topics Discussion & Questions
,
1

Hi,
we are using Automatic Clean Up since about 2 months, but started it only after about 17 Month of Production.
For all process models we found in the clean up menu is a TTL of 180 days configured and historyCleanupStrategy is set to endTimeBased.

But, when i run
SELECT year(END_TIME_), month(END_TIME_), count(ID_) fROM “CAMUNDA_CI”.“ACT_HI_PROCINST”
group by year(END_TIME_), month(END_TIME_) order by year(END_TIME_), month(END_TIME_)

I always found ProcInstances with EndTime much higher than 180 Days. (For example about 7800 from last year may).

Why are these old Process Instances not deleted?

2

Nobody any suggestions on this topic?

3

Is your old table records has a removal_time_ column filled?

4

No. Removal_Time_ is “<null>” at the process instances, which are still there.

Ah, without removal_time_ no deletion. OK. Thanks for your answer Artem.

So why do we have process_instances without removal time?

5

Hi @fastjoe23,

the removal time is set, once the history time to live is set on the process model. Only process instances started with a given history time to live get the removal time.

In the Enterprise Edition you can set the removal time with a batch in Cockpit: Batch operation | docs.camunda.org.

In the Community Edition you have to start the batch with the Rest API.

Hope this helps, Ingo

1 Like
6

Thank you very much, Ingo and Artem. As we are using the Enterprise Edition i am hopeful, we will be able to set removal time.

7