File content conversion error

[Former Member]

Hi,

I am doing this scenario according to Sravya's instructions (Pls see the comment )

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

I am getting following message in Adapter monitor

Sender communication channel error:

Initialization error: Conversion initialization failed with java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found:

Format error in 'xml.recordset' argument: incomplete structure (name,number) pair

what is this error ?

Thanks,

ss

[Former Member]

SS,

The error what it is states is the error in your communication channel. But what sravya is telling about the mapping issue. These two are different approaches to identify your issue.

First of all do you see the message in SXMB_MONI. If yes then we can see the mapping else first we have to see the sender communication channel.

Can you please give your message type and file content conversion parameters you have specified for further help?

---Satish

[Former Member]

Thanks Satish for your reply

Message types are same as mentioned in the link

My INPUT MT:

My CG_INPUT_MT

TOTALSET 0...unbounded

ITEMSET 1

MY Output MT:

CG_OUTPT_MT

ITEMSET 0.....unbounded

ITEM 0...unbounded

File content conversion parameters:

-

---

Document Name: CG_INPUT_MT

Document Namespace:-------

RecordsetName: TOTALSET,*

Recordset Structure: Ascending

Name value

TOTALSET.fieldnames ITEMSET

ignoreRecordsetName true

TOTALSET.fieldSeparator 'nl'

Thanks,

ss

[Former Member]

Hi,

Do you see your message in SXMB_MONI or not? If not can you please give the file contents what you are trying to read into XI.

---Satish

[Former Member]

Hi Satish,

In sxmb_moni

I am getting " No messages available for selection"

<b>My File Contents are:</b>

Books, CD, Video, Games

CD, Games, DVD

DVD, CD, Video, Games, Books

Books

CD, DVD

Thanks,

ss

[Former Member]

Hi ss,

When i observed your MT (Message structure) and the parameters in the CC are having some problem.

See if you have specified the strucutre like:

CG_INPUT_MT--Document name

TOTALSET 0...unbounded-root node

ITEMSET 1-node

Please make the fields in the below ITEMSET1

you can use any field names according to your requirement.

Then you should follow the cc parameters like this.

Sender Communication channel.

Document Name: CG_INPUT_MT

Document Namespace:-------

RecordsetName: TOTALSET,*

Recordset Structure: Ascending

Name value

TOTALSET.fieldnames--->Please enter the filed here for the TOTALSET

TOTALSET.fieldSeparator--->,(use comma here) bcz in your sender file having the values by separated by comma

TOTALSET.endSeparator--->'nl'

ignoreRecordsetName true

You try by implementing like this....If you have any problems please let me know so that i can reach you out to resolve your problem

Thanks and Regards,

Chandu.

[Former Member]

Hi Chandu,

Thanks Chandu. Sorry for the delayed reply,

<u><b>In My Message Mapping</b></u>

<b>my Source MT is</b>

CG_INPUT_MT----1

TOTALSET---o to unbounded

ITEMSET---1

I have set the context of ITEMSET to CG_INPUT_MT

<b>My Target MT</b>

CG_OUTPUT_MT----1

ITEMSET---0 to unbounded

ITEM---0 to unbounded

Mapping details

-

---

TOTALSET------>ITEMSET

ITEMSET------->ITEM

<b>In Test Tab</b>

Source XML

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

<ns2:CG_INPUT_MT xmlns:ns2="http://FCC_Unequal_Number_of_Columns.com">

<TOTALSET>

<ITEMSET>Booke</ITEMSET>

<ITEMSET>CD</ITEMSET>

<ITEMSET>Video</ITEMSET>

<ITEMSET>Games</ITEMSET>

</TOTALSET>

<TOTALSET>

<ITEMSET>CD</ITEMSET>

<ITEMSET>Games</ITEMSET>

<ITEMSET>DVD</ITEMSET>

</TOTALSET>

<TOTALSET>

<ITEMSET>DVD</ITEMSET>

<ITEMSET>CD</ITEMSET>

<ITEMSET>Video</ITEMSET>

<ITEMSET>Games</ITEMSET>

<ITEMSET>Books</ITEMSET>

</TOTALSET>

<TOTALSET>

<ITEMSET>Books</ITEMSET>

</TOTALSET>

<TOTALSET>

<ITEMSET>CD</ITEMSET>

<ITEMSET>DVD</ITEMSET>

</TOTALSET>

</ns2:CG_INPUT_MT>

<b>But In Result I am Getting as</b>

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

<ns2:CG_OUTPUT_MT xmlns:ns2="http://FCC_Unequal_Number_of_Columns.com">

<ITEMSET>

<ITEM>Booke</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>CD</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>Video</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>Games</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>CD</ITEM>

</ITEMSET>

</ns2:CG_OUTPUT_MT>

<u><b>I am suppose to get as</b></u>

<ns2:CG_OUTPUT_MT xmlns:ns2="http://FCC_Unequal_Number_of_Columns.com">

<ITEMSET>

<ITEM>Books</ITEM>

<ITEM>CD</ITEM>

<ITEM>Video</ITEM>

<ITEM>Games</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>CD</ITEM>

<ITEM>Games</ITEM>

<ITEM>DVD</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>DVD</ITEM>

<ITEM>CD</ITEM>

<ITEM>Video</ITEM>

<ITEM>Games</ITEM>

<ITEM>Books</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>Books</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>CD</ITEM>

<ITEM>DVD</ITEM>

</ITEMSET>

why I am getting like this

Thanks,

srinivas

Message was edited by:

srinivas

[Former Member]

any help ?...

Message was edited by:

srinivas

[Former Member]

Hi Srinivas,

What i hv understood is ur sender structure is Wrong...

It should be like

<documentName >.........MsgType Name

<recordset>.................RecordSet

<NameA>............................Row

<field-nameA1>field-value</field-nameA1>.....ITEMSET in ur case

<field-nameA2>field-value</field-nameA2>

<field-nameA3>field-value</field-nameA3>

</NameA>

</recordset>

</documentName >

Also the content conversion parameters should be as:

Document Name -

---

MsgName_MT

RecordSet Name-- Recordset

..

...

..

NameA.fieldSeperator

NameA.FieldLimiter.

NameA.FixedFieldLength.....

....

Refer the following link;-

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

This solves ur problem

Regards,

Ashwin M

Reward If helpful