BPM build for asyc to sync to async scenario

[Former Member]

Hi ,

I have a scenario where

1. abap proxy triggers and sends no of records and sequence id...

2. i'l update the JDBC recvr

3.the JDBC sends an acknowledgement no of records updated.

kindly help how to build a BPM for this scenario to compare the no of records .. so that i'l be sending the sequence ID back

via another async proxy...

plz help me in the build

[Former Member · Accepted solution]

Hi Robin,

You can have this approach in your BPM:

Receive (get the proxy data) --> Send (Sync step where you have done mapping from proxy to jdbc requst and then response to response itself) --> switch (compare your original sequence id with the response from jdbc) --> if true tehn send step within the block to send teh response back to proxy or if false then goes to otherwise branch and tehn you may need to write a file or send a mail stating the mismatch.

You can use this weblog for jdbc sync steps in your BPM.

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

Regards,

---Satish

[Former Member · Accepted solution]

HI Satish thanks for ur response,

designed my scenario like this:

recv step(recv msg)->send sync(jdbc request and response)-> transformation step(comparing the record nos ..another Operation mapping used where i'l b comparing the two record count jdbc and proxy) if true goes to send step if false throws an exception...if true in send step (i'l b passing recv msg again)

Satish how do i compare in " switch " the record count of proxy and JDBC .. if u can elaborate a bit

[former_member200962 · Accepted solution]

Satish how do i compare in " switch " the record count of proxy and JDBC .. if u can elaborate a bit

This comparison should be done in a mapping program.....AFAIK you cannot do such a comparison in a Switch Block....

Introduce a mapping (2:1....proxy and JDBC resp on source and some structure in the target).....in this mapping compare the Sequence ID from Proxy with that from JDBC response.....if both match then make the target element as "X"...if does not match then make the target element as "Y"......now based on the value (X/ Y) define the condition accordinlgy in your Switch......

If the value is X then it should mean that the both the Sequence IDs are same and then have the Send step in the corresponding branch....

If the value is Y then the values do not match....then execute the otherwise branch.

Regards,

Abhishek.

[Former Member]

Robin,

Also worth watching this thread:

Regards,

---Satish