Aborted Instance Leaves Inactive Resequencing Groups (Doc ID 2763421.1)

Last updated on JANUARY 08, 2024

Applies to:

Goal

It is observed that in case a business error occurs when interfacing with BRM using Mediator, then composite is aborted automatically the instance in the BPEL flow and as a result:

1. Business Flow instances are aborted and cannot be retried/aborted by console
2. Aborted Instances leave Inactive re-sequencing groups. When querying SOAINFRA schema, we notice that those groups are in error status 3

The impact of the above is the following:

1. Inactive re sequencing groups cannot be cleared because we cannot abort/retry the instance since it was aborted from EBF code. The workaround for this is to either delete the aborted instance and skip re sequencing group or update status from database.
2. Because of the inactive re sequencing group, subsequent orders on the same account remain running because manual intervention is required on the re sequencer.

For batches, customer is looking for SQL statements to work on resequencer tables. As you can see, customer has found out a workaround to update the status on mediator_group_status table and any other tables
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.