Bug 867184

Description of problem:
We need a way to remove existing process instances from the database. We can use the 'cleanup' tag prevent creating new instances, but if we have not been using that, our database will grow to a large size. We need a way to maintain the size of the database, by removing old instances.

We are most concerned with the data in the BPEL_XML_DATA table.

Version-Release number of selected component (if applicable):

Riftsaw 2.3.1.Final

How reproducible:

Use the BluePrint3 tutorial shipped with the 2.3.1.Final source code. Send a 'throw_inv_fault' message to the service, and observe that data is persisted in the BPEL_XML_DATA table.

  
Actual results:

For each request, more data is persisted in the BPEL_XML_DATA table.


Expected results:

A way to delete this data, without breaking any other functionality.

Additional info:

We are aware a 'cleanup' tag is available, and that we should catch and deal with a fault like the 'throw_po_fault' path does, in order to prevent data from being stored in this table.

See BZ 854419
https://bugzilla.redhat.com/show_bug.cgi?id=854419