Bonita Platform Maintenance Operation

Learn how maintenance operations can help reducing disk space used by the Bonita Platform.

Purge archive tables

Archive tables contain the execution history of the Bonita Platform. Some of these tables can be purged to reduce size on disk.

Archive Contract Data

Archive contract data table keeps the information of all contracts sent to execute tasks or instantiate processes. After of a lot of tasks or processes were executed, the arch_contract_data table could become very big and consume a lot of disk space.

The information contained in table arch_contract_data is not required by Bonita Platform to work so this table could be purged to reduce disk space usage.

These section will describe how to purge the arch_contract_data table, depending on the version of Bonita Platform installed.

This operation is destructive, data will be not usable for audit or analytic purposes. It is highly recommended to backup data before the purge.

Keep in mind that the contract data’s will continue to be archived and the table will continue to grow, even after the purge has been done. Hoverer, it is possible to deactivate the archiving of contract data’s, please see (Configurable Archive.)

To delete all rows from the arch_contract_data, you can use the TRUNCATE TABLE statement.

    TRUNCATE TABLE arch_contract_data;

After a migration to the bonita 7.7 version, the data of the arch_contract_data table has been moved to the new arch_contract_data_backup table for migration purposes. In that case, If the live-migration tool was not executed (please see [Bonita migration steps]|migrate-from-an-earlier-version-of-bonita-bpm.md), you will also need to drop the table arch_contract_data_backup:

    DROP TABLE arch_contract_data_backup;