Sender FCC error

[Former Member]

Hi,

I get the below error in Communication channel monitoring and all the parameters have been checked and they seems to be OK. Channel was working properly earlier and nothing has been changed later.

Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR converting document line no. 2 according to structure 'Line':java.lang.Exception: ERROR in configuration / structure 'Line.': More elements in file csv structure than field names specified!

Regards,

Chaitanya

[Former Member · Accepted solution]

Hi,

Please check if the source file has the correct format.

Check if the number of segments/columns are as expected. Also, check if the data in any column has the field seperator as a value..

i.e. lets say your field seperator is ',' and one of the columns has ',' as a value, in which case the FCC will throw an error.

Regards

[Former Member]

If no one has done any changes in CC then check your incoming source file. The problem seems to be there in the source file.

[baskar_gopalakrishnan2]

Your second line might contains more fields and you might have not specified in fcc. Please check the number of fields between configuration and input source. Also make sure field separator does not conflict with the input data as previous replies mentioned.

[former_member854360]

You have more filed in the file in line no 2 then the no of field specied

For Example

Fieldname specified in Module config

Field1,Field2

But file may contain 3 three field in second line

23,A roy,67

so in this case it will fail.

check the second line in the file and count the no of fields.

Also check any field valuecontains the separotor (,) inside it? In some cases first name and last name we put by a comma separtor

[Former Member]

Hi Debashish,

Set the property for your recordset under Content Conversion tab as follows,

Name:

<recordset_name>.additionalLastFields

Value:

ignore

For example: If you have recordset structure as,

HEADER,1,LINE,*

then the configuration will look like,

LINE.additionalLastFields________________ignore

- Netrey