This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.

Database Clean-up Scripts

Owned by Former user (Deleted)
Last updated: Mar 01, 2018
1 min read

Business Process Management profile of WSO2 EI comes along with the cleanup scripts for both bpel and bpmn.  These scripts can be executed within a predefined time interval. By doing so, database lookup time can be reduced significantly.  Clean up scripts can be located in the  <EI_HOME>/wso2/business-process/repository/resources/cleanup-scripts/ folder.

WSO2 EI provides cleanup scripts for the following databases.

  • MySQL
  • Oracle
  • MSSQL
  • PostgreSQL

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

BPEL cleanup scripts

BPEL cleanup scripts are used to clean up the both completed bpel instances and human tasks.  Scripts can be found in the <EI_HOME>/wso2/business-process/repository/resources/cleanup-scripts/bpel/ directory.

BPMN cleanup scripts

BPMN cleanup scripts are used to clean up the completed bpmn instances. Scripts can be found in the <EI_HOME>/wso2/business-process/repository/resources/cleanup-scripts/bpmn/ directory.