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