Delete historic process instances not complete

Camunda 7 Topics Discussion & Questions
1

Hi there,
I am using camunda version 7.13.

I have used the below API to delete history from camunda tables

historyService.createHistoricProcessInstanceQuery()
.executedJobBefore(date);
set removal time to them and cleaned using
historyService.cleanUpHistoryAsync();
it suceccessfully cleaned data from below tables.
ACT_HI_VARINST
ACT_HI_ACTINST
ACT_HI_DETAIL
ACT_HI_PROCINST
ACT_HI_EXT_TASK_LOG

but below the history tables were are not cleaned:

ACT_HI_IDENTITYLINK
ACT_HI_JOB_LOG

is there some additional configuration I missed, to delete other history tables?
or it requires another API ? please advise

additionally, i need to clean up other non-history tables as well like
ACT_GE_BYTEARRAY, please advise.

I have referred History and Audit Event Log | docs.camunda.org

but my case is specific in such a way that I need to clean when a request comes, and setting removal time in the batch was perfect but not all were cleared

2

Can you clarify your use case?

when a request comes

Would a removal time strategy of start fit your use case?
<property name="historyRemovalTimeStrategy">start</property>

If you can use effectively use the removal-time strategy, the engine will set the removal times correctly in all of the tables. But if you’re going to go with your own custom strategy, you’ll have to manually set the removal times like you did for the first five tables.