This discussion is archived
5 Replies Latest reply: Nov 23, 2012 1:06 AM by Nghia Pham RSS

Checking for status of a long-running BPEL process

Nghia Pham Newbie
Currently Being Moderated
Hi experts,

I have one BPEL process for originating customers' loan which usually involves various steps which takes around 15-20 mins to complete per instance. I would like to implement a user interface that can check the process's progress and display how it is going to the user.

I have thought of using an asynchronous process that updates a global variable listing status of each step inside the process and use a poller to invoke another operation (like "checkStatus" operation) of this process to retrieve this variable and display the value to the users. It may be achieved by using "OnEvent" activity waiting for "checkStatus" operation. It will run in parallel with the main process, have access to the global variable and reply this variable immediately to the caller.

It sounds like an idea in theory but invoking a web service operation for polling status is very heavy-weight and may impact performance during high-load.

I am just wondering if there is other solution to this problem as I believe the status checking is a very common expected requirement in long-running BPEL process. What might be the best practice to implement this?

Look forward to your responses.

Thanks and regards,

Edited by: Nghia Pham on Nov 5, 2012 4:48 PM
  • 1. Re: Checking for status of a long-running BPEL process
    stever Newbie
    Currently Being Moderated
    You might check out BAM. You will still need to create the checkpoints but it has cool presentation.

    https://www.youtube.com/watch?v=9XEwc3SiwuA
  • 2. Re: Checking for status of a long-running BPEL process
    veejai24 Pro
    Currently Being Moderated
    As per the above user, BAM is the best fit for you.

    A recorded product demonstration is here.

    http://download.oracle.com/demo1_FINALGOLD_resize_BAM.swf

    Get started wtih BAM

    http://docs.oracle.com/cd/E15586_01/integration.1111/e10230/getting_started.htm

    *7) Give points - it is good etiquette to reward an answerer points (5 - helpful; 10 - correct) for their post if they answer your question.*

    Thanks,
    Vijay
  • 3. Re: Checking for status of a long-running BPEL process
    Nghia Pham Newbie
    Currently Being Moderated
    Hi.

    I apologize for the slow reply. I am just back from overseas and did not have chance to go to the forum!

    Thank you a lot for your responses!

    The BAM looks like a suggested out-of-the-box solution. But it ties too much to Oracle API and will be hard to customise the way you want to interpret the status to end-users. If you want to display the process status with BAM in a web application interface, ADF is the only solution (please correct me if I am wrong). I would prefer a stand-alone, free of proprietary API solution so that we can build a screen that is technology-independent. As ADF UI is not our only supported view technology. For example, a PHP web client should be able to interpret the BPEL process status.

    Will really appreciate your suggested solution.

    Thanks and regards,
  • 4. Re: Checking for status of a long-running BPEL process
    veejai24 Pro
    Currently Being Moderated
    If you want just to know whether the process got completed or not ? you can make use of the MDS database tables.

    You can have your own query which will tell you the flow with the interfaces involved in it and it will show you the status as well.

    http://www.albinsblog.com/2012/02/oracle-soa-11g-important-sql-queries-to.html

    Otherwise we can have a java application which is collecting all those required information in your bpel and with that help we can build a web application.

    We need to consider about the performance of the main process as we will be using lots of variables, irrespective of whether its failure or success.
    We have to have block which mark all the variables null before exiting the process.

    Thanks,
    Vijay
  • 5. Re: Checking for status of a long-running BPEL process
    Nghia Pham Newbie
    Currently Being Moderated
    Thanks everyone for the ideas, I really appreciate.
    We have designed our own approach, in our architecture, after BPEL invokes a service endpoint, the endpoint will update a few dedicated database tables. By emulating asynchronous invocation using Java thread (1 thread to invoke synchronous BPEL process, 1 thread to keep polling the database for displaying to the users). When the response from BPEL arrives in 1 thread, we notify (using callback) the other thread to stop polling and direct users to result page. This approach is API independent and it can support any type of client. The rationale is instead of hooking into SOA database, we 'd rather extend our own database to support the approach.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points