Friday, September 9, 2011

Instance states for SOA Suite 11g

The Oracle SOA Suite 11g product development team has decided to confuse the heck out of everyone out there with the codes they use to designate the state of composites and components.

Composite states can be found in the following schema/table/column:
<env>_soainfra.composite_instance.state

BPEL component states can be found here:
<env>_soainfra.cube_instance.state

Mediator component states can be found here:
<env>_soainfra.mediator_instance.component_state

This table maps, to the best of my ability, the various states. It is nowhere near complete, and still requires clarification, but it is the most complete mapping out there to date.





State COMPOSITE_INSTANCE CUBE_INSTANCE MEDIATOR_INSTANCE
Open and Running 0 1 8
Open and Suspended 8 2
Open and Faulted 34 3 2
Closed and Aborted
8
Closed and Cancelled
7
Closed and Completed 1 5 0
Closed and Faulted 2 / 3 6
Closed and Pending/Cancel
4
Closed and Stale 64 9 16
Initiated 0

Terminated

16 / 48 / 50
Recovery Required 4 / 5 / 7
4
Non-Recoverable
10
Unknown 32



If you have any additions or corrections to the table above, please leave a comment below and I'll update it.

Ahmed Aboulnaga

4 comments:

Faruk said...

good job.
thank you

Ahmed Aboulnaga said...

Oracle has FINALLY released a list of the instance states. See this blog post:

http://blogs.oracle.com/ateamsoab2b/entry/list_of_all_states_from

Anonymous said...

I see the blog post but for Composite_Instance - what is State=64 mean? They display "-" ?

Ahmed Aboulnaga said...

Unfortunately, there is no documentation on the "64" state in the COMPOSITE_INSTANCE table.

Even Oracle Doc ID 1362028.1 doesn't describe it. At this time, your best bet is to open an SR to find out for sure.