topic Error Parsing Field in Talend Studio

Error Parsing Field

Anonymous — Mon, 23 Nov 2015 11:40:02 GMT

Hi,
I am processing an address file using tFileInputPositional which contains about 38 fields in it. When I test the latest file, I am getting the below messages.
Starting the Address Load for the Oracle table at Mon Nov 23 17:01:55 IST 2015
For input string: "A"
For input string: "S"
For input string: "A"
For input string: "F"
For input string: "H"
For input string: "J"
For input string: "G"
For input string: "J"
For input string: "J"
For input string: "J"
For input string: "J"
For input string: "J"
For input string: "H"
For input string: "J"
For input string: "J"
For input string: "B"
For input string: "J"
I assume the above error messages are thrown due to some data type inconsistancy. How do I figure which field is causing this issue? Also, when I get this error message for a specific record, is it getting skipped from processing?
Thanks,
Balaji.

Re: Error Parsing Field

Anonymous — Tue, 24 Nov 2015 02:04:32 GMT

Hi,
Have you tried to drag a "Rejects" row from tFileInputPositional component to see which field is causing this issue(Line:..)?
In addition, here is a TalendHelpCenter:tSchemaComplianceCheck which validates all input rows against a reference schema or check types, nullability, length of rows against reference values.
Best regards
Sabrina

Re: Error Parsing Field

Anonymous — Tue, 24 Nov 2015 14:11:11 GMT

Thanks, will try and see if I can figure out the field that is causing the issue.
Thanks,
Balaji.