MessagingException: No response available - ECC to JDBC synchronous

[vishnu_pallamreddy]

Hi All,

My scenario is ECC to JDBC synchronous.

I am getting below issue some times.

com.sap.engine.interfaces.messaging.api.exception.MessagingException: No response available

Any one please suggest me to resolve this issue.

[pvishnuvardan_reddy · Accepted solution]

Hi Vishnu,

Please check whether the DB is sending out any response or not.

It looks like PI is not receiving any response from DB.

[Former Member]

Hello Vishnu,

In my opinion, it cannot be possible to use sync scenario in the case of JDBC.

Reason is when you are have JDBC at the receiver end, you have to use a different channel config and mapping (of course) to insert/update.

Similarly when the JDBC is at the sender end (i.e. in this case response) you will need select query to fetch from the database and an update query for flagging purpose.

So the conclusion is that you have to you async scenario with the response as the receiver channel in case of sender.

Regards,

Souvik

[vishnu_pallamreddy]

Hi Souvik,

I am getting this issue not all the time.

Interface is running successfully.

some times I am getting this issue.

[pvishnuvardan_reddy]

Hi Vishnu,

Please check with your DB team whether are they sending any response for the request.

Also, pls test in non-production environment for this interface by requesting case replication if issue doesn't persist in non-production.

[former_member186851]

Hello Vishnu,

Is it a sync scenario?

Check your payload once

[vishnu_pallamreddy]

Hi Raghu,

yeah synchronous.

No receiver payload.

in receiver message it is showing No response available.

[former_member312864]

Please go through below link

https://scn.sap.com/thread/3598496

Kind Regards,

Sarojkanta Parida

[former_member186851]

May be then for the particular request data no response might be available..

is it failing all the time?