Skip to Content

SAP PI JDBC Receiver Adapter Response

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 23 at 05:37 AM

    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-pi-73x/

    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

    Add comment
    10|10000 characters needed characters exceeded