Proxy to JDBC synchronous scenario

[Former Member]

Hi Exeperts,

         we are going to test proxy to Jdbc synchronousscenario in test system from ECC side we triggered data but in PI test system we are are getting log version in SXMB_MONI and we are getting empty response from receiver system and ECC we are getting error like http response 500 internal server error. what could be the problem we are facing. i have take the request payload and go to RWB-> IE -> Test but we are getting Error While Sending Message: 500 Internal Server Error. please provide inputs to resolve the issue.

Regards,

Sanjay.

[MichalKrawczyk · Accepted solution]

Hi,

enable logging of sync messages - logging_sync parameter on IE

to see if you receive any data back from JDBC call

you can also enable sync logging on the adapter engine to see the same

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

Hi Michal,

      Thanks for quick reply we are enabling the logging_sync parameter on IE. we are not getting any felid values from JDBC.

       we are not getting any filed names also we are getting message type unde root node thats it.

Regards,

Sanjay.

[baskar_gopalakrishnan2]

> and we are getting empty response from receiver system

Few cents.. You first check the following.

a) See whether your jdbc request inbound data structure is valid.  See any error message you see in the communication channel. Are you using SP or standard sap jdbc message structure?

b) You are not getting response from the target system.

Remember the rules..

if your target request structure is okay then you have to see the response jdbc target structure too..

example: if your request structure is

MT_ABC  then the response structure is  MT_ABC_response.

See whether your response jdbc structure is designed to receive the response properly. Basically the problem could be in the response side from jdbc.

c) You can also use toad or some database client tool and test the query and see what response you get from DB. THis test you can do it outside PI.

d) You can use logSQLStatement parameter in reciver channel and set the value true.

Hope that helps

[rajasekhar_reddy14]

Hi Sahoo,

There are multiple resons to get this error.

First check JDBC receiver channel status and see response message from JDBC. I think reponse not came from DB system.

Share request data wirh DB team and ask them to validate why you have not got response.

I hope you have created correct JDBC structure.

Regards,

Raj