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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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"