topic Re: NumberFormatException: For Input String... in Talend Studio

NumberFormatException: For Input String...

dvorakstephen11 — Sat, 16 Nov 2024 11:07:07 GMT

I'm returning a NumberFormatException in my tInformixInput component. What's the problem here? I have run this job several times and didn't have this problem when uploading similar data.

Re: NumberFormatException: For Input String...

Anonymous — Mon, 03 Aug 2015 03:53:34 GMT

Hi
This field contains string values such as "Anthony Jones", but you are using numeric data type to read it. If you uncheck the 'die on error' option on tInformixInput component, these string values will be rejected to the rejected flow. eg:
tInformixInput--main--tMap
--reject--tLogRow
Best regards
Shong

Re: NumberFormatException: For Input String...

dvorakstephen11 — Mon, 03 Aug 2015 14:02:33 GMT

My tInformixInput component doesn't have a "die on error" option in any of the component tabs.

Re: NumberFormatException: For Input String...

Anonymous — Mon, 03 Aug 2015 14:13:44 GMT

OK, this option is not available on this component yet. Try to read this column with string data type, and then filter the input data and remove the data that is alphabetic, finally, convert the data to numeric data type if needed. eg:
tInformixInput--main--tFilterRow--main--tLogRow
on tFilterRow, check the 'Use advanced mode' box, and write the expression as below:

!StringHanding.IS_ALPHA(input_row.columnName);

Best regards
Shong

Re: NumberFormatException: For Input String...

dvorakstephen11 — Mon, 03 Aug 2015 14:25:56 GMT

The field is intended to contain only string values, so I don't want (and shouldn't have) any numeric data types included. In all of my schemas, the resourcename column is a String data type, but I'm still receiving this NumberFormatException.

Re: NumberFormatException: For Input String...

Anonymous — Mon, 03 Aug 2015 14:30:06 GMT

Can you upload a screenshot of tInformixInput's schema?

Re: NumberFormatException: For Input String...

dvorakstephen11 — Mon, 03 Aug 2015 14:40:19 GMT

Re: NumberFormatException: For Input String...

dvorakstephen11 — Mon, 03 Aug 2015 14:43:31 GMT

I figured it out. For some reason I was leaving out resourceid in my query, even though I'm sure I had it in there before at one point. Thanks for your help.

Re: NumberFormatException: For Input String...

Anonymous — Mon, 03 Aug 2015 14:44:55 GMT

From your screenshots, I see there are many integer fields, this error must occur on one of these integer fields, can you debug to see which field has the error.

Re: NumberFormatException: For Input String...

Anonymous — Mon, 03 Aug 2015 14:46:14 GMT

dvorakstephen11 wrote:
I figured it out. For some reason I was leaving out resourceid in my query, even though I'm sure I had it in there before at one point. Thanks for your help.

Great! and thanks for your feedback!