topic Re: java.lang.NullPointerException error in a tFileInputExcel in Talend Studio

java.lang.NullPointerException error in a tFileInputExcel

fabienb1 — Fri, 15 Nov 2024 21:24:36 GMT

Hello everyone,

I am facing an error while using the tFileInputExcel component : if I open a specific Excel file it generates a java.lang.NullPointerException error.

If I open that Excel file, click on one random cell, save it without changing anything, then the job will run with no error.

If I open another Excel file, I do not face that error either.

I don't know what could be the cause of the problem. Is there a way to make a small change in the Excel file, for example with a tJava component, to work around the problem ?

Re: java.lang.NullPointerException error in a tFileInputExcel

Anonymous — Mon, 18 Sep 2023 01:57:18 GMT

Hello,

Does this issue repro on all your jobs or this specific tFileInputExcel?

Could you please clarify in which Talend version/edition you are and what's JDK version you are using?

Here are online documentations about:

https://help.talend.com/r/en-US/Cloud/installation-guide-windows/compatible-operating-systems

https://help.talend.com/r/en-US/Cloud/installation-guide-windows/compatible-java-environments

Best regards

Sabrina

Re: java.lang.NullPointerException error in a tFileInputExcel

fabienb1 — Mon, 18 Sep 2023 14:19:12 GMT

Hi Sabrina,

Thanks for answering. See the screenshot attached for the Talend version

Regarding the Java version :

C:\Users\Augustin>java -version

openjdk version "17.0.6" 2023-01-17 LTS

OpenJDK Runtime Environment Zulu17.40+19-CA (build 17.0.6+10-LTS)

OpenJDK 64-Bit Server VM Zulu17.40+19-CA (build 17.0.6+10-LTS, mixed mode, sharing)

This issue reproduces if I create a brand new job, add a new component tFileInputExcel, and asks it to open that specific Excel file.

Note that this job (and all the other jobs) can perfectly run with another Excel file, or that problematic file with a small modification.

Re: java.lang.NullPointerException error in a tFileInputExcel

Anonymous — Tue, 19 Sep 2023 05:48:07 GMT

Hello,

So far, Java 17 is not list in the compatible java environments officially.

Could you please try to switch to java 11 (open jdk zulu) to see if it is working well for you?

Best regards

Sabrina

Re: java.lang.NullPointerException error in a tFileInputExcel

fabienb1 — Tue, 19 Sep 2023 07:40:03 GMT

I have reinstalled java, rebooted Windows, the problem is still here. Please, have a look at the screenshot.

When I run another Excel file linked to another project, I do not get this error.

Regarding the java version :

java -version

openjdk version "11.0.20.1" 2023-08-24 LTS

OpenJDK Runtime Environment Zulu11.66+19-CA (build 11.0.20.1+1-LTS)

OpenJDK 64-Bit Server VM Zulu11.66+19-CA (build 11.0.20.1+1-LTS, mixed mode)

Best Regards,

Re: java.lang.NullPointerException error in a tFileInputExcel

Anonymous — Tue, 19 Sep 2023 08:04:44 GMT

tFileInputExcel is an input component, it should has output links, make sure you have defined the schema and link it to another component, such as tLogRow, tFIleOutputDelimited, before you execute the job.

tFileInputExcel--main--tLogRow

tLogRow: print the data on the console.

Re: java.lang.NullPointerException error in a tFileInputExcel

fabienb1 — Tue, 19 Sep 2023 09:17:07 GMT

I know, this is a standalone test job not meant to be used.

But compare the logs with another Excel file, the result is different

Re: java.lang.NullPointerException error in a tFileInputExcel

Anonymous — Wed, 20 Sep 2023 01:35:54 GMT

Hello,

What does your specific Excel file look like?

Is it OK with you to centralize the connection to your excel file, along with its data structure, in the Repository?

https://help.talend.com/r/en-US/8.0/studio-user-guide/centralizing-file-excel-metadata

Best regards

Sabrina

Re: java.lang.NullPointerException error in a tFileInputExcel

jlolling — Wed, 20 Sep 2023 08:18:19 GMT

Could you please check if you can find a java stack trace for this error in the studio logs? This would be very helpful. Unfortunately the given error message does not help at all - shame on you Talend!

Re: java.lang.NullPointerException error in a tFileInputExcel

jlolling — Wed, 20 Sep 2023 09:03:42 GMT

Could you please send me a copy of the original excel file. I would like to figure out the root cause. jan.lolling@gmail.com

Re: java.lang.NullPointerException error in a tFileInputExcel

fabienb1 — Wed, 20 Sep 2023 15:25:32 GMT

I am sorry, it is not possible. The file contains customer data that can't be shared out of my company

Re: java.lang.NullPointerException error in a tFileInputExcel

jlolling — Wed, 20 Sep 2023 16:43:39 GMT

What about the logs from the studio?

Re: java.lang.NullPointerException error in a tFileInputExcel

fabienb1 — Tue, 26 Sep 2023 09:15:02 GMT

Hi jlolling, thanks for your answer.

How do you get the java stack trace ? I have tried to run this job in debug mode. I am not sure what I am expected to find : I got the error

Plugin execution not covered by lifecycle configuration: org.talend.ci:builder-maven-plugin:8.0.12:generate

I am not sure if this could help

Re: java.lang.NullPointerException error in a tFileInputExcel

fabienb1 — Tue, 26 Sep 2023 09:17:46 GMT

Hi Sabrina,

I cannot share the Excel file as it contains customer data that can't be shared out of my company.

It has one worksheet, columns go to "AK", and lines to 88000. Strings, numbers, dates... Nothing particular.

Re: java.lang.NullPointerException error in a tFileInputExcel

fabienb1 — Tue, 10 Oct 2023 08:23:24 GMT

I have found the solution : I was working with a tFileInputExcel from a previous version of Talend, which behaved differently.

There was no indication on that. The only thing was a small visual difference.

I found this by comparing both components and re-mapping every column.