Database Clean-up Scripts
- Former user (Deleted)
The BPS profile of WSO2 Enterprise Integrator (WSO2 EI) is shipped with cleanup scripts that can remove completed instances of BPEL, BPMN, and Human Task processes. These scripts can be executed within a predefined time interval. You can either remove all completed processes or remove a selected user's processes.
WSO2 EI provides cleanup scripts for the following databases: MySQL, Oracle, MSSQL, and PostgreSQL.
Remove all completed process instances
You can use this method of removing all completed process instances to control your database from growing in size. By doing so, the database lookup time can be reduced significantly. This applies to BPMN processes, BPEL processes, as well as Human Tasks.
If you want to remove selected BPMN processes from the database, go to General Data Protection Regulation (GDPR) for WSO2 EI. To remove selected BPEL processes, or Human Tasks, go to the next section on this page.
You can remove all instances of completed BPMN, BPEL, and Human Task processes by using one of the scripts listed below. These scripts are stored separately in the bpmn and bpel folders of the <EI_HOME>/wso2/business-process/repository/resources/cleanup-scripts/ directory. Note that the scripts in the bpel folder will remove both bpel and human task process instances.
Be sure to pick the script that is relevant to your database type from the relevant folder (bpmn, or bpel).
| Scripts |
|---|
| mssql_clean.sql |
| mysql_clean.sql |
| oracle_clean.sql |
| postgres_clean.sql |
Remove selected BPEL processes/Human Tasks
If you are using BPEL processes and Human Tasks, you can select the required (completed) process instances, and remove them individually (instead of removing all the completed process instances). This can be done using a special set of scripts that are stored in the bpel, and humantask folders of the <EI_HOME>/wso2/business-process/repository/resources/cleanup-scripts/ directory.
Follow the steps given below.
Go to the relevant folder (bpel or humantask) in the
<EI_HOME>/wso2/business-process/repository/resources/cleanup-scripts/directory and open the script that is relevant to your database type. For example, if your database is MySQL, select themysql_clean_by_id.sqlscript.Scripts mssql_clean_by_id.sql mysql_clean_by_id.sql oracle_clean_by_id.sql postgresql_clean_by_id.sql - Update the selected file with the ID of the bpel process or the human task that you want to remove.
- Execute the script.
Verify that the process/task information is removed from the tables in your database.