topic Re: Exception in component tMap java.lang.NullPointerException in Talend Studio

Exception in component tMap java.lang.NullPointerException

Anonymous — Fri, 07 Aug 2015 07:22:42 GMT

Hello,
I have a very simple job with one Excel spreadsheet as an input file, a tmap component and another Excel spreadsheet as an output file. I have been to many posts and tried a lot of solutions but nothing works. What is strange is that I have no null value in my spreadsheet.
This is the complete error message:

"Exception in component tMap_2
java.lang.NullPointerException
at leave_calendar.xero_integration_with_salesfoce_0_1.Xero_integration_with_Salesfoce.tFileInputExcel_3Process(Xero_integration_with_Salesfoce.java:1286)
at leave_calendar.xero_integration_with_salesfoce_0_1.Xero_integration_with_Salesfoce.runJobInTOS(Xero_integration_with_Salesfoce.java:1677)
at leave_calendar.xero_integration_with_salesfoce_0_1.Xero_integration_with_Salesfoce.main(Xero_integration_with_Salesfoce.java:1558)"

I have attached a capture of my tmap.

This is an extract of my Excel spreadsheet:

Employee	Employee Group	Leave Status	Leave Type	Start Date	End Date
Carissa Perdulovski	QLD	Scheduled	Personal/Carer's Leave	4/08/2015	4/08/2015
Carol Arnold	QLD	Rejected	Annual Leave	21/08/2015	21/08/2015
Charline Mitchener	QLD	Approved	Annual Leave	16/08/2015	20/08/2015

Any help will be very much appreciated. Thank you in advance.
Sylvie

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Fri, 07 Aug 2015 08:16:44 GMT

Hi ultima67,
Could you please upload your screenshot of tMap editor into forum which will be helpful for us to address your issue quickly?
Best regards
Sabrina

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Mon, 10 Aug 2015 00:03:28 GMT

Sorry,
I thought when the image was uploaded it will be attached automatically to the message.
Here it is:

Thank you
Sylvie

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Mon, 10 Aug 2015 03:32:31 GMT

Hi,
This issue is probably caused by a null value.
Could you please firstly check row1.Leave_Status != null
after then using your Condition?value if true: value if false method?
Best regards
Sabrina

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Mon, 10 Aug 2015 04:47:23 GMT

Hi,
Same error message "NullPointerExeption" after adding the expression"
"row1.Leave_Status !=null?"":row1 .Leave_Status" in the column Leave_Status on theLeaveRequestOut component.
Best regards,
Sylvie

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Mon, 10 Aug 2015 05:14:18 GMT

Hi,

Please try this solution

row1.Leave_Status !=null || row1.Leave_Status.equals("")? value if true: value if false method.

Best regards
Sabrina

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Mon, 10 Aug 2015 06:02:42 GMT

Hi Sabrina,
I have amended my expression :
"row1.Leave_Status!=null|| row1.Leave_Status.equals("")?"":row1 .Leave_Status"
Still get same error message.
Thanks
Sylvie

Re: Exception in component tMap java.lang.NullPointerException

_AnonymousUser — Mon, 10 Aug 2015 06:41:55 GMT

Hi,
once try this solution.
Click on excel component and goto Advanced Settings and Check the Stop to Read on Empty Rows button .
and run the job .

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Mon, 10 Aug 2015 07:06:36 GMT

Thank you so much, it works.

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Mon, 17 Aug 2015 05:51:07 GMT

Hello,
Everything worked fine last week, and when I ran the job again this morning I got again the same error message. It is strange because I didn't change anything. Any idea? Thank you.

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Tue, 18 Aug 2015 04:01:07 GMT

Hi,
Did you change your input excel file? Have you tried to check out "Trim" option in Advanced Settings of tfileinputexcel to trim the leading and trailing white space?

Best regards
Sabrina

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Tue, 18 Aug 2015 07:01:50 GMT

Hi,
Yes, the input file is new every week. It is a report generated by another software. Only the data change not the structure, it is always the same report. I have re-run the report and it works again. Very strange.... I will try to check out "Trim" option as recommended.
Thank you for your help.
Best regards,
Sylvie

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Tue, 18 Aug 2015 09:22:14 GMT

Here is a good way of solving this issue ( http://www.rilhia.com/node/45). Talend actually provides a hidden mechanism in the tMap to reveal the row that has caused an issue like this. From that you can quite quickly solve this.

Re: Exception in component tMap java.lang.NullPointerException

Anonymous — Wed, 05 Dec 2018 19:43:36 GMT

The (http://www.rilhia.com/node/45) link doesn't seem to open. Could you please post here the mechanism in the tMap to reveal the row that has caused NullPointerException .

Thanks,

Pradeep