Exception in component tMap java.lang.NullPointerException

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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