All docs This doc
Skip to end of metadata
Go to start of metadata

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 intervalYou can either remove all completed processes or remove a selected user's processes.

WSO2 EI provides cleanup scripts for the following databases: MySQLOracleMSSQL, and PostgreSQL.

If you are using the clean-up scripts to delete the active process instances, stop the server before executing the clean-up scripts.

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.

  1. 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 the mysql_clean_by_id.sql script.

    Scripts
    mssql_clean_by_id.sql
    mysql_clean_by_id.sql
    oracle_clean_by_id.sql
    postgresql_clean_by_id.sql
  2. Update the selected file with the ID of the bpel process or the human task that you want to remove.
  3. Execute the script.

Verify that the process/task information is removed from the tables in your database.

  • No labels