Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

parseDate change from 5.0.3 to 5.2.2? by Kwags300
How do [...] by slowenthal
Problem whit context variable in query. by Ginetto
Problem with SELECT a.name AS a_name, b.name AS b_name input by kacper
get last row that raised an oracle exception while using tOracleOutput by ed.pag
Component to Connet,Retrieve data from MS OLAP Cube by talend_bso1
'No data found' java exception by asouini

Index
» Usage, Operation
» Tmap null pointer exception

Post a reply

Write your message and submit

Name

E-mail

Message

Options

Never show smilies as icons for this post

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

martha.author: 2012-04-12 05:02:40

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.

pedro: 2012-02-01 05:22:00

Hi Sruthi

You'd better upload screenshots of tMap.
Then we can figure out and fix it.

Regards,
Pedro

Sruthi: 2012-02-01 05:17:34

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)
[statistics] disconnected
Job BagMakers_New ended at 09:34 01/02/2012. [exit code=1]

Can anyone help me out in resolving this error its urgent...

Thanks in Advance,
Sruthi

TomasAlmeida: 2010-07-12 16:24:47

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.

ben23: 2008-05-29 15:46:30

Ok thanks for your answer.

Regards,

ben23

amaumont: 2008-05-29 15:43:56

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

ben23: 2008-05-29 15:29:17

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

amaumont: 2008-05-29 12:57:27

Your error come from an interaction problem between Iterate connection and free memory of lookups.

You can follow the [Bugtracker] bug 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:
[Component with Iterate] ---Iterate---> tRunJob(call of job2)

Job2:
[Input] -----------------> tMap -> Output
[input] --Lookup----->

ben23: 2008-05-29 11:51:19

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

shong: 2008-05-29 11:29:28

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

ben23: 2008-05-29 10:57:47

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

amaumont: 2008-05-29 10:12:18

Can you show us metadata of your tMap input tables ?

ben23: 2008-05-29 09:27:24

Hi,

Any idea for this problem ?

Thanks for reply,

Ben23

ben23: 2008-05-28 10:29:27

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

shong: 2008-05-28 08:07:28

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 topic:2927

Best regards

shong

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Board footer