NumberFormatException: For Input String...

NumberFormatException: For Input String...

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. 

Community Manager

Re: NumberFormatException: For Input String...

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
----------------------------------------------------------
Talend | Data Agility for Modern Business

Re: NumberFormatException: For Input String...

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

Re: NumberFormatException: For Input String...

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
----------------------------------------------------------
Talend | Data Agility for Modern Business

Re: NumberFormatException: For Input String...

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

Re: NumberFormatException: For Input String...

Can you upload a screenshot of tInformixInput's schema?
----------------------------------------------------------
Talend | Data Agility for Modern Business

Re: NumberFormatException: For Input String...

   

Re: NumberFormatException: For Input String...

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

Re: NumberFormatException: For Input String...

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. 
----------------------------------------------------------
Talend | Data Agility for Modern Business
Community Manager

Re: NumberFormatException: For Input String...

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!
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now