Loading an Excel File

TharunJoshi — Sat, 16 Nov 2024 04:33:01 GMT

Hi all,

I have an excel file which has 3933 records in it when I process them only 3932 records are getting processed and only last record is not processing (I have checked manually by putting 3932 in limit)

Exception in component tMap_1
java.lang.NullPointerException
at java.text.SimpleDateFormat.parse(Unknown Source)
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:928)
at routines.TalendDate.parseDate(TalendDate.java:886)
at advantage_bridge.amazon_childjob_0_1.Amazon_CHILDJOB.tFileList_1Process(Amazon_CHILDJOB.java:4722)
at advantage_bridge.amazon_childjob_0_1.Amazon_CHILDJOB.tJava_1Process(Amazon_CHILDJOB.java:788)
at advantage_bridge.amazon_childjob_0_1.Amazon_CHILDJOB.runJobInTOS(Amazon_CHILDJOB.java:8306)
at advantage_bridge.amazon_childjob_0_1.Amazon_CHILDJOB.main(Amazon_CHILDJOB.java:8065)
[statistics] disconnected

Re: Loading an Excel File

TRF — Fri, 27 Sep 2019 05:21:25 GMT

At l'East one of fields of the last record contains a null value which cause a null pointer exception as shown by the error message "tMap_1 java.lang.NullPointerException"

topic Re: Loading an Excel File in Talend Studio

Loading an Excel File

Re: Loading an Excel File