This content has been marked as final. Show 7 replies
I configured an outbound ,triggering from SOA where required sender id(TP B) and receiver id(TP A) are set using B2B properties. I also configured 2 agreements in B2B i.e. TP B--> Host and Host-->TP A. When i test the outbound transcation I only get one instance (Host-->TP A) in B2B. How I can identify or correlate in B2B from which TP transaction has initiated.
To send a message from TPB to TPA via a hub (say TPC), you should start the transaction from instance where TPB is host. Set the sender and receiver information and send it to TPC. Then TPC will act as a hub and forward it to TPA automatically.
At the hub, you may query the transaction on the basis of transaction control number and you will come to know from where transaction came and to which TP it was routed.
Here is my scenario
TP A (Amazon) sends PO to a division of Host, say D1. So we have configured D1 as a TP, say TP B. There is a forward agreement defined between Host and TB B
So PO comes from TP A -> Host. And it's forwarded to TP B automatically (based on the fwd agreement)
Is it the way you recommend or something different.
Based on the above config. we have two concerns
1) Since for each transaction there are two messages, how do we correlate based on the transaction control number, do you have the SQL?
2) if we want to get a single row returned based on certain PO number, how do we extract the transaction control number based on PO number?
Is it the way you recommend or something different.Yes, this is what I suggested.
1) Since for each transaction there are two messages, how do we correlate based on the transaction control number, do you have the SQL?You may get the transaction control number from TP A. Now use below query to find out both the transactions at your host (hub) -
SELECT * FROM B2B_INSTANCEMESSAGE WHERE TRANSACTIONCONTROLNUMBER = '12345';
where 12345 is transaction control number
2) if we want to get a single row returned based on certain PO number, how do we extract the transaction control number based on PO number?You can ask TP A to provide transaction control number or you can query at TP B side on the basis of PO number (if you are using XPath functionality) to get the transaction control number. Once you get the transaction control number, you may use the same to query transactions at your hub (host) using the SQL I provided above.
I fallowed your blog for B2B hub
In my scenario INDIA(Host), USA and UK are (TPs), i am trying to send HL7 message from USA to UK throw INDIA.
I placed file in INDIA(Host) listening channel with file format %USA%,%UK%,%2.3.1%,%ADT_A01%.hl7 and added identifiers in sample message which you are given in blog.
I fallowed all steps from your blog but i am unable to send USA to UK, i am not getting any reports in reports tab.
please suggest me on this.
Thanks in advance.
Edited by: 915225 on Mar 11, 2013 11:01 PM