SAP PI JDBC Receiver Adapter Response

[former_member558737]

Hi Team,

I am configuring RFC --> PI --> JDBC (receiver) synchronous scenario with SELECT query. I have followed the steps mentioned in blogs below and configured the artefacts (including the naming convention) accordingly. However, the JDBC response is not returning the results. I have verified the communication channels and log looks green but no results returned.

I wonder if there is an option view response log of JDBC result, just like how payload (request) can be seen.

https://blogs.sap.com/2006/07/03/jdbc-receiver-adapter-synchronous-select-step-by-step/

https://blogs.sap.com/2017/11/10/sap-pi-proxy-to-jdbc-scenario/

Thanks,

Sekhar

[PavanKumar]

Hi Sekhar,

Assuming you have configured ICO, To see the log of synchronous messages

1) Go to advance settings tab in Integrated configuration object and enabling the logging i.e enable use specific configuration

and enable the log for Receiver determination and Mapping. Please refer below link

https://blogs.sap.com/2012/11/06/message-staging-and-logging-options-in-advanced-adapter-engine-of-p...

2) If you are receiving the empty payload as response, then make sure that the naming convention should be as like below

If Jdbc request Message type is MT_receiver then

response Message type from DB look like MT_receiver_response

Regards

Pavan