java.lang.NullPointerException error in a tFileInputExcel

[fabienb1]

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 ?

[Anonymous]

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

[fabienb1]

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.

[Anonymous]

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

[fabienb1]

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,

[Anonymous]

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.

[fabienb1]

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

[Anonymous]

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

[jlolling]

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!

[jlolling]

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