Monitoring Undelivered Messages in BPEL in SOA 10g

In previous blogs I have discussed the use of the auto-recovery to re-submit asynchronous messages for delivery.  I am currently working with a client that wants to know how many undelivered messages they have, and if it reaches a certain threshold then they wants to alert the operator.  To do this they plan on using the Enterprise Manager alert functions, but first they needs to know how many undelivered instances are out there.

Undelivered asynchronous messages are stored in the INVOKE_MESSAGE table with a RECEIVE_DATE timestamp marking when they were placed in the table and a STATE to indicate if they have not yet been processed (DELIVERY_PENDING 0).  So to query how many messages have not been processed after 10 minutes we can run the query

select count(state) from invoke_message where state = '0' and receive_time < (current_timestamp - Interval '10' Minute)

This counts “count(state)” the number of unprocessed messages “state = '0'” that have been waiting for more than 10 minutes “receive_time < (current_timestamp - Interval '10' Minute)”

We want to allow a delay, in the example 10 minutes, to give the BPEL engine time to start processing the messages.

We can use this query to check that our BPEL instance is processing messages.

References

Oracle SOA Suite Best Practices Guide 10.1.3.3 – Excellent explanation of async delivery messages in here and also discussion of invoke_message table.

Threading in 10.1.3.4 – Blog entry I wrote explaining 10.1.3 threading

Oracle BPEL PM – Dehydration Store? – Blog entry that describes database structures used by BPEL

Invoke Message State Post on OTN Forum

Description of the STATE Values for Tables in the BPEL Dehydration Store - Oracle Support Note

Comments:

In 11g, there is no invoke_message table in SOA_INFRA

Please advise what is the table name in 11g.

Posted by Vikas on August 23, 2012 at 11:54 AM MDT #

Post a Comment:
Comments are closed for this entry.
About

Musings on Fusion Middleware and SOA Picture of Antony Antony works with customers across the US and Canada in implementing SOA and other Fusion Middleware solutions. Antony is the co-author of the SOA Suite 11g Developers Cookbook, the SOA Suite 11g Developers Guide and the SOA Suite Developers Guide.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today