List of all states from COMPOSITE_INSTANCE, CUBE_INSTANCE, DLV_MESSAGE tables
Posted
by Deepak Arora
on Oracle Blogs
See other posts from Oracle Blogs
or by Deepak Arora
Published on Tue, 29 Nov 2011 16:47:11 -0600
Indexed on
2011/11/30
1:59 UTC
Read the original article
Hit count: 631
/Oracle/SOA
|fmw
In many of my engagements I get asked repeatedly about the states of the composites in 11g and how to decipher them, especially when we are troubleshooting issues around purging. I have compiled a list of all the states from the COMPOSITE_INSTANCE, CUBE_INSTANCE, DLV_MESSAGE and MEDIATOR_INSTANCE tables. These are the primary tables that are used when using BPEL composites and how they are used with the ECID.
Composite State Values
COMPOSITE_INSTANCE States
| State | Description |
|---|---|
| 0 | Running |
| 1 | Completed |
| 2 | Running with faults |
| 3 | Completed with faults |
| 4 | Running with recovery required |
| 5 | Completed with recovery required |
| 6 | Running with faults and recovery required |
| 7 | Completed with faults and recovery required |
| 8 | Running with suspended |
| 9 | Completed with suspended |
| 10 | Running with faults and suspended |
| 11 | Completed with faults and suspended |
| 12 | Running with recovery required and suspended |
| 13 | Completed with recovery required and suspended |
| 14 | Running with faults, recovery required, and suspended |
| 15 | Completed with faults, recovery required, and suspended |
| 16 | Running with terminated |
| 17 | Completed with terminated |
| 18 | Running with faults and terminated |
| 19 | Completed with faults and terminated |
| 20 | Running with recovery required and terminated |
| 21 | Completed with recovery required and terminated |
| 22 | Running with faults, recovery required, and terminated |
| 23 | Completed with faults, recovery required, and terminated |
| 24 | Running with suspended and terminated |
| 25 | Completed with suspended and terminated |
| 26 | Running with faulted, suspended, and terminated |
| 27 | Completed with faulted, suspended, and terminated |
| 28 | Running with recovery required, suspended, and terminated |
| 29 | Completed with recovery required, suspended, and terminated |
| 30 | Running with faulted, recovery required, suspended, and terminated |
| 31 | Completed with faulted, recovery required, suspended, and terminated |
| 32 | Unknown |
| 64 | - |
Any value in the range of
32 to 63 indicates that the composite instance state has not been enabled, but
the instance state is updated for faults, aborts, etc.
CUBE_INSTANCE States
| State | Description |
|---|---|
| 0 | STATE_INITIATED |
| 1 | STATE_OPEN_RUNNING |
| 2 | STATE_OPEN_SUSPENDED |
| 3 | STATE_OPEN_FAULTED |
| 4 | STATE_CLOSED_PENDING_CANCEL |
| 5 | STATE_CLOSED_COMPLETED |
| 6 | STATE_CLOSED_FAULTED |
| 7 | STATE_CLOSED_CANCELLED |
| 8 | STATE_CLOSED_ABORTED |
| 9 | STATE_CLOSED_STALE |
| 10 | STATE_CLOSED_ROLLED_BACK |
DLV_MESSAGE States
| State | Description |
|---|---|
| 0 | STATE_UNRESOLVED |
| 1 | STATE_RESOLVED |
| 2 | STATE_HANDLED |
| 3 | STATE_CANCELLED |
| 4 | STATE_MAX_RECOVERED |
Since now in 11g the Invoke_Messages table is not there so to distinguish between a new message (Invoke) and callback (DLV) and there is DLV_TYPE column that defines the type of message:
DLV_TYPE States
|
 |
||||||||||||||||||||||||||||||
In my next blog posting I will walk through the lifecycle of a BPEL process using the above states for the following use cases:
- New BPEL process - initial Receive activity
- Callback BPEL process - mid-level Receive activity
As always comments and questions welcome!
Deepak
© Oracle Blogs or respective owner
