How to Check if a Purge Candidate Instance has a Component in Running State
(Doc ID 1573058.1)
Last updated on JULY 10, 2020
Applies to:Oracle SOA Suite - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
It is recommended to run these scripts outside of normal business hours, and also limit the time-window configured on the query.
This query is doing a verification to detect something anomalous in the tables. The first two columns represent the state of the composites instances (purgeable states) and the right columns represent associated components that are in a running state.
Using this query you will be able to detect those composite instances that despite having a completed states in the composite_instance table, are not purged, meaning that there could be running components for the same ECID in bpel - mediator - dlvmessage - rules - hw.
The below query is doing a comparison between the:
(ENDING STATES from composite_instance ) v/s RUNNING STATES in other components.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document