XML Payload Response Syn scenario not comming

[AntonioSanz]

Hi all,

I am working in a SOAP-->JDBC syncronous scenario. I am doing an INSERT into a JDBC data base. I am able to do the insert, but I can not map de response message from data base. I get a Mapping error. I guess that this error is due to my definition of the data type of the JDBC response.

I've gone to SXM_MONI but I can not see the payload of the JDBC response.

I have tried with JDBC channel I can not see the xml message.

Does anybody knows what can be happening???

Many thanks.

[Muniyappan · Accepted solution]

Hi,

did you select the Qos as Best Effort in sender channel?

can you please paste your error message here?

Regards,

Muni.

[AntonioSanz · Accepted solution]

Yes I am using Best Effort

My error is

- <SAP:Error SOAP:mustUnderstand="1" xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">

<SAP:Category>Application</SAP:Category>

<SAP:Code area="MAPPING">EXCEPTION_DURING_EXECUTE</SAP:Code>

<SAP:P1>com/sap/xi/tf/_MM_CREACION_MENSAJES_WHATSAPP_TO_J~</SAP:P1>

<SAP:P2>com.sap.aii.mappingtool.tf7.IllegalInstanceExcepti</SAP:P2>

<SAP:P3>on: Cannot create target element /ns0:MT_CREACION_</SAP:P3>

<SAP:P4>MENSAJES_WHATSAPP_RES/MENSAJES. Values missing in~</SAP:P4>

<SAP:AdditionalText />

<SAP:Stack>Runtime exception occurred during application mapping com/sap/xi/tf/_MM_CREACION_MENSAJES_WHATSAPP_TO_J~; com.sap.aii.mappingtool.tf7.IllegalInstanceException: Cannot create target element /ns0:MT_CREACION_MENSAJES_WHATSAPP_RES/MENSAJES. Values missing in~</SAP:Stack>

<SAP:Retry>N</SAP:Retry>

</SAP:Error>

I think my DT is not according to the data JDBC is sending me, but i can not validate because I dont see at SXMB_MONI

[Muniyappan · Accepted solution]

Hi,

First check the input. take the payload from sxmb_moni and test the same in message mapping.

if it works fine then you have issue with your response.

This error tells that some mandatory fields are missing in the message.

Cannot create target element /ns0:MT_CREACION_MENSAJES_WHATSAPP_RES/MENSAJES. Values missing in

Regards,

Muni.

[Former Member · Accepted solution]

Hello,

Remove response message mapping from OM and then execute ur scenario?

I think u will get JDBC response message in moni? and once u get the same then u can alter ur response structure in PI

Thanks

Amit Srivastava

[AntonioSanz · Accepted solution]

GOOD TRICK. Now I can see the response in SOAPUI !!!

Many thanks Amit !!!

[Former Member · Accepted solution]

Welcome