REST To JDBC Scenario

[Former Member]

Hello Experts

.

We have a scenario where we are sending data synchronously from REST To JDBC.

We had developed a scenario initially and that is functioning with no problems.

Now we have developed one more scenario by replicating the working scenario and we are using a different end point in the sender REST Channel.

We are testing the scenario using a REST client and we are able to send the request successfully to JDBC,but we are not getting the data response .

We are getting data response as " " in REST client

Few observations

I am not seeing the response payload from JDBC in SAP PI.

I am not able to see the payload of request REST xml in message monitoring.

In JDBC the response is generating but not able to see the response structure in SAP PI.I have checked both the request and response mapping in IR and it is correct.

Please also note that the message status in SAP PI monitoring is delivered.

Please help on this.

Please let me know if any more details is required.

Regards

Advit

[Former Member · Accepted solution]

The issue is resolved.

The problem was with the response Message from JDBC.

http://scn.sap.com/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select...

My message type was MTI_Get_Product_list_DB_response_WS_PC

but it should be  MTI_Get_Product_list_DB_WS_PC_response.

Once I changed it, the scenario worked.

Regards

Advit Ramesh

[former_member186851]

Advit,

Compare all the parameter between the ICOS.

Also get the payload from PI and test the same in Rest client and check.

[manoj_khavatkopp]

Ramesh,

Addition to the above link see you have setting enabled to see payload for synchronous message.

Br,

Manoj

[Former Member]

I am working on SAP PI 7.4 single stack

[manoj_khavatkopp]

Its the same procedure check once

[iaki_vila]

Hi Advit,

Are you sure that in your ICO object you have activated the log ?

Regards.