Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
TharunJoshi
Contributor III
Contributor III

Loading an Excel File

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

 

Labels (3)
1 Reply
TRF
Champion II
Champion II

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"