NumberFormatException: For Input String...

[dvorakstephen11]

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. 

[Anonymous]

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

[dvorakstephen11]

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

[Anonymous]

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

[dvorakstephen11]

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.

[Anonymous]

Can you upload a screenshot of tInformixInput's schema?

[dvorakstephen11]

   

[dvorakstephen11]

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.

[Anonymous]

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. 

[Anonymous]

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!