tJavaRow_1 null java.lang.NullPointerException: null

[JayZ1]

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.

[Anonymous]

Hi

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

Regards

Shong

[JayZ1]

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?

[Anonymous]

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.

[Anonymous]

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.