topic Re: [resolved] Customizing error message "For input string" in Talend Studio

[resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 07:20:22 GMT

Hi All,
When I am trying to read an excel file, the tFileInputExcel throws an error as follows:
"For input string "ABCD"
(This happens when my Excel value is a String and the expected value is an Integer.)
But, this error message does not seem to be descriptive. So I need to customize the error message.
How can I catch it and change?
Thanks,
thivanka.

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 08:10:44 GMT

Hi,
You can use tLogCatcher to catch this error("For input string "ABCD") then customing the information through tMap.

Best regards
Sabrina

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 08:25:44 GMT

Hi Sabrina,
In my case SIMPLE_MAPPING component throws the error. So I cant use tMap to handle it.

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 08:59:07 GMT

Hi,
Can you create another subjob, such as: tLogCather-->tmap-->output to custom error info?
Best regards
Sabrina

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 09:04:20 GMT

Hi Sabrina,
Yes, I can. But the problem is my 'Die on error' is unchecked and the tLogCatcher will not catch the error. It only prints
"For input String XXXXX" in the console. When I check the 'Die on error' option, the flow stops once an error occurs. But,
I need to continue the flow while skipping the error rows.
Thanks,
thivanka.

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 09:26:07 GMT

Hi,
I got your point. If so, you can use "Reject" row from tfileinputxxx component which throws the error then contacting to tMap/tjavarow without checking out "Die on error" option.
See my screenshots
Best regards
Sabrina

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 09:26:15 GMT

Hi asthiwanka,
use the below image component to customize your errors

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 09:44:15 GMT

Hi Sabrina,
Thank you for your response. That is the correct way to do it. I will come back to you if I have any issue with that.
Sakhale1990, thanks for your reply too. I will first try Sabrina's solution.
Thanks,
thivanka.

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 09:58:06 GMT

Hi,
Feel free to let me know if it is OK with you.
Best regards
Sabrina

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 10:02:08 GMT

Hi Sabrina,
can u pls solve these Errors

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 10:08:22 GMT

Hi Sabrina,
Yes, it works. Thanks a bundle for your support.

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 10:51:56 GMT

Hi sakhale1990,
Could you please stick to one topic https://community.talend.com/t5/Design-and-Development/resolved-transformations/td-p/113264 so that we can pay individule attention to it. We are investigating your issue then come back to you asap.
Many thanks
Best regards
Sabrina

Re: [resolved] Customizing error message "For input string"

Anonymous — Thu, 21 Aug 2014 10:53:18 GMT

Hi thivanka,
Could you please mark this topic as resolved? This way, other users will be informed that this thread has been resolved.

Best regards
Sabrina