How to configure a sync JDBC / RFC scenario without using BPM

[Former Member]

Hi

I use a sync outbound Message Interface and a sync inbound Message Interface to call a SAP BAPI.

Scenario

RD: DBSYSTEM | MI

ID: DBSYSTEM | MI | SAPSYSTEM

SA: DBSYSTEM | MI

RA: DBSYSTEM | SAPSYSTEM | BAPI

I can see Response and Request Message in SXMB_MONI with status: successful.

The Response message looks well; only the update of my DB does not work.

I use a JDBC Sender “best effort”.

The message comes to XI and uses my sync Interface Mapping

(Source: JDBC Request / Response à Target RFC Request / Response)

Maybe I need a further entry in my Configuration for the Response Way? (JDBC Receiver?????)

Thanks in advance

Daniel

That is the message but no adapter is interested to use this message

[Former Member]

Hi again,

i have to reopen the question beacause the customer will have the RFC response also without using sync sender inerface

History:

We have a JDBC to RFC scenario.

To update the DB we need the RFC response.

Currently (SAP XI 3.1) the RFC communication channel needs a u201Csyncu201D communication to create the response.

We know three solutions to handle such a scenario but they are not that what the customer architect like.

Using BP

Easy to create (developer side) good for monitoring but bad on performance side.

We have too many messages per hour so the big XI server got performance problems.

SAP sales slides point to XI version 7.1 that will solve the performance problem.

Is this really given?

Using JDBC communication channel with sync mode.

Also nice to develop and good for monitoring and support.

Problem: If SAP will not send a Response the whole interface is blocked and no new messages can be transferred.

Using RFC Lookup

This is well for the XI performance but for developers and monitoring it is not really up to date (told us the architect) as he checked the graphical mapping (many concats, fix XML-Tags u2026. N:1 field mapping..).

He said this is harrowing and not state of the art. (Maybe he is right

Is there a better way to develop a not u201Csyncu201D connection?

Kind regards

Daniel

[Former Member]

Hi,

There will be problem to the response from the JDBC Sender.

You can not use JDBC Sender as synchornus without BPM.

Thanks

Swarup

[VijayKonam]

As I remember from one of Bhavesh's posts in the forum, from SP16 XI 3.0 onwards, there were some modules availbe which were included in sender file channel to achieve Asyn-Sync-Asyn kind of a scenarios. Not sure if that works for JDBC too..!!

[Former Member]

This link would be helpful:

[http://help.sap.com/saphelp_nw70/helpdata/en/45/20d251c20a0732e10000000a155369/content.htm]

I think two modules RequestResponse Bean and ResponseOnwwayBean can be used here in JDBC sender.

Thanks,

Beena

[bhavesh_kantilal]

Just a small correction, This works from SP 19.

The thread link is here,

@ daniel : Like pointed Sender JDBC adapter by default does not support Synch Calls. You would need to use the modules illustrated in my thread to forward the response that comes back to the Sender JDBC to a appropriate Receiver JDBC adapter.

https://forums.sdn.sap.com/click.jspa?searchID=8242639&messageID=4482651

Regards

Bhavesh

[Former Member]

Hi all,

Thanks a lot.

I did it with success.

Solution:

Configure the JDBCSender with parameter

“best effort” and “auto commit”

Add the module AF_Modules/ResponseOnewayBean with one Key. (Parameter: receiverChannel)

For this scenario you need also a JDBCRECEIVER channel.

Add a Receiver Agreement for this Response Way and use a async Message Interface with Response MessageType.

That’s it

Another way to get RFC Response without using BPM is RFCLookup.

JDBCSender -> Mapping (RFCLookup) -> JDBCReceiver

I thin this thread is useful for a lot of XI developer. I will add my screenshots in a BLOG.

Or send an email to get my paper:

How to configure a “synchronous” Request and Response RFC scenario without using BPM.

Daniel

[Former Member]

Hi,

Can u send me the screen shots?

[Former Member]

http://www.klickklack.wg.am/RFC_Request_Response_without_BPM.doc

In case of further question you can contact me by mail.

Daniel