topic Re: For input string: error in Talend Studio

For input string: error

Anonymous — Tue, 20 Dec 2016 18:19:07 GMT

I am using tOracleInput to input data to database table. From time to time, I got For input string: error because of the data type difference. However, the program still moved on to the next records and skipped the record. It is hard for me to identify which records are missed.
Is there a way to output the failed records to a file, so I can re-process it later. I was trying the On Component Error, but no luck. Anyone has any idea how to output the skipped or failed records?
Thanks,
email3888

Re: For input string: error

Anonymous — Wed, 21 Dec 2016 03:13:24 GMT

Hi,
What's your target DB? Here is a "Rejects" row from t<DB>output component which is used to catch rejected records.
Best regards
Sabrina

Re: For input string: error

Anonymous — Tue, 03 Jan 2017 22:53:52 GMT

Hi Sabrina,
Happy New Year! I just came back from holiday. Sorry for the late reply.
I am using Oracle database. In the tOracleOutput component, I unchecked Die on error. But, I cannot see the Rejects under the Row.

Thanks,
email3888