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:

BPEL component states can be found here:

Mediator component states can be found here:

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.

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


16 / 48 / 50
Recovery Required 4 / 5 / 7
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


faruk said...

good job.
thank you

Anonymous said...

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

Anonymous said...

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

Anonymous 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.