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
