Mapping error

[Former Member]

Sender JDBC Structure:

JDBC Complex type

EMP_DET element 1tounbounded(MT)

EMPID element 1..1

ENAME element 1.1

CITY element 1.1

COUNTRY element 1.1

Receiver File

File Complex type

EMP_DET element 1tounbounded(MT)

EMPID element 1..1

ENAME element 1.1

mapping

EMP_DET->EMP_DET

EMPID ->EMPID

ENAME ->ENAME

Error description in MONI

<?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="">

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

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

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

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

<SAP:P3>RuntimeException in Message-Mapping transformatio~</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/_JDBC_TO_FILE_: RuntimeException in Message-Mapping transformatio~</SAP:Stack>

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

Kindly let me know wht the problem is.

Thanks,

Srinivasa

[Former Member]

Hi ,

In SXMB_MONi select your message payload and right click and save that msg as say " test.xml" and then go to your message mapping test tab and pass this as input parameter set the trace level as "DEBUG " you will be able to see the problem .

Thanks ,

Suvarna

[Former Member]

Extract the XML from sxmb_moni and run it through Message Mapping on IR.

This should give you the field that is failing.