Payload error

[Former Member]

Hi...

I am doing soap to JDBC to soap Scenario. In that, the request mapping is working fine. But the response mapping, i am having the error.

The below is the response structure of the jdbc

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_StoredProcedure_response xmlns:ns0="http://InvoiceProcessing">

<Statement_response>

<row>

<InvocieId/>

</row>

</Statement_response>

</ns0:MT_StoredProcedure_response>

But in the payload of thecall adapter, it is showing the below message.

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

-

---

A name was started with an invalid character. Error processing resource 'file:///C:/Documents and Settings/lm49390/Local Se...

<>38</>

---^

Could you please help why the empty braces are there?

Thanks and Regards,

Leela

[Former Member · Accepted solution]

HI Leela

XML paylaod cannot be shown is ok

it can happen if the paylaod is not proper XML.

What the paylaod in RWB. Is the data in response correct ?? Check and let us know

In SXMB_MONI is the message failed?

Thanks

Gaurav

[Former Member · Accepted solution]

The response data is correct. In moni, it is showing the error message.

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Request Message Mapping

-->

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

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

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

<SAP:P1>com/sap/xi/tf/_MM_Invoice_</SAP:P1>

<SAP:P2>com.sap.aii.utilxi.misc.api.BaseRuntimeException</SAP:P2>

<SAP:P3>Fatal Error: com.sap.engine.lib.xml.parser.Parser~</SAP:P3>

<SAP:P4 />

<SAP:AdditionalText />

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack>com.sap.aii.utilxi.misc.api.BaseRuntimeException thrown during application mapping com/sap/xi/tf/_MM_Invoice_: Fatal Error: com.sap.engine.lib.xml.parser.Parser~</SAP:Stack>

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

</SAP:Error>

Thanks & Regards,

Leela

[Former Member · Accepted solution]

HI

The problem is with the response message XML. Check using the response in Mapping test. Which field is having issue.

Thanks

Gaurav

[SudhirT · Accepted solution]

Hi,

It seems there is some problem in mapping. try to test your mapping with the payload. also check if the green circle in mapping editor test tab goes red after loading your payload, then there is some mismatch with the structure too.

Thanks!

[Former Member · Accepted solution]

Hi Gaurav,

I have tested the Resposne mapping in the Test mapping. There it is working fine. Can you please log on to the communicator

Regards,

Leela

[Former Member · Accepted solution]

Hi Sudhir,

After loading the payload. it is showing green color node only.

The below payload from the call adapter, i have pasted in the response mapping.

?xml version="1.0" encoding="utf-8"?>

<ns0:MT_StoredProcedure_response xmlns:ns0="http://InvoiceProcessing">

<EXECUTE_response>

<response_1>

<update_count>1</update_count>

</response_1>

<response_2>

<row>

<>38</>

</row>

</response_2>

</EXECUTE_response>

</ns0:MT_StoredProcedure_response>

While testing the mapping, it is showing the below error.

Fatal Error: com.sap.engine.lib.xml.parser.ParserException: Name expected: 0x3e(:main:, row:9, col:4)

for the field 38, the filedname "InvocieId" is missing.

Regards,

Leela

[Former Member · Accepted solution]

Hi leela,

I thing you created one more element(InvocieId) under the row.you mapped that filed to target invoiceid.

change the source structure remove the invoice id and map the row filed to invoiceid if you get the invoice id value in the row field.

Regards,

Prakasu

Edited by: prakasu on Nov 14, 2008 7:00 AM

[SudhirT · Accepted solution]

Yes,

It seems related to InvoiceID field, check for necessary mapping as said above. If it is missing that means the target InvoiceID field is not getting populated. Plase Check.

[Former Member]

Hi friends, Thanks for your replies. The Problem is with the Stored Procedure. First it is returning only the feild value not the feild name. Now i have changed the stored procedure. After that it is working fine.