on 08-17-2011 11:52 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.