Skip to Content
0

FCC for XML to TXT

Jul 25, 2017 at 03:01 PM

69

avatar image

Hello Experts,

My scenario is ABAP proxy to ECC(AL11).

Posting the text file to AL11 using FCC. Source and Target structures are the same which is as follows

MT_Source ---Record(This sub node is under MT_Source) -----Field1(There are such 15 fields under Record)

In FCC I a configured as

Recordset structure: MT_SOurce

Record.fieldFixedLegths:10,10,10,10,10,10,10,10,10,10,10,10,10,10,10

Record.fieldSeperator:'nl'

But getting the error

Message processing failed in XML parser: java.lang.Exception: Consistency error: more fields found in XML structure than specified in conversion parameters! (Value 0123456789), probably configuration error in file adapter (XML parser error)

What should the FCC configuration be for converting XML to Fixed length Text file?

Can you please help me on this?

Thanks in advance,

Vikas

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

BRM Fresher Jul 25, 2017 at 05:29 PM
0

Hello Experts,

Can someone please help me on this?

Thanks in advance,

Vikas

Share
10 |10000 characters needed characters left characters exceeded
BRM Fresher Jul 26, 2017 at 06:14 AM
0

Hello Ryan and Manoj,

I am using Record in the Recordset Structure and using the following parameters only

Record.fieldSeperator:'nl'

Record.endSeperator:TAB

But getting the error as channel is not initialised

What are the parameters needed for FCC here in my case?

There are 15 fields under the Sub node Record

Really appreciate your replies.

Thanks in advance,

Vikas

Share
10 |10000 characters needed characters left characters exceeded
Ryan Crosby Jul 25, 2017 at 06:00 PM
0

Hi Vikas,

The error indicates that your source XML has more than 15 fields. Can you share the payload sample?

Regards,

Ryan Crosby

Share
10 |10000 characters needed characters left characters exceeded
BRM Fresher Jul 26, 2017 at 07:45 AM
0

Hello Manoj,

I am using Record in the Recordset Structure and using the following parameters only

Record.fieldSeperator:'nl'

Record.endSeperator:TAB

Earlier there were 14 fields in the payload but now corrected to 15 .But now getting this error

Channel has not been correctly initialized and cannot process messages

Where is it exactly going wrong? This is the payload I am using

 <?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_Payload xmlns:ns0="http://........">
<Record>
<Field1>0123456789</Field1>
<Field2>0123456789</Field2>
<Field3>0123456789</Field3>
<Field4>0123456789</Field4>
<Field5>0123456789</Field5>
<Field6>0123456789</Field6>
<Field7>0123456789</Field7>
<Field8>0123456789</Field8>
<Field9>0123456789</Field9>
<Field10>0123456789</Field10>
<Field11>0123456789</Field11>
<Field12>0123456789</Field12>
<Field13>0123456789</Field13>
<Field14>0123456789</Field14>
<Field15>0123456789</Field15>
</Record>
</ns0:MT_Payload>

Thanks in advance

Share
10 |10000 characters needed characters left characters exceeded
Manoj K Jul 25, 2017 at 05:59 PM
0

HI Vikas,

Recordset structure should be Record and not the message type.

And please validate again your no of Fields in File , FCC and your data type.

Br,

Manoj

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hello Manoj,

I am using Record in the Recordset Structure and using the following parameters only

Record.fieldSeperator:'nl'

Record.endSeperator:TAB

Earlier there were 14 fields in the payload but now corrected to 15 .But now getting this error

Channel has not been correctly initialized and cannot process messages

Where is it exactly going wrong? This is the payload I am using

 <?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_Payload xmlns:ns0="http://........">
<Record>
<Field1>0123456789</Field1>
<Field2>0123456789</Field2>
<Field3>0123456789</Field3>
<Field4>0123456789</Field4>
<Field5>0123456789</Field5>
<Field6>0123456789</Field6>
<Field7>0123456789</Field7>
<Field8>0123456789</Field8>
<Field9>0123456789</Field9>
<Field10>0123456789</Field10>
<Field11>0123456789</Field11>
<Field12>0123456789</Field12>
<Field13>0123456789</Field13>
<Field14>0123456789</Field14>
<Field15>0123456789</Field15>
</Record>
</ns0:MT_Payload>

Thanks in advance,

Vikas

0

please share scrrenshot of your channel config with FCC/MTB

0

Thanks Manoj , its fixed now

0