Mapping error - Flat file to Flat file Scenario

[Former Member]

Hi All,

Iam designing Flatfile to Flatfile Scenario.

Source Structure

RSET

RSETSTRUCTURE 1-un

S1 1-1

S2 1-1

S3 1-1

target Structure

RSET

RSETSTRUCTURE 1-un

R1 1-1

R2 1-1

R3 1-1

Mapping

RSETSTRUCTURE - RSETSTRUCTURE

S1 - R1

S2 - R2

S3 - S3

Flatfile is getting picked

Iam getting Mapping exception.

Please help.

Regards,

Jeevan

[justin_santhanam · Accepted solution]

Jeevan,

In SXI_Monitor open ur message. Now expand the Inbound message, choose the payload from ther and test it in ur message mapping ,we can anayze it . If u can , paste the inbound payload over here, so that we can suggest..

raj.

[Former Member · Accepted solution]

Hi Raj,

Iam sending the Inbound payload

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

- <ns:MT_DB2_S_FF xmlns:ns="http://gsll.com/DB2">

- <RSETSTRUCT>

<S1>A</S1>

<S2>A</S2>

<S3>A</S3>

</RSETSTRUCT>

- <RSETSTRUCT>

<S1>B</S1>

<S2>B</S2>

<S3>B</S3>

</RSETSTRUCT>

</ns:MT_DB2_S_FF>

regads,

Jeevan

[justin_santhanam · Accepted solution]

Jeevan,

where is the RSET element?

raj.

[Former Member · Accepted solution]

Hi Raj,

I have used

ignoreRecordsetName = true.

regards,

[justin_santhanam · Accepted solution]

Jeevan,

That's fine. So u mean ur source structure of mapping looks like

<RSETSTRUCT>

<S1>A</S1>

<S2>A</S2>

<S3>A</S3>

</RSETSTRUCT>

is it? there is no RSET element i ur source mapping strucure, am I right? Next thing, in ur payload there is namespace right? Now open the Message type and check whether it's the same..

raj.

[nisarkhan_n · Accepted solution]

Since you have the XML generetaed from your file adapter take this adn refer with tht one that is expecting in the MT u have created both should be sam, in your case its not....

goto the MMtesttabtake the XML view check how the XML should be ( emoty one dnt put any data from payload)..refer this with the XML which you have pasted above you will find the differnece and solution also,,,,,,,,

[Former Member]

hi

plesae test ur mapping in message mapping . if you are using content conversion then check your communication channel.

regards

Kasturika