SOA 11g - How to understand the different states of the COMPOSITE_INSTANCE table?

(Doc ID 1601616.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Goal

Based on the states of the table composite_instance, it is possible infer the following:

composite_instances

State                Description

0000000 -   0     Running
0000001 -   1     Completed
0000010 -   2     Running with faults
0000011 -   3     Completed with faults
0000100 -   4     Running with recovery required
0000101 -   5     Completed with recovery required
0000110 -   6     Running with faults and recovery required
0000111 -   7     Completed with faults and recovery required
0001000 -   8     Running with suspended
0001001 -   9     Completed with suspended
0001010 - 10     Running with faults and suspended
0001011 - 11     Completed with faults and suspended
0001100 - 12     Running with recovery required and suspended
0001101 - 13     Completed with recovery required and suspended
0001110 - 14     Running with faults, recovery required, and suspended
0001111 - 15     Completed with faults, recovery required, and suspended
0010000 - 16     Running with terminated
0010001 - 17     Completed with terminated
0010010 - 18     Running with faults and terminated
0010011 - 19     Completed with faults and terminated
0010100 - 20     Running with recovery required and terminated
0010101 - 21     Completed with recovery required and terminated
0010110 - 22     Running with faults, recovery required, and terminated
0010111 - 23     Completed with faults, recovery required, and terminated
0011000 - 24     Running with suspended and terminated
0011001 - 25     Completed with suspended and terminated
0011010 - 26     Running with faulted, suspended, and terminated
0011011 - 27     Completed with faulted, suspended, and terminated
0011100 - 28     Running with recovery required, suspended, and terminated
0011101 - 29     Completed with recovery required, suspended, and terminated
0011110 - 30     Running with faulted, recovery required, suspended, and terminated
0011111 - 31     Completed with faulted, recovery required, suspended, and terminated
0100000 - 32     Unknown
0100010 - 34     Open and Faulted
0100100 - 36     Running with recovery required and unknown state
0110000 - 48     Terminated
0110010 - 50     Faults and Terminated
1000000 - 64     Stale

Solution

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