mapping transformation error

[Former Member]

I am getting following error in runtime analysis while i am trying to receive data through file adapter :

com.sap.aii.utilxi.misc.api.BaseRuntimeExceptio

thrown during application mapping

com/sap/xi/tf/_abb2_mm_: RuntimeException in

Message-Mapping transformatio~

[Former Member]

I sending csv file format from source. I got inbound payload as follows:

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

- <ns:sr_mt xmlns:ns="http://abb2.com">

- <STUDENTS>

- <STUDENT>

<NAME>karhtik</NAME>

</STUDENT>

- <STUDENT>

<NAME>ece</NAME>

</STUDENT>

- <STUDENT>

<NAME>100</NAME>

</STUDENT>

</STUDENTS>

</ns:sr_mt></b>

[Former Member]

and what happend when you test this payload with your mapping.

Than you should get the error why your mapping always crashes.

Regards,

Robin

[Former Member]

The mapping test probably works fine, because at that point, you really should have an XML document.

The problem is the content conversion inside the file adapter.

Here, a csv-like file is needed, but the thread opener uses an XML file.

The content conversion is needed to transform a file such as

karhtik
ece
100

to the shown XML structure for further processing. But when the input file already IS an XML document, no content conversion is needed/possible.

Regards,

Dennis

[Former Member]

when he said the inbound structure i guess that is the document after content conversion in the file adapter.

Because he said source file is a csv.

But he is posting this xml.

So i start to confusing...

[Former Member]

Ok, you could be right about this. Now I'm confused as well.

What we'd like to have for error analysis:

1. The contents of the original file, just as it rest on the disk.

2. The payload of the message that leaves the file adapter.

[Former Member]

Task is:<b> flatfile to xml</b>My task is i need to move flat file from source to target as xml.

[Former Member]

When i look at you posted message it looks like that your sourefile is no flatflile, its an xml message.

you can't use content conversion when you have xml tags in the message.

Regards,

Robin

[Former Member]

Could you post the exact contents of the file you read in?

That would help identifying the exact source of the problem...

I guess you've looked at the example in "Converting File Content in a Sender Adapter" of help.sap.com:

http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

While technically correct, this example is quite misleading.

For content conversion, you should use a csv-like input file.

Example:

Last name;First name;Age;Course;Fees
Smith;John;23;computer science;200 
Miller;Allan;27;art;150

Then, you convert

- entry 1 to last name

- entry 2 to first name

- entry 3 to age

- entry 4 to course

- entry 5 to fees

[Former Member]

I am using file content conversion as a message protocol.

[Former Member]

Hi,

than stop doing this. use "File"

Regards,

Robin

[Former Member]

i am attaching following inbound message as follows i.e before mapping:

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

- <ns:sr_mt xmlns:ns="http://abb2.com">

- <STUDENTS>

- <STUDENT>

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

</STUDENT>

- <STUDENT>

<NAME><ns0:sr_mt xmlns:ns0="http://abb2.com"></NAME>

</STUDENT>

- <STUDENT>

<NAME><source></NAME>

</STUDENT>

- <STUDENT>

<NAME><NAME>100</NAME></NAME>

</STUDENT>

- <STUDENT>

<NAME><AGE/></NAME>

</STUDENT>

- <STUDENT>

<NAME><COURSE>eee</COURSE></NAME>

</STUDENT>

- <STUDENT>

<NAME><FEES>223</FEES></NAME>

</STUDENT>

- <STUDENT>

<NAME></source></NAME>

</STUDENT>

- <STUDENT>

<NAME></ns0:sr_mt></NAME>

</STUDENT>

</STUDENTS>

</ns:sr_mt></b>

[Former Member]

hi,

Copy this payload in to test tab of mapping and check what is the error.

Regards,

Sudheer.

[Former Member]

Hi,

your xml isn't well formed.

There are a lot of tags which are not closed.

for example:

<NAME><ns0:sr_mt xmlns:ns0="http://abb2.com"></NAME>

<NAME><source></NAME>

And its looks like you read a xml file with adapter... why you do content conversion?

It looks that you want to read one student for each row.

But your source document is an xml file.

That why your input message looks so strange.

Try to read a .txt file with content like:

Marry

Bob

Paul

Jean

Or shut down the content conversion. And read the XML.

Regards,

Robin

[Former Member]

YOur xml is not valid,

You should not have 2 namespaces.

can you try to save this xml and open with IE ,it will not open it will give error.

[former_member206604]

Hi,

The XML is not well formed... what is the type of mapping that you are usingmake sure it is done properly.. check out the bold below

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

- <ns:sr_mt xmlns:ns="http://abb2.com">

- <STUDENTS>

- <STUDENT>

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

</STUDENT>

- <STUDENT>

<b><NAME><ns0:sr_mt xmlns:ns0="http://abb2.com"></NAME></b>

</STUDENT>

- <STUDENT>

<b><NAME><source></NAME></b>

</STUDENT>

- <STUDENT>

<NAME><NAME>100</NAME></NAME>

</STUDENT>

- <STUDENT>

<b><NAME><AGE/></NAME></b>

</STUDENT>

- <STUDENT>

<NAME><COURSE>eee</COURSE></NAME>

</STUDENT>

- <STUDENT>

<NAME><FEES>223</FEES></NAME>

</STUDENT>

- <STUDENT>

<b><NAME></source></NAME></b>

</STUDENT>

- <STUDENT>

<b><NAME></ns0:sr_mt></NAME></b>

</STUDENT>

</STUDENTS>

</ns:sr_mt>

I would say the whole XML is not proper...

Regards,

Prakash

[Former Member]

I am getting the following error in runtime and can anyboby tell hoe can change the mapping program, it is auto generated one:

<b><?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/_abb2_mm_</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/_abb2_mm_: RuntimeException in Message-Mapping transformatio~</SAP:Stack>

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

</SAP:Error></b>

[Former Member]

Hi,

Copy the input payload you get in moni in the test tab of message mapping and check if it works fine. I think this should solve your problem.

Regards,

Sudheer.

[Former Member]

Can you please post the inbound payload from SXI_MOnitor.

The one which you have posted is after mapping.

Thanks,

Tuhin

[Former Member]

what does it mean autogenerated? Probably you are sending wrong input.

Regards,

wojciech

[Former Member]

I am not <b>getting any error while testing the mapping in the testing tab</b> but while data has been picked up by intergration engine it is not recevied by recevier. When i am checking runtime workbench i am getting the following error:

com.sap.aii.utilxi.misc.api.BaseRuntimeException

thrown during application mapping

com/sap/xi/tf/_abb2_mm_: RuntimeException in

Message-Mapping transformatio~

[Former Member]

Hi,

Can you post the message which i generated from the file Adapter?

The message from sxmb_moni before the mapping is executed.

Regards,

Robin

[Former Member]

Karthikeyan,

Have you tested the mapping asper the blog I reffered above?? Do it. Either your mapping program is wrong or you have wrong source payload..

Regards,

Jai Shankar.

[Former Member]

Hi,

Please download your incoming message from SXI_MONITOR transaction and test it in test tool in message mapping. It looks like an error in mapping.

Regards,

Wojciech

[Former Member]

hi,

did you set a namespace in the message?

how looks the message which goes into the message-mapping?

Regards,

Robin

[Former Member]

Hi,

/people/michal.krawczyk2/blog/2005/09/16/xi-how-to-test-your-mapping-in-real-life-scenarios

Regards,

Jai Shankar.