Getting response as null in soap to jdbc scenario

[Former Member]

Dear All,

I have a  soap to jdbc synchronous scenario,where i am sending some details to thirdparty which get updated  at their end through stored procedure,but while i am getting the response as blank.can you please suggest how can i resolve this and also what should be structure of response datatype in soap to jdbc scenarios.

Thanks ,

Sonalika

[Former Member · Accepted solution]

Hi,

I have tried all these and getting response as blank...plz check the below screenshot and suggest:

My Mapping part in Request site is as follows:

I am getting error in  response as follows:

Please suggest.

[ambrish_mishra · Accepted solution]

Hi Sonalika,

You are getting a mapping exception which means your response structure and payload does not match. copy the payload in your test tab and see what the disparities are. This disparity is not allowing for target structure population.

Else paste the response payload here....

Hope it helps!

Ambrish

[iaki_vila · Accepted solution]

Hi Sonalika,

Try to map for example the function constant, with an empty value, to the target field MT_SendCINDetailsReqNew.

Regards.

[Former Member · Accepted solution]

Hello,

Are you sure that SP is working fine?

Having said that, remove "response_1" node from the response structure and then check?

Thanks

Amit Srivastava

[Former Member · Accepted solution]

Hi,

Thanks to all for your valuable replys.My issue has been solved.My response structure was wrong.i mean to say there were disparities between  response structure and payload.I designed it accordingly.

Thanks,

Sonalika

[ambrish_mishra]

I think I responded to this query in another similar post. http://scn.sap.com/thread/3419574

[Former Member]

Hello,

I think the structure which you have created for receiving response from JDBC is not correct. Check my reply:

http://scn.sap.com/message/14285982#14285982

Thanks

Amit Srivastava

[Former Member]

Hi Sonalika,

I think there is a problem in stored procedure. Please contact with the third party vendor who is writing the stored procedure.

Thnaks,

Apu

[iaki_vila]

Hi Sonalika,

The SOAP side structure is whatever you want, you only need to use the receiver JDBC side proposed by SAP: http://help.sap.com/saphelp_nw73/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm?frameset=...

You must assure that you are using the response receiver structure that SAP is pointing. If you have the structure ok you first look at the DB is having any change. What is the DB vendor?

Regards.

[Former Member]

Hi Sonalika,

you can refer to below link for SOAP to JDBC scenario.

http://saptechnical.com/Tutorials/XI/SOAP2JDBC/Page1.htm

Regards,

Gavaksh Saxena