topic Re: Tmap null pointer exception in Talend Studio

Tmap null pointer exception

Anonymous — Sat, 16 Nov 2024 14:21:22 GMT

Hello,
I'm using Java TOS 2.4.0.RC1.
I'm using a tWaitForFile to start a mixing a xml File and doing a lookup on DB2 AS400 table.
During the first iteration i have no problem all succeed but the second iteration make a nullpointerException in Tmap.

Exception in component tMap_1
java.lang.NullPointerException
at rfid.rfid_0_1.rfid.tWaitForFile_1Process(rfid.java:2051)
at rfid.rfid_0_1.rfid.tAS400Connection_1Process(rfid.java:261)
at rfid.rfid_0_1.rfid.runJobInTOS(rfid.java:3940)
at rfid.rfid_0_1.rfid.main(rfid.java:3852)
It's seem due to lookup component but i' don't understand why.

Thanks for reply

Re: Tmap null pointer exception

Anonymous — Wed, 28 May 2008 07:07:28 GMT

Hello ben23

Exception in component tMap_1
java.lang.NullPointerException

1) Make sure your columns are nullable when you define the schema.
2) The NullPointerException indicate there are some null value on lookup table, so you need to deal with the null value on corresponding columns on expression filed of tmap, for example:
row1.name==null?value1:row1.name
3) please read the related 2927
Best regards
shong

Re: Tmap null pointer exception

Anonymous — Wed, 28 May 2008 09:29:27 GMT

Hi,
Thanks for your reply.
Normally my values cannot be null because the second iteration was maked with the same file and the same value in the lookup table.
It's seem due to lookup table during the loop, because the table was loaded only once.
How can we load the lookup table at each iteration ?
Thanks for reply
ben23

Re: Tmap null pointer exception

Anonymous — Thu, 29 May 2008 08:27:24 GMT

Hi,
Any idea for this problem ?
Thanks for reply,
Ben23

Re: Tmap null pointer exception

amaumont — Thu, 29 May 2008 09:12:18 GMT

Can you show us metadata of your tMap input tables ?

Re: Tmap null pointer exception

Anonymous — Thu, 29 May 2008 09:57:47 GMT

Hi,
You can find in upload image my configuration for tmap and TWaitForFile component. And the result of the job with the same data xml file and same data table for two iterations.
Thanks for reply,
ben23

Re: Tmap null pointer exception

Anonymous — Thu, 29 May 2008 10:29:28 GMT

Hello ben23
I have reproduced your job and checked that it should be a bug on tMap. Can you report a bug on our bugtracker with detailed information?
Thanks for your support!
Best regards

shong

Re: Tmap null pointer exception

Anonymous — Thu, 29 May 2008 10:51:19 GMT

Hi shong,
Sorry what do you want exactly ?
Should i make a report on this page http://www.talendforge.org/bugs/my_view_page.php ?
And in this case what i should post ?
Thanks for reply,
Ben23

Re: Tmap null pointer exception

amaumont — Thu, 29 May 2008 11:57:27 GMT

Your error come from an interaction problem between Iterate connection and free memory of lookups.
You can follow the 3966 which describe which modifications could be done from 2.4 RC3 before a definitive solution for 2.5.0.
We are being to find a definitive solution to this problem, in fact we have two choices for the moment:
- empty always lookups data from memory, which implies your error
- does not empty lookups data from memory, which implies that lookups data are accumulated in the different lookups of job
Two workarounds exist:
- comments all free memory/files calls into tMap_end.javajet template
> edit TOS-All-r14257-V2.4.0RC2/plugins/org.talend.designer.components.localprovider_2.4.0.RC2_r14257/components/tMap_end.inc.javajet
> comment lines 91, 111, 115 to keep data in memory and temporary files for next iterations
> tMap_end.javajet have to be modified also, add simply a space and save it to be recompiled
- design your job like :
Job1:
---Iterate---> tRunJob(call of job2)

Job2:
-----------------> tMap -> Output
--Lookup----->

Re: Tmap null pointer exception

Anonymous — Thu, 29 May 2008 14:29:17 GMT

Hi amaumont,
Thanks for your reply.
I try your solution to call my job with a tRunJob and it's worked. But with this solution I haven't a permanent connection, and it's a problem because my job must be in real time.
It's possible to share connection between two jobs ?
Regards,
ben23

Re: Tmap null pointer exception

amaumont — Thu, 29 May 2008 14:43:56 GMT

Sorry, we can't share variables between jobs for the moment, it will possible a day but I don't know when.
You can wait for the 2.4 RC4 or modify the templates like described above.
amaumont

Re: Tmap null pointer exception

Anonymous — Thu, 29 May 2008 14:46:30 GMT

Ok thanks for your answer.
Regards,
ben23

Re: Tmap null pointer exception

Anonymous — Mon, 12 Jul 2010 15:24:47 GMT

I have the same problem on Talend 4.0.2, but when I tried to execute the 1st workaround, I saw that the code was already removed in the files.

Re: Tmap null pointer exception

_AnonymousUser — Wed, 01 Feb 2012 04:17:34 GMT

Hi Everyone,
In my job.in tMap Component am getting null Pointer Exception Error.the error which am getting in my job is :
Exception in component tMap_1
java.lang.NullPointerException
at demo.bagmakers_new_0_1.BagMakers_New.tFileInputExcel_1Process(BagMakers_New.java:13692)
at demo.bagmakers_new_0_1.BagMakers_New.runJobInTOS(BagMakers_New.java:16145)
at demo.bagmakers_new_0_1.BagMakers_New.main(BagMakers_New.java:16016)
disconnected
Job BagMakers_New ended at 09:34 01/02/2012.
Can anyone help me out in resolving this error its urgent...
Thanks in Advance,
Sruthi

Re: Tmap null pointer exception

Anonymous — Wed, 01 Feb 2012 04:22:00 GMT

Hi Sruthi
You'd better upload screenshots of tMap.
Then we can figure out and fix it.
Regards,
Pedro

Re: Tmap null pointer exception

Anonymous — Thu, 12 Apr 2012 04:02:40 GMT

I have the exactly the same problem and when I executed the workaround the line of code was removed in the files. This post has been a great help.

Re: Tmap null pointer exception

Anonymous — Wed, 20 Nov 2013 13:38:23 GMT

Sorry to restart the thread.
But I am getting the same error in Talend 5.3.
Checked the component java file, but I dont find anything to be commented on line 91 and 111.
Please help me to resolve this. This has happened suddenly. I didn't face this issue earlier.
Keyur

Re: Tmap null pointer exception

janhess — Wed, 20 Nov 2013 14:22:20 GMT

We need more info such as map rule. You are probably doing some java processing on a null value in your map rule.

Re: Tmap null pointer exception

Anonymous — Thu, 21 Nov 2013 08:47:53 GMT

Thanks for the reply.
It is indeed the case. I have rectified it.

Re: Tmap null pointer exception

Anonymous — Tue, 23 Sep 2014 12:12:53 GMT

Hey,
I am having the same problem too, how do i solve this error ,
even due the records are saved to the database successfully i just dont like seeing this error and i not sure if it might make the job fail in future .

Thanks
chidozie