Error whil doing File Content Conversion

[Former Member]

Hi all,

I had configured a sender for File Content Conversion and I am getting the follwoing error.

Sender Adapter v1014 for Party '', Service 'bs_xml_sender':

Configured at 05:39:05 2007-04-27

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.

Any ideas why I am getting this error.

[Former Member]

HI,

please change your structure,sender and receiver also,

it should be under one root , but in your structure , please check in data type

is it similar to below

Root -

---

0..unbound

record set.....................(Optional)

PONUM...0.1

POQTY ...0..1

POAMT..0.1

here may not be the root , you can use any name... but under one strucure

Regards

chilla

recordset.fieldNames PONUM,POQTY,POAMT

recordset.fieldSeperator ,

recordset.processConfiguration FromConfiguration

if you are not using recordset , then replace it root in above parameters

Regards

Chilla

[Former Member]

Ok Here is my source structure which I have copied directly sxmb_moni

- <ns:mt_sender xmlns:ns="http://xml2xml">

- <Recordset>

- <Row>

<PONO>"25"</PONO>

<POQTY>"12"</POQTY>

<POAMT>"35.67"</POAMT>

</Row>

</Recordset>

</ns:mt_sender>

Now tell me what is the DocumentName and what is the RecordSetName and RecordSet Structure I need to give in order to make it work. Hopefully this will end the thread.

[Former Member]

>>Now tell me what is the DocumentName and what is the RecordSetName and RecordSet Structure I need to give in order to make it work. Hopefully this will end the thread

DocumentName : mt_sender

RecordSetName : do not enter any value.

RecordSet Structure : Row,*

Regards,

Jai Shankar

[Former Member]

Hi,

All you mentioned parameters are correct , and add the below

ignoreRecordsetName : true to above given parameters

Please check the structure also with above given parameters .

http://help.sap.com/saphelp_nw2004s/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards

Chilla

[Former Member]

Hi ,

Now the fiel is getting picked up but SXMB_MONI I see a red flag and this is the error message.

Any ideas.

During the application mapping

com/sap/xi/tf/_mm_Sender_Receiver_ a

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

was thrown: RuntimeException in Message-Mapping

transformatio~

The input is

25,12,35.67. So why is it throwing a mapping error.

[Former Member]

Your data type struructure may be wrongly defined.Can you post your data type?

Data type should be like the following:

Source_DT

-

---

Row

-

---

Substr

-

---

FieldNames

[Former Member]

Sonia,

The error states that there is an error in your message mapping. What you can do is test your mapping by taking your source payload. Check this weblog for some help on how to use this:

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

Also as pointed by other posts there may be a wrong target structure. Also can you tell us the message type structure of your target and your parameters for receiver communicaiton channel.

---Satish

[Former Member]

Message Type is mt_sender

mt_sender Type(Sender_po)

PONUM xsd:string occurence 1

POQTY xsd:string occurence 1

POAMT xsd:string occurence 1

Message Type is mt_receiver

mt_receiver Type(Receiver_po)

PO_NUM xsd:string occurence 1

PO_QTY xsd:integer occurence 1

PO_AMT xsd:float occurence 1

[Former Member]

Sonia,

Your Sender_po and Receiver_po should be 1..unbounded and then try. It should work.

---Satish

[Former Member]

That doesn't resolve my problem. What else?

[Former Member]

When I do a test mapping I get this error

"Cannot produce target element /ns:mt_receiver/PO_NUM. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd". So what is wrong?

[Former Member]

Here is the detailed error message.

"Messages:16:40:41 Start of test

- Cannot produce target element /ns:mt_receiver/PO_NUM. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd

16:45:01 End of test

16:45:10 Start of test

- Creating Java mapping com/sap/xi/tf/_mm_Sender_Receiver_

- Loaded class com.sap.xi.tf._mm_Sender_Receiver_

- Call method execute of the application Java mapping com.sap.xi.tf._mm_Sender_Receiver_

- *** START APPLICATION TRACE ***

- Document start

- Start tag [ns:mt_receiver]

- Add raw attribute [ xmlns:ns="http://xml2xml"]

- Cannot produce target element /ns:mt_receiver/PO_NUM. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd

16:45:12 End of test

[Former Member]

Can somebody point me to the url of Sravi Taryaki for File Content Conversion. I am sure I am not spelling her name right.

[Former Member]

Sravya Tallanki I guess. Sonia I would like to do similar exercise.

I will let you know if am success.

Thanks

Narayana

[Former Member]

Hey

>>Cannot produce target element /ns:mt_receiver/PO_NUM. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd

This means ur XML is not valid,ur givin some wrong values for PO_NUM,also check the occurence of PO_NUM,can u paste the XML ur getting in MONI,so that we can have a look at it

thanx

ahmad

Message was edited by:

Ahmad

[Former Member]

These are parameters I have given. Now tell me what is wrong.

DocumentName FILEINPUT

Document NameSpace http://www.xmlsw

RecordSetName Row

Recordset Structure Substr,*

Recordsets per message *

Key Field Type String(Case Sensitive)

Substr.FieldNames PONUM,POQTY,POAMT

Substr.FieldSeperator ,

Substr.ProcessConfiguration FromConfiguration

Substr.endSeperator 'nl'

Correct me if I wrong. I suppose Document Name and Document Namespace doesn't matter.

[Former Member]

<i> I suppose Document Name and Document Namespace doesn't matter</i>

Document Name ---Your Sender Message Type name

NameSpace --- Name space of Message Type

[Former Member]

>>Substr.<b>F</b>ieldNames PONUM,POQTY,POAMT

Substr.<b>F</b>ieldSeperator ,

Substr.<b>P</b>rocessConfiguration FromConfiguration

Substr.endSeperator 'nl'

This has to be in the correct case. First change this.

>>I suppose Document Name and Document Namespace doesn't matter

It has to be the Message Type Name and namespace respectively. If not the msg will be errored during mapping.

Regards,

Jai Shankar

[Former Member]

Yes...Jai has pointed correctly...

<i>Substr.FieldNames PONUM,POQTY,POAMT

Substr.FieldSeperator ,

Substr.ProcessConfiguration FromConfiguration</i>

Use the below parameters...

Substr.fieldNames PONUM,POQTY,POAMT

Substr.fieldSeperator ,

Substr.processConfiguration FromConfiguration

[Former Member]

Can someone point me to the sap help link. This will give me an idea of what each parameter means. I don't have access to SAP Service Marketplace.

[Former Member]

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

[Former Member]

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

You have provided a wrong value in recrdset arguement.

It should be some thing like <b>header,1</b> or <b>dettail,*</b>

Regards,

Jai Shankar

[Former Member]

Check your Conversion paramters correctly.

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter