Skip to Content
0
Former Member
Feb 21, 2011 at 04:29 AM

Append error on field length

44 Views

Hi all,

I've gotten the header/trailer removed in the sender communication channel using java mapping and now must take the resulting detail rows and only allow them to be 80 characters in length and in flat text format (as it was initially). Below is how I have content conversion set up on the receiver communication channel:

*note - if I remove the content conversion in the receiver channel concatenation of the files without the header/trailer works flawlessly but the message is still in pixml format. there is no issue with the append functionality, simply the output of the detail row set to a max of 80 characters followed by another detail row at 80 characters, etc. in flat text format***

Processing parameters: Append

file type: text

file encoding: blank

Recordset Structure: DetailRow

DetailRow.fieldNames Bytes4,RecId,Date1,Filler

DetailRow.fieldFixedLengths 4,6,6,64

DetailRow.addHeaderLine 0

DetailRow.endSeparator 'nl'

communication channel errors received in RWB:

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 '1528W COFFEYVIL KSL 11011409UP COFFEYVIL KS 587970587970' too long (>6 for 2. column) - must stop', probably configuration error in file adapter (XML parser error)

Could not process due to error: java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'java.lang.Exception: Column value '1528W COFFEYVIL KSL 11011409UP COFFEYVIL KS 587970587970' too long (>6 for 2. column) - must stop', probably configuration error in file adapter (XML parser error)'

Can anyone lend a hand on this one?

Much thanks,

Don