Composite Instance States in Oracle SOA 11G Processes

When BPEL (AIA) got tough, we really need this to create simple monitoring tools.

My Tech Blog

When we are troubleshooting purging soa composites instances or during performance testing of soa composite processes , to understand how many instances are getting Completed , how may instances got faulted ,how how many instances went to NonRecoverable states and etc…. , we can run the below query to get the instance states on SOAINFRA schema.

State Description
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


Lihat pos aslinya 1 kata lagi

Iklan

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout /  Ubah )

Foto Google+

You are commenting using your Google+ account. Logout /  Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout /  Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout /  Ubah )

Connecting to %s