topic Re: Null pointer error in tmap in Talend Studio

Null pointer error in tmap

gouravd_7 — Sat, 16 Nov 2024 05:42:10 GMT

Hi Team,

Getting error in tmap , i have applied all columns as nullable but have lookups with another tmap.

Please find the attached screenshot of the tmap and the sub job.

Thanks,

Gourav

Re: Null pointer error in tmap

Anonymous — Thu, 30 May 2019 14:23:30 GMT

Hi Gourav,

The issue is happening at tMap42 which means that Null pointer exception is coming from function. There are two functions here.

a) the left function at Var section

b) the output filter based on equal condition.

To avoid this issue, please add a Null check at the beginning. If the value is null, do not pass the data to the functions. For example,

!Relational.ISNULL(Var.var1) && ("SEG").equals.Var.var1

The Null check should be the first function for all verifications in your tMap operation if there is any chance of having null value in input data.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Null pointer error in tmap

gouravd_7 — Thu, 30 May 2019 14:54:55 GMT

Hi Nikhil,

I have handled this in variable still getting the same error. I also tried your expression but no luck still the issue remains same.

row78.newColumn5==null?nulltringHandling.LEFT(row78.newColumn5, 3)

Thanks,

Gourav

Re: Null pointer error in tmap

Anonymous — Thu, 30 May 2019 15:17:52 GMT

Hi Gourav,

The rule number 1 is that you cannot equate null value to another null. You will have to do it by following way.

Relational.ISNULL(row78.newColumn5)?null:StringHandling.LEFT(row78.newColumn5, 3)

I hope this will resolve your issue. Please spare a second to mark the topic as resolved 🙂 Kudos will be a bonus!

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Null pointer error in tmap

gouravd_7 — Thu, 30 May 2019 15:27:24 GMT

Hi Nikhil,

Tried the above expression too but the error remains same.

Error:

Exception in component tMap_43 (MAGNITUDE_SCRIPT_INDUSINT)
java.lang.Exception: java.lang.NullPointerException
at group_directory.magnitude_script_indusint_0_1.MAGNITUDE_SCRIPT_INDUSINT.tLDAPInput_16Process(MAGNITUDE_SCRIPT_INDUSINT.java:5275)
at group_directory.magnitude_script_indusint_0_1.MAGNITUDE_SCRIPT_INDUSINT.runJobInTOS(MAGNITUDE_SCRIPT_INDUSINT.java:6433)
at group_directory.magnitude_script_indusint_0_1.MAGNITUDE_SCRIPT_INDUSINT.main(MAGNITUDE_SCRIPT_INDUSINT.java:6059)
Caused by: java.lang.NullPointerException
at group_directory.magnitude_script_indusint_0_1.MAGNITUDE_SCRIPT_INDUSINT.tLDAPInput_16Process(MAGNITUDE_SCRIPT_INDUSINT.java:5041)

Re: Null pointer error in tmap

Anonymous — Thu, 30 May 2019 15:43:39 GMT

Hi Gourav,

Please remove the tMap and put a tLogrow to verify various null value components. Add the Null check function wherever needed. Its clearly says the error is Null value issue and the issue is at tMap component.

So put a tLogrow before and after this component for verification. Also add few columns at a time to track the problematic column. There are no easy solutions other than data verification in this case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Null pointer error in tmap

Anonymous — Thu, 30 May 2019 16:05:44 GMT

From the screenshots the error may come in two cases from your job.

1. the variable var1

2. You are concatenating required columns and passing it to the output column DN. Did you verify is there any of the column is getting is null?

For point no 1: @nthampi provided the exact check condition to you.

For point no 2: Please check the columns that you are concatenating and apply null handling to those columns as well.

Re: Null pointer error in tmap

Anonymous — Fri, 31 May 2019 21:37:39 GMT

@gouravd_7

Are you still facing the issue or whether the details helped you to locate the problem area?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Null pointer error in tmap

gouravd_7 — Mon, 03 Jun 2019 10:26:42 GMT

Hi Nikhil,

I am still facing the issue as the job has 8 subjobs with multiple lookups in one Sub job seems there is lot of tmap issues which don't exactly pointing to the tmap instead its point to the Input just before the lookup.

As all errors are of null pointer and the person who designed the job has not handled it properly everywhere so , I am handling it now.

I will post the solution once done with the same.

Thanks for the follow up.

Thanks,

Gourav

Re: Null pointer error in tmap

bhagyarekha — Mon, 03 Jun 2019 12:09:14 GMT

hi
just give try like this
row78.newColumn5!=null?stringHandling.LEFT(row78.newColumn5, 3):null

Re: Null pointer error in tmap

Anonymous — Mon, 03 Jun 2019 18:23:17 GMT

Ok @gouravd_7

Its a quite common mistake happens in Talend jobs. Good that you are verifying the entire data flow for null validations.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Null pointer error in tmap

gouravd_7 — Mon, 10 Jun 2019 10:39:15 GMT

Hi Team,

After applying so many changes in tmap still was not able to fix the issue and since I was doing an inner join , I switched the main and lookup which surprisingly solved the issue.

As it was an inner join nothing much affected and the job runs finally

Thanks everyone who helped me to fixing the issue but tmap works really weird at times sounds funny that after switching the main and lookup issue resolved.

Thanks,

Gourav