JDBC to RFC to JDBC Synchronous Scenario

[former_member201264]

Hi Gurus,

I have done the JDBC to RFC to JDBC Synchronous Scenario using the below links but File replaced with JDBC.

http://http://wiki.sdn.sap.com/wiki/display/HOME/Using+Request+Response+Bean+Module+in+FILE+Adapter

When test the scenario, I am getting the following error in the sender JDBC Channel.

Even I did not get message into Message Monitoring.

Error occurred while sending message (GUID 751cdaff-1e83-11e2-8881-000009badcbf): com.sap.aii.adapter.xi.routing.RoutingException: InterfaceDetermination did not yield any actual interface

Log Error Screen Shot as below:

I am doing this scenario in SAP PI 7.3 version.

Will it support RequestResponseBean Module? if so what may be the cause of error.

Regards,

Sreeni.

[baskar_gopalakrishnan2]

IMHO, JDBC adapter does not support this feature.  I tried jdbc sender adapter using PI 7.1 scenario Async sync (Jdbc -RFC -> file)and did not work. I did not try in 7.3 yet. Hope you are using  setting quality of service EO in the receiver jdbc channel.

If you need receiver channel in synchronous mode then you need to use bpm only.

[MichalKrawczyk]

Hi,

>>>I tried jdbc sender adapter using PI 7.1 scenario Async sync (Jdbc -RFC -> file)and did not work.

this one should work with no issues,

Regards,

Michal Krawczyk

[former_member201264]

Hi All,

JDBC CC1 Sender to RFC to JDBC CC2 Receiver working good.

Here i used same as per this

http://http://wiki.sdn.sap.com/wiki/display/HOME/Using+Request+Response+Bean+Module+in+FILE+Adapter

but used JDBC Receiver instead of FIle.

Regrads,

sreeni.

[ambrish_mishra]

Hi Sreeni,

I used Request response bean in a file to Sync proxy to File and it worked fine. Later I replaced it with JMS to Sync Proxy to JMS when the JMS system got ready.

Here the difference is JDBC to RFC (similar to Sync proxy) to File ... I am not sure what should prevent this from working... logically.

Ambrish

[former_member201264]

Hi Guys,

I solved this issue by using RequestResponseBean and ResponseOneWayBean concept.

Regards,

sreeni.

[ambrish_mishra]

Nice!

I forgot to mention that I too had used both the beans in my scenario mentioned above.

Cheers!

[MichalKrawczyk]

Hi,

>>>I have done the JDBC to RFC to JDBC Synchronous Scenario using the below links but File replaced with JDBC.

you have asyn-sync-sync scenario and one from wiki is asyn-sync-async

so it's different one and I don't think it's supported,

Regards,

Michal Krawczyk

[former_member201264]

Hi Michal,

Thank you for realizing me.

Then please let me know the way to solve the issue.

Regards,

Sreeni.

[MichalKrawczyk]

Hi,

>>>Then please let me know the way to solve the issue.

split it:

async  jdbc -> sync RFC -> async file

second interface

async file -> sync jdbc -> async file with jdbc response

Regards,

Michal Krawczyk