Alternative Regarding Parallel Action Shape in BizTalk Orchestration RRS feed

  • Question

  • Hi All,
    I have a general query regarding parallel action shape in BizTalk Orchestration.
    I have a senario where i get data from SAP and i need to transform Response SAP to SQLRequest for three stored procedure ..which i am currently doing..
    But now in one of the branch i need to call webservice..
    Just for relaibility of the system ..if by chance webservice could not be executed the non of the operations can be completed ..
    So is there any alternative for parallel shape ..where i have one input Xml and i need to call three Stored Procedure..
    without depending on any of the three operations..

    Pls Advise
    Friday, August 7, 2009 6:50 AM

All replies

  • We can use start orchestration shape if it suits your need.

    We can have a Master Orchestation which will receive the input XML.

    The three parallel actions will be in three different child orchestrations.

    The Master Orchestration will look like.

    Receive XML(message1)
    Start Child Orch 1(message1)
    Start Child Orch 2(message1)
    Start Child Orch 3(message1)

    Friday, August 7, 2009 2:17 PM
  • Hi Rohit,
    Thanks for your reply..
    Can i able to process message after parallel action shape..
    As in my case in all of the parallel branch i call stored procedure to update table..
    then in one of them i then call webservice..
    So can i use expression shape after parallel action shape.. which is used to check stored procedure response and then i call webservice..


    |                     |                         |
    call SP             callSP                  CallSP
    |                     |                         |
    ResponseSP1     ResSP2                 ResSP3
    |                     |                         |
    Expression shape(check for SP1)
    Call Webservice
    Monday, August 10, 2009 10:21 AM
  • Hi Sandeep,

    If I understand you correctly, you want to execute your stored procedures in parallel and make sure you can continue even if one of these procedures fails.
    Consider putting a listen block around your parallel block.  In one of the listen branches, place your parallel block, in the other, place a delay a little longer than the worsto=-case execution time for the sp (max of all 3).  This way, you still execute in parallel and if any of the sp fails, the delay time will run out and you will be able continue with your orchestration and place other shapes after your parallel shape.
    If it works, please mark as an answer.

    • Proposed as answer by Alex Krotov Friday, September 18, 2009 2:34 PM
    Tuesday, September 15, 2009 6:49 PM
  • Dear Sandeep,

    First put a listen shape. Beneath that, put a parallel shape in one of the branches and in the other branch call the intended web service. Below parallel shape place the branches to execute the three stored procedures. This would serve your purpose

    Wednesday, September 16, 2009 7:51 AM