topic tJavaRow_1 null java.lang.NullPointerException: null in Talend Studio

tJavaRow_1 null java.lang.NullPointerException: null

JayZ1 — Fri, 15 Nov 2024 22:33:46 GMT

I have a script that is working on 6.3 talend but after migrating it to talend 8.0 it is now failing with a NullPointerException. I couldn't find much details in the logs so wasn't sure where i should even look to figure out why its failing.

I am reading in data from an xlsx file and transforming all of that data, not sure why it gets past this first tJavaRow_1 and sends data but gets a null pointer exception. Any idea where i should look to begin debugging this issue other than debug mode which i will be doing now.

Re: tJavaRow_1 null java.lang.NullPointerException: null

Anonymous — Tue, 13 Sep 2022 00:12:36 GMT

Can you show us the code on tJavaRow if the NPE occurs on this component?

Regards

Shong

Re: tJavaRow_1 null java.lang.NullPointerException: null

JayZ1 — Tue, 13 Sep 2022 19:18:10 GMT

I was able to resolve the issue, I had to just add in some null checking. '!= null' however its weird that in older versions of Talend this didn't happen but in 8.0 it did. Is it possible that the excel reading component is reading in blank values?

Re: tJavaRow_1 null java.lang.NullPointerException: null

Anonymous — Wed, 14 Sep 2022 01:28:35 GMT

I think it is because you read different data, there is no null value in the old data. The component read the blank values as null value.

Re: tJavaRow_1 null java.lang.NullPointerException: null

Anonymous — Mon, 19 Sep 2022 11:57:00 GMT

Hello JayZ,

I think that previously we might not be able to read the null values and it often became empty string. Since that was considered a bug now it's working properly, but it means your code could encounter null values.