topic java.lang.NumberFormatException: For input string: "FALSE" in Talend Studio

java.lang.NumberFormatException: For input string: "FALSE"

ZZ1655504362 — Sun, 19 Jun 2022 22:19:41 GMT

Hello, I have an Excel input , a tmap, and a tdboutput; when I run the job I see the error:

java.lang.NumberFormatException: For input string: "FALSE"

(and maybe others)

I'm trying to find a way to isolate the Excel row that is causing the error (and hopefully the column): could anyone help

me ?

Thank you

Re: java.lang.NumberFormatException: For input string: "FALSE"

Anonymous — Mon, 20 Jun 2022 04:39:31 GMT

This column contains string value like 'FALSE', but you read this column with number type such as int/Integer, float.

Regards

Shong

Re: java.lang.NumberFormatException: For input string: "FALSE"

ZZ1655504362 — Mon, 20 Jun 2022 16:54:34 GMT

Hello Shong, thank you for the answer. The problem is that the word "FALSE" is not present anywhere in the Excel document, that's why I need to identify the row with the problem. I've tried to create another excel file using some of the rows of the first document, but I have no error.

The file has a lot of columns and about 20000 rows: is there any function on talend that can tell me the cell, or simply the row, that causes the problem ?

Thank you

Best Regards

Marco

Re: java.lang.NumberFormatException: For input string: "FALSE"

ZZ1655504362 — Mon, 20 Jun 2022 21:57:28 GMT

Hello, an update, maybe can be useful to someone: the file giving problems to my talend job is an xlsx generated by an Access DB; I took this file, loaded with libreoffice, saved as xlsx (I know, it seems pointless) and substituted to the original file. The error "java.lang.NumberFormatException: For input string: "FALSE"" disappeared and all is working now

Just to be sure I tried several times, using different files, keeping the same job procedure

The file saved by libreoffice has the same data than the original, but a smaller size; it seems like there's a bug on the java library used to read the excel file, maybe big files, I've never had problems with small excel files.

However, it would be great if Talend had a way to tell more details error about the row giving error

Marco

Re: java.lang.NumberFormatException: For input string: "FALSE"

Anonymous — Tue, 21 Jun 2022 09:22:08 GMT

I don't think it is because the big file causes the problem. For debugging, print the data on console using tLogRow and check the 'die on error' option on tFileInputExcel, the job will stop to run once an error occurs, all the right data will be printed on the console, then you will check the next row which has the bad data.

Regards

Shong