Error in Sender File Adapter FCC

[former_member440061]

Hi,

We have a newly developed File to JDBC Interface in PI 7.0. Transport protocol is FTP with message protocol as File Content conversion. the following content conversion parameters have been used :

Row.fieldNames : Fieldnames seperated by comma

Row.fieldSeperator : |

Row.processConfiguration : FromConfiguration

Row.endSeperator : 'nl'

Now when we try to test this by putting a file on the FTP folder, we are getting the below error in Communication Channel Monitoring:

Error : Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'Row.fieldFixedLengths' or 'Row.fieldSeparator' is missing Consistency check: no. of arguments in 'Row.fieldFixedLength' does not match 'Row.fieldNames' (0 <> 13)

Please note that we are not using Row.fieldFixedLengths anywhere. Also we have cross checked the number of fields mentioned in the channel configuration with those mentioned in the file. There is no extra space/tab after the field names.

Similar channels are available with the same number of content conversion parameters and all of them are working fine except this.

Please help.

[former_member203631 · Accepted solution]

Hi Faisal,

Please check the spelling of the entries you made. If above provided entries are correct then I hope Row.fieldSeperator(wrong) should be Row.fieldSeparator(right)

Shiva.

[former_member440061 · Accepted solution]

Thanks Shiva for pointing out the blunder.  :$

Sill Mistake I did and didn't noticed. It is working now.

[gagandeep_batra]

Hi Faisal,

try with separated the fieldNames as well with |

Row.fieldNames : Fieldnames seperated by Pipe |

Regards

Gb

[praveen_sutra]

hi FAisal,

https://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

●      NameA.fieldFixedLengths

If you make an entry here, the system expects a character string that contains the lengths of the structure columns as arguments separated by commas.

If you also specify a separator for the columns, you must not add its length to the length of the columns.

This entry is mandatory if you have not made an entry for NameA.fieldSeparator.

And in your case fieldFixedLengths is missing.

please add this.

hope this helps,

thanks and regards,

Praveen T

[former_member440061]

Hello Praveen,

Thanks for the prompt reply.

But as already mentioned, we are not using parameter fieldFixedLengths, then why the system is expecting it.

I have already maintained an entry for fieldSeperator parameter. In that case it should not be mandatory.

Moreover there are several other interfaces with similar configuration and they all are working fine.

Please suggest.