topic Re: [RESOLVED] NullPointerException - tFileOutPutDelimited - Send Mail in Talend Studio

[RESOLVED] NullPointerException - tFileOutPutDelimited - Send Mail

Roman01 — Fri, 15 Nov 2024 23:39:19 GMT

Hello Community,

I deploy already a job which send an email if we not found an ID employee. (pictures 1.1 , 1.2 ok)

However, when I change the schema to change a column name, when i run the job, I have a NULL pointer exception on my component tFileOutPutDelimited. ( pictures 2.1 , 2.2 ,2.3)... I do not really understand why the flush or talend is not working.

The tFileOutPutDelimited_2 is the same as the

The tFileOutPutDelimited_1 in my first job. Also for the tSendMail_2 is the same as the first one.

Why do I have nullpointerexception with the same components to send an email ??

Thanks a lot,

Kind regards.

Re: [RESOLVED] NullPointerException - tFileOutPutDelimited - Send Mail

Anonymous — Fri, 08 Oct 2021 02:35:01 GMT

Make sure the if condition expression has been set. If done, can you show us the expression?

Regards

Shong

Re: [RESOLVED] NullPointerException - tFileOutPutDelimited - Send Mail

Roman01 — Fri, 08 Oct 2021 07:41:43 GMT

Hi Shong,

thanks for your reply.

Yes the if condition is already been set in both job. I really not understnad where is the issue with the nullpointerexception ... Talend surprised me...

Job 1 ok : (picture 1.3) the flush is correct and we saw all green numbers rows of the flush are ok.

Job 2 not ok : with the same components as the job 1 ... (picture 2.4)

Do you think is better to re start a new job with new flush from scratch ?

Thanks.

Re: [RESOLVED] NullPointerException - tFileOutPutDelimited - Send Mail

gjeremy1617088143 — Fri, 08 Oct 2021 07:47:13 GMT

Hi, it's seems in your second job you made a condition on tFileOutputDelimited_1 instead of tFileOutputDelimited_2.

Send me love and kudos

Re: [RESOLVED] NullPointerException - tFileOutPutDelimited - Send Mail

Anonymous — Sat, 09 Oct 2021 03:29:04 GMT

Make sure you use the right global variable, if the global variable does not exist, it will returns null value that causes the NPE error.

Re: [RESOLVED] NullPointerException - tFileOutPutDelimited - Send Mail

Roman01 — Mon, 11 Oct 2021 06:58:19 GMT

THANK YOU very much.... I need some break I think sometimes !

I will try in a context variable if possible to avoid this mistake again...