I found this extremely useful list of states for SOA 11g composites and various components in the SOA INFRA DB which we have benefited greatly in various engagements, so I thought it was worth sharing with you all.
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 |
MEDIATOR_INSTANCE
| STATE | Description |
| 0 | No faults but there still might be running instances |
| 1 | At least one case is aborted by user |
| 2 | At least one case is faulted (non-recoverable) |
| 3 | At least one case is faulted and one case is aborted |
| 4 | At least one case is in recovery required state |
| 5 | At least one case is in recovery required state and at least one is aborted |
| 6 | At least one case is in recovery required state and at least one is faulted |
| 7 | At least one case is in recovery required state, one faulted and one aborted |
| >=8 and < 16 | Running |
| >= 16 | Stale |
Referenced from https://blogs.oracle.com/dasoa/entry/list_of_all_states_from
Related
Post Tagged with BPEL, components, composite, composites, CUBE, faults, FMW, list of states, Mediator, OFM, Oracle FMW, purge, SOA, soa11g
2 Responses so far.
Recent Posts
- 12.1.0.2 RAC Installation – Step by Step installation on VMware
- OSB FTP Poller continuously throwing exception – while no file pending on FTP Location
- Using JMS Transport with OSB
- Installing Spring Tool Suite and configuring Spring for a development PC
- Rest Enabling SOA using OSB in Oracle 12c
Recent Comments
- Nits on Installing Oracle SOA Suite 12c
- Rajesh Krishna on Installing Oracle SOA Suite 12c
- Nits on Installing Oracle SOA Suite 12c
- Rohinii on Installing Oracle SOA Suite 12c
- Mahitha on Oracle Service Bus (OSB) Development Best Practices.
Archives
- December 2015
- May 2015
- November 2014
- September 2014
- August 2014
- July 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- July 2013
- June 2013
- May 2013
- March 2013
- February 2013
- November 2012
- October 2012
- September 2012
- May 2012
- March 2012
- February 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- June 2011
- May 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- July 2010
- June 2010
- March 2010
- February 2010
- December 2009
- September 2009
- August 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- November 2008
- October 2008
- August 2008
- June 2008
- May 2008
Categories
- AIA
- AXIS2
- Best Practices
- BPEL
- BPM
- Budget
- Build
- Design Patterns
- ESB
- Hermes
- Hibernate
- Home Owners
- Java
- JMS
- JSR 168
- Maven
- Mediator
- Messaging
- Nitin
- OER
- OESB
- Oracle
- OSB
- OWSM
- Portlets
- SDLC
- Sequencing
- Singleton
- SOA
- SOAP
- Spring
- Struts
- UK
- Uncategorized
- Web Services
- WLST
Meta
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
To find out more, including how to control cookies, see here: Cookie Policy
Recent Posts
- 12.1.0.2 RAC Installation – Step by Step installation on VMware
- OSB FTP Poller continuously throwing exception – while no file pending on FTP Location
- Using JMS Transport with OSB
- Installing Spring Tool Suite and configuring Spring for a development PC
- Rest Enabling SOA using OSB in Oracle 12c
Recent Comments
- Nits on Installing Oracle SOA Suite 12c
- Rajesh Krishna on Installing Oracle SOA Suite 12c
- Nits on Installing Oracle SOA Suite 12c
- Rohinii on Installing Oracle SOA Suite 12c
- Mahitha on Oracle Service Bus (OSB) Development Best Practices.
Archives
- December 2015
- May 2015
- November 2014
- September 2014
- August 2014
- July 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- July 2013
- June 2013
- May 2013
- March 2013
- February 2013
- November 2012
- October 2012
- September 2012
- May 2012
- March 2012
- February 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- June 2011
- May 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- July 2010
- June 2010
- March 2010
- February 2010
- December 2009
- September 2009
- August 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- November 2008
- October 2008
- August 2008
- June 2008
- May 2008
Categories
- AIA
- AXIS2
- Best Practices
- BPEL
- BPM
- Budget
- Build
- Design Patterns
- ESB
- Hermes
- Hibernate
- Home Owners
- Java
- JMS
- JSR 168
- Maven
- Mediator
- Messaging
- Nitin
- OER
- OESB
- Oracle
- OSB
- OWSM
- Portlets
- SDLC
- Sequencing
- Singleton
- SOA
- SOAP
- Spring
- Struts
- UK
- Uncategorized
- Web Services
- WLST
[…] For a list of what these states mean and stand for refer to my earlier post http://nitinaggarwal.wordpress.com/2013/06/12/soa-11g-soa-infra-db-states-for-soa-composites-and-com… […]
[…] For details about the various states Please see my post http://nitinaggarwal.wordpress.com/2013/06/12/soa-11g-soa-infra-db-states-for-soa-composites-and-com… […]