cancel
Showing results for 
Search instead for 
Did you mean: 

FIle Content Conversion IDOC to Flat file

Former Member
0 Kudos

Dear Experts ,

Getting the below error in the reciever channel . The mapping is generating all the segments in the target structure but when writing to the destination its giving me this error . can some one let me knoe what exactly does this mean [ Column value 'ZXYGRX' too long (>1 for 6. column) ] .

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: 'java.lang.Exception: Column value 'ZXYGRX' too long (>1 for 6. column) - must stop', 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: 'java.lang.Exception: Column value 'ZXYGRX' too long (>1 for 6. column) - must stop', probably configuration error in file adapter (XML parser error)'

Thanks in advance

Regards

Ganga

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member184681
Active Contributor
0 Kudos

Hi Ganga,

It looks like your source field is longer than the target one in your receiver adapter's FCC. I can see as least two different solutions for you, it is up to you to decide which one matches your requirements:

1. Change the configuration of the receiver adapter's FCC, so that this particular field had its length equal to the lenght of the ZXYGRX IDoc field. You have to make sure that this is acceptable for the receiver system. Also, from the fact that this message did not throw any error in mapping and the longer target field value went up to the adapter I assume, that the field's length in target Message Type is long enough, so it is purely the FCC config that causes the error. Make sure that it's not just a typo

2. Use the substring() function in your message mapping to only take the first character from the source field ZXYGRX to your target field.

Hope this helps,

Greg

Former Member
0 Kudos

once you have to check the below steps:

first one you have to check lenght of the field "ZXYGRX" .might be the field length is more than specified lenght.

second one is ,value is paaing/not.if there is any empty tag coming from source then target structure tag will not be created and because of which ur payload structure and FCC configuration is not matching.

refer below links:

http://forums.sdn.sap.com/thread.jspa?threadID=1736330

http://forums.sdn.sap.com/thread.jspa?threadID=1002255

http://forums.sdn.sap.com/thread.jspa?threadID=1896862

Former Member
0 Kudos

Hi Ganga,

This is happening because - if there is any empty tag coming from source then target structure tag will not be created and because of which ur payload structure and FCC configuration is not matching.

Please refer this blog , may be it will helpful.

http://wiki.sdn.sap.com/wiki/display/XI/TroubleshootingtheFile+Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards,

Sudeepth

Edited by: sudeepth on Feb 8, 2012 7:02 AM

PriyankaAnagani
Active Contributor
0 Kudos

Hi,

Check whether you are passing a value whose length is more than specified for the field 'ZXYGRX' as it is saying column value is too long. Also refer this

http://forums.sdn.sap.com/thread.jspa?threadID=1896862

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13743

Regards,

Priyanka