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.

StateDescription
STATE_INITIATED
1STATE_OPEN_RUNNING
2STATE_OPEN_SUSPENDED
3STATE_OPEN_FAULTED
4STATE_CLOSED_PENDING_CANCEL
5STATE_CLOSED_COMPLETED
6STATE_CLOSED_FAULTED
7STATE_CLOSED_CANCELLED
8STATE_CLOSED_ABORTED
9STATE_CLOSED_STALE
10STATE_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