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  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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi,

Please try this solution
 
row1.Leave_Status !=null || row1.Leave_Status.equals("")? value if true: value if false method.
 
Best regards
Sabrina

[Anonymous]

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

[_AnonymousUser]

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 .

[Anonymous]

Thank you so much, it works.

[Anonymous]

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.