Column value ' ' too long - must stop', probably configuration error

[Former Member]

Hi Experts,

I have a Proxy to File Scenario when I execute it I get this error in RWB. Can you please help me on this:

Message processing failed. Cause: com.sap.aii.messaging.adapter.trans.TransformException: Error converting Message: 'java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Column value ' ' too long - must stop', probably configuration error in file adapter (XML parser error)''; nested exception caused by: java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Column value ' ' too long - must stop', probably configuration error in file adapter (XML parser error)'

Thanks

Srikanth E

[Former Member]

>>java.lang.Exception: Exception in XML Parser (format problem?):

is there any date values in ur xml input???

[Former Member]

yes Amit

2 Fields HireDate and DOB the date transfer properties are yyyyMMdd --> MMddyyyy

[Former Member]

>>2 Fields HireDate and DOB the date transfer properties are yyyyMMdd --> MMddyyyy

u r using these dates fileds in ur FCC?? so chk whether they are properly filled (test ur message mapping)?

[Former Member]

I tested msg mapping I donn get any errors in transferring the Dates, in sxi_moni the msg is successfully processed when I check RWB I get the error, donn know where I'm lost

[Former Member]

chk this wiki (point 7)

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

[Former Member]

Hi,

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.

To use map with default between source and target strcture so in case source tag dont have value target structure will be created because of mapwithdegfault fuction and ur FCC will not fail.

Open SXMB_MONI output payload and compare the structre with Data type u will se for no source value target tag is not created at all and FCC is failed.

please refer below thread,

regards,

ganesh.

[Former Member]

Hi

I did the same, mapped all the target fields with mapWithDefault but still getting the same error

Srikanth E

[Former Member]

if its not a big file, why dont you check if any of your fields mismatch the FCC lengths?

[Former Member]

hi Srikanth,

Is it possible that you can paste here the content conversion that you are using if it s a flat file?

REgards,

Ninu