Error in File to JDBC Scenario using File Content Conversion.

[Former Member]

Hi ,

I am sending a text file in CSV format, with all the configurations done in the sender and receiver channels.

But the adapter monitoring says this:

Initialization error: Conversion initialization failed with java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found:

Parameter 'EmployeeDetails.fieldFixedLengths' or 'EmployeeDetails.fieldSeparator' is missing

Consistency check: no. of arguments in 'EmployeeDetails.fieldFixedLength' does not match 'EmployeeDetails.fieldNames' (0 <> 6)

One thing to note here is that

1. EmployeeDetails.fieldSeparator is given as ','

2. I haven't used any fieldFixedLengths.

Pointers in this regard would be higly appreciated.

Regards,

Younus

[Shabarish_Nair · Accepted solution]

cross check if you have specified EmployeeDetails.fieldFixedLengths and EmployeeDetails.fieldSeparator. only one must be used.

in case you have already specified,

EmployeeDetails.fieldSeparator as ',' , then delete that line and reenter the details again, activate and run the scenario.

[Former Member]

Thanks Vijay and Bhavesh,

Thanks a lot, you responses helped solve the scenario.

Regards,

Younus

[bhavesh_kantilal]

Also, check if the fieldSeparator does not have a space after it in the table. There should be no extra spaces.

Regards

Bhavesh