Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am receiving a null pointer exception in my tmap where I am mapping and xls file into an oracle database. Previous files have worked fine but I cannot figure out why this one is erroring out. There dont appear to be any column changes in the file from previous files and I have added null handling for all my columns. Columns are string, dates, or integers
row5.DISTR_LOC == null ? null : row5.DISTR_LOC (format for string)
row5.DOB.isEmpty() || row5.DOB.equals("")? null: TalendDate.parseDate("MM/dd/yyyy",row5.DOB) (format for date)
row5.QUANTITY_SHIPPED != null? row5.QUANTITY_SHIPPED : 0 (format for int)
Is there something I am missing or how can I debug to figure out what is causing the issue in the file?
Any help is greatly appreciated!