Thursday, February 28, 2013

States meaning for Instances

This is an enhanced version of my own blog dated 08-Aug-2008, BPEL: Purging Instances-1, which suggests about various States stored in Dehydration store. Earlier information was for SOA 10g interface States stored in Cube_instances, This blog is about the same but for SOA 11g.

Problem: To know the meaning of States stored under CUBE_INSTANCE table of SOA_INFRA Schema

Explanation:

Value: 0
Meaning: Initiated
Description: for an instance that has just been newly created

Value: 1
Meaning: Open & Running
Description: for an instance that has been created and has active activities executing

Value: 2
Meaning: Open & Suspended
Description: for an instance that is unavailable & is in suspended state. No action can be taken for this instance until the instance has returned to the running state

Value: 3
Meaning: Open & Faulted
Description: for an instance that has an activity that has thrown an exception. When an activity throws an exception, the instance is flagged as being in an exception state until the exception is properly caught and handled

Value: 4
Meaning: Open & Pending
Description: for an instance that is in mid of cancellation. An instance is said to be pending cancellation state - it may happen that the process is quite big & complicated that the entire cancellation process may takes anywhere from seconds/minutes/days. An instance may not be acted upon during this time

Value: 5
Meaning: Closed & Completed
Description: for an instance that has been completed i.e. All activities belonging to this instance have also been completed

Value: 6
Meaning: Closed & Faulted
Description: for an instance that has an activity that has thrown an exception while the instance is being cancelled

Value: 7
Meaning: Closed & Cancelled
Description: for an instance that has been cancelled. All activities belonging to this instance have also been cancelled

Value: 8
Meaning: Closed & Aborted
Description: for an instance that has been aborted due to administrative control. All activities belonging to this instance are also moved to the aborted state

Value: 9
Meaning: Closed & Stale
Description: for an instance who's process has been changed since the process was last accessed. No actions may be performed on the instance. All activities that belong to this instance are also moved to the stale state

Value: 10
Meaning: Non Recoverable
Description: for an instance that has failed and is marked as non recoverable

Wednesday, February 27, 2013

And here I come with more exciting knowledge and learnings.

Apologies for not being there for quite a few months. During this period I have gathered lot of experiences on Oracle Fusion products and its implementation which I will sharing to you all, watch out the space.


And yes, although I am late, as always I wish all my blog readers a very happy and prosperous New Year 2013.