Skip to Content

BPM help required

Hi

scenario is from IDOC - stored procedure and based upon the response switch condition with 2 branches.

Now that in switch condition I need to check the existence and /nonexistence of 2 fields.

if field "a" exist and field "b" does not exist then update db1

if field "a" exist and field "b" exist then send mail to user

Currently i am using a transformation in BPM between the responses(dummy mapping) so that non existence for the field "b" is checked using an UDF (transform so that if field not exist then 0 anyways i check for field "a" existence in switch condition )

questions would be

1. Do I have any operator in switch condition to include non existence of field

2. Since I am doing with another transformation for response mapping(to do ths ninexistence check ) do I need to add any configuration i n ID

kindly let me know

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 12, 2009 at 08:40 AM

    Hi All ,Thanks for all ur inputs

    I have an erro rout in BPM

    scenario is IDOC--Xi----Stored proc to database1 ; bsed onthe response switch condition with 2 branches

    I get an error insend synchrnous step and BPM is stopped with system error in Moni

    BPm steps

    receive IDOC

    transformation of idoc with stored proc request

    send synchronous

    switch with 2 branches and in each branch 2 individual tranformationrouting to various receivers.

    test configuration in ID works fine .Is there somethigg wrong with my ID

    for stored procedure my configurations are

    RD-----

    Int process to DB1

    Interfce Determinatio

    Int process- sending synch abstract interface to receiver DB1 and in the inbound interface I have the same synchrouns abstract interface

    I had prirly used request message in the inbuond interface but failed

    please advise on the rght configuration

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 10, 2009 at 06:50 PM

    Do you need to map any details from the Stored procedure executed to the target structure? If not, You don't need a BPM.

    Use a Dynamic Receiver Determination to obtainer receiver1 or receiver2 based on ur condition.

    Then use interface determinations (2 Interface det in your case) to map the src to target.

    At runtime only one receiver is identfied & the corresponding Interface determination is executed.

    -SM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 10, 2009 at 05:40 PM

    Anusha,

    For question1: You can use doesnot exist and also you can build your own path.

    Check this threads for this and follow shabharish blog in this thread:

    problem-with-the-condition-editor-ex-function

    xpath-condition-to-check-if-an-element-does-not-ex

    For question2:

    You may not to do any config but in BPM you should take the sync step and do the mapping accordingly. Please follow this blog for some reference:

    /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

    Regards,

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 10, 2009 at 07:04 PM

    You can refer the thread(1) provided by Satish when you are dealing with Switch in PI7.1....

    In PI7.0, you can check the existence as normal (Field a -


    > EX; left and right operands respectively)

    To check the non-existence of a node check this WIKI section:

    https://wiki.sdn.sap.com/wiki/display/XI/XpathConditioninReceiverDetermination

    If you are working on PI7.1 then non-existence has to be checked as !(EX cond_var).

    Regards,

    Abhishek.

    Add comment
    10|10000 characters needed characters exceeded