on 02-08-2012 5:32 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.