regarding file content conversion

[Former Member]

Re: regarding file content conversion

Posted: Sep 25, 2008 11:30 AM in response to: kummari Edit E-mail this message Reply

i tried.but m getting this error

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'Conversion configuration error: Unknown structure 'ns1:MT_HyperionReport' found in document', probably configuration error in file adapter (XML parser error)': java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'Conversion configuration error: Unknown structure 'ns1:MT_HyperionReport' found in document', probably configuration error in file adapter (XML parser error)'

Actually my input structure is:

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

<ns0:MT_ECCReport xmlns:ns0="urn:syngenta.com:i_ecc_erp:se:global:fi_reports:common">

<ACTFiscalyear>siva</ACTFiscalyear>

<StartPeriod>44</StartPeriod>

<EndPeriod>55</EndPeriod>

<LineItems>

<ReportingUnit>rama</ReportingUnit>

<ProfitCentre>844</ProfitCentre>

<Amount>855</Amount>

</LineItems>

</ns0:MT_ECCReport>

and in FCC i wrote below these three lines:

LineItems.fieldSeparator 'nl'

MT_HyperionReport.fieldSeparator 'nl'

LineItems.fieldSeparator 'nl'

So please tell me what is wrong in this

[Former Member]

Hi,

MT_HyperionReport should be used as "Document name" just.

create dummy "Recordset Name" as Record

and set property ignoreRecordsetName = true.

And use properties as Record.endseparator = 'nl' and

Record.endseparator = 'nl'

Regards,

Akshay.

[Former Member]

Thanx .but i didnt get understand clearly...where i will change the document name.

here where i will create the dummy record set structure

[Former Member]

Hi

Check the FCC parameters like Document Name etc in the following help doc

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

regards

krishna

[Former Member]

MT_HyperionReport is your message type and this represents the top level node of your message. Below this you have your records. You have MT_HyperionReport as a record type which is clearly not going to work.

In the content conversion parameters section the following fields should be filled, you dont need to specify Recordset if your XML structure does not include this node see SAPhelp example:

Document Name: MT_HyperionReport

Document Namespace: <look at your message type in the designer>

Recordset Structure: Record_type1,<occurrence 1..>, Record_type2,<occurrence 1..>

In the parameter box:

Record_type1.fieldSeparator

Record_type1.fieldNames

ignoreRecordsetName value true

Record_type2...

The SAP help on this is pretty clear and comprehensive...

http://help.sap.com/saphelp_nw04/helpdata/en/0f/80243b4a66ae0ce10000000a11402f/frameset.htm

[Former Member]

Hi

From the error message you are using the message type as MT_HyperionReport for fieldseparator , but looking into payload you are using different message type i.e. MT_ECCReport.

Because of this you are getting the error.

Please check your message types in content conversions.

Regards

Sridhar Goli