Error Parsing Field

One Star

Error Parsing Field

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.
Moderator

Re: Error Parsing Field

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Error Parsing Field

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