How to Check if a Purge Candidate Instance has a Component in Running State
Last updated on NOVEMBER 03, 2016
Applies to:Oracle SOA Suite - Version 18.104.22.168.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms