[resolved] tmap-How do i check null pointer exception in DATE data type
We are getting information while sending info from source to target system.
Exception in component tMap_1
java.lang.NullPointerException at bigdata.copy_of_readsysproandsendmail_0_1.Copy_of_ReadSysproAndSendMail.tJDBCInput_2Process(Copy_of_ReadSysproAndSendMail.java:1937) at bigdata.copy_of_readsysproandsendmail_0_1.Copy_of_ReadSysproAndSendMail.runJobInTOS(Copy_of_ReadSysproAndSendMail.java:5086) at bigdata.copy_of_readsysproandsendmail_0_1.Copy_of_ReadSysproAndSendMail.main(Copy_of_ReadSysproAndSendMail.java:4885)
at bigdata.copy_of_readsysproandsendmail_0_1.Copy_of_ReadSysproAndSendMail.tJDBCInput_2Process(Copy_of_ReadSysproAndSendMail.java:2098) at bigdata.copy_of_readsysproandsendmail_0_1.Copy_of_ReadSysproAndSendMail.runJobInTOS(Copy_of_ReadSysproAndSendMail.java:5355) at bigdata.copy_of_readsysproandsendmail_0_1.Copy_of_ReadSysproAndSendMail.main(Copy_of_ReadSysproAndSendMail.java:5154) Job Copy_of_ReadSysproAndSendMail ended at 23:16 03/10/2016. [exit code=0]
Input : Date data type is responsible for null values. DNDB date type(source) ---->row1.DNDB(output) is Date data type. both are nullable. We tried :But did not work for us. To avoid null row1.DNDB==null?"null":row1.DNDB
Null pointer exceptions can be real pain to identify. If you can share following details, it may be easier to answer your qyery:
1. How much complex is your tMap? Can you share a screenshot of the logic?
2. Try to take disconnect all inputs from tMap and attach them to tLogRow to see if any of the input column is coming as null where it should not be.
4. Use the debug mode to run your program(in case you are not processing lot of data). Debug mode will stop when it encounters the error.
3. Try to define all columns as nullable and see if error is still there. If error is no longer there then try to change the columns back to not nullable till you get the error.
