How i can clean old data from table?

Community Community Extensions
1

How can I clear old data in these tables (and similar ones). The tables have data with the date 04.2020, but they only take up space.
CAMUNDABPM > ACT_HI_ACTINST TABLE 8.54 GiB
CAMUNDABPM > ACT_HI_EXT_TASK_LOG TABLE 5.66 GiB
CAMUNDABPM > ACT_IDX_HI_ACT_INST_COMP INDEX 4.93 GiB
CAMUNDABPM > ACT_HI_DETAIL TABLE 4.89 GiB
CAMUNDABPM > ACT_HI_JOB_LOG TABLE 4.75 GiB
CAMUNDABPM > ACT_IDX_HI_ACT_INST_STATS INDEX 4.58 GiB

2

@11120 see the History Cleanup docs.

You can also do it from the REST api https://docs.camunda.org/manual/7.14/reference/rest/history/history-cleanup/

3

I have used this API, but for some reason the cleanup is not happening.

4

See the docs that are linked: https://docs.camunda.org/manual/7.14/user-guide/process-engine/history/#history-cleanup

The cleanup is async, so it would be handled by the job executor.

5

Yes I saw the documentation, I tried to do something similar, but when trying to deploy, an error occurred. Perhaps I do not understand where to insert property data, I use bpm-platform.xml

ENGINE-08040 Cannot find setter for property ‘historyTimeToLive’ on class ‘org.camunda.bpm.engine.impl.cfg.StandaloneProcessEngineConfiguration’

6

When you submitted the history clean up through the rest api what was the response from the API?

7

{

"id": "1d8ab505-5dfd-11ea-81af-6680df2e95f7",

"jobDefinitionId": null,

"processInstanceId": null,

"processDefinitionId": null,

"processDefinitionKey": null,

"executionId": null,

"exceptionMessage": null,

"retries": 3,

"dueDate": "2020-11-26T07:56:11.401+0000",

"suspended": false,

"priority": 0,

"tenantId": null

}

8

Any ideas? I’ve tried everything. I took the config from other users, it works for them. Writes for me that there is no setter