https://community.qlik.com/t5/Talend-Studio/resolved-NullPointerException-tMap/m-p/2368506#M131761 <P>Hello,<BR />I am receiving a null pointer exception in &nbsp;my tmap where I am mapping and xls file into an oracle database. &nbsp;Previous files have worked fine but I cannot figure out why this one is erroring out. &nbsp;There dont appear to be any column changes in the file from previous files and I have added null handling for all my columns. &nbsp;Columns are string, dates, or integers<BR />&nbsp;&nbsp;row5.DISTR_LOC == null ? null : row5.DISTR_LOC (format for string)<BR />row5.DOB.isEmpty() || row5.DOB.equals("")? null: TalendDate.parseDate("MM/dd/yyyy",row5.DOB) &nbsp;(format for date)<BR />row5.QUANTITY_SHIPPED != null? row5.QUANTITY_SHIPPED : 0 &nbsp;(format for int)<BR />Is there something I am missing or how can I debug to figure out what is causing the issue in the file?<BR />Any help is greatly appreciated!</P> Thu, 27 Oct 2016 00:59:23 GMT Anonymous 2016-10-27T00:59:23Z https://community.qlik.com/t5/Talend-Studio/resolved-NullPointerException-tMap/m-p/2368506#M131761 <P>Hello,<BR />I am receiving a null pointer exception in &nbsp;my tmap where I am mapping and xls file into an oracle database. &nbsp;Previous files have worked fine but I cannot figure out why this one is erroring out. &nbsp;There dont appear to be any column changes in the file from previous files and I have added null handling for all my columns. &nbsp;Columns are string, dates, or integers<BR />&nbsp;&nbsp;row5.DISTR_LOC == null ? null : row5.DISTR_LOC (format for string)<BR />row5.DOB.isEmpty() || row5.DOB.equals("")? null: TalendDate.parseDate("MM/dd/yyyy",row5.DOB) &nbsp;(format for date)<BR />row5.QUANTITY_SHIPPED != null? row5.QUANTITY_SHIPPED : 0 &nbsp;(format for int)<BR />Is there something I am missing or how can I debug to figure out what is causing the issue in the file?<BR />Any help is greatly appreciated!</P> Thu, 27 Oct 2016 00:59:23 GMT https://community.qlik.com/t5/Talend-Studio/resolved-NullPointerException-tMap/m-p/2368506#M131761 Anonymous 2016-10-27T00:59:23Z https://community.qlik.com/t5/Talend-Studio/resolved-NullPointerException-tMap/m-p/2368507#M131762 Hi &nbsp; <BR />I see this topic has been marked as resolved, I think you have fixed the problem. Don't hesitate to post if you still have issues. <BR /> <BR />Regards <BR />Shong Thu, 27 Oct 2016 01:43:19 GMT https://community.qlik.com/t5/Talend-Studio/resolved-NullPointerException-tMap/m-p/2368507#M131762 Anonymous 2016-10-27T01:43:19Z