topic Re: Null Pointer exception for date field from source in Talend Studio

Null Pointer exception for date field from source

VRadhakrishnan1651487711 — Fri, 15 Nov 2024 22:57:20 GMT

Hello Friends

I need your help on clearing an issue, when i tried to implement SCD2 Concept

Below is my source

Cust_id Cust_ty_id Cust_nm Birth_dt

1 101 John null

When i tried to use tMap to compare the source and Lookup using the variable formula

row3.BIRTH_DT==null ||row2.BIRTH_DT==null?"1":row3.BIRTH_DT.equals(row2.BIRTH_DT)?"0":"1"

Im getting the Null pointer exception. Arrached the screenshot of the tMap and Job

Re: Null Pointer exception for date field from source

Anonymous — Wed, 04 May 2022 15:24:38 GMT

It's difficult to see all of your logic in the screenshots, but what is happening is that you are trying to call a method on an object that is null. The first thing that should be done before calling methods on objects is to ensure that the object is not null. I suspect that this is not the logic that is directly causing this, but the column methods that are called on the output of this logic. I see it is either 1 or 0. See if you can check the output data. I'd look at the dates that are being processed with methods as your first port of call.

Re: Null Pointer exception for date field from source

VRadhakrishnan1651487711 — Wed, 04 May 2022 16:36:13 GMT

Hi rhall

I have used

(row3.BIRTH_DT==null )? null :

row3.BIRTH_DT.equals(row2.BIRTH_DT)?"0":"1"

if birth_dt is null then insert/update as null else compare and set 1 or 0

Re: Null Pointer exception for date field from source

VRadhakrishnan1651487711 — Wed, 04 May 2022 16:42:06 GMT

Re: Null Pointer exception for date field from source

Anonymous — Wed, 04 May 2022 23:12:19 GMT

Can you show us the exact error message you get please? By that I mean, the error reported in the output Window. Something is null when it is being called or being used if you are getting a NullPointerException.

Re: Null Pointer exception for date field from source

VRadhakrishnan1651487711 — Thu, 05 May 2022 03:44:53 GMT

Re: Null Pointer exception for date field from source

Anonymous — Thu, 05 May 2022 06:58:33 GMT

@Vinothkumar Radhakrishnan ,the error might come from other expression such as TalendDate.parseDate(String pattern, String date_string) in the output table of tMap, go to check expression one by one and confirm which expression throws the error.

Regards

Shong