[resolved] tmap-How do i check null pointer exception in DATE data type

gt0731 — Sat, 16 Nov 2024 10:20:50 GMT

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

Re: [resolved] tmap-How do i check null pointer exception in DATE data type

Anonymous — Tue, 04 Oct 2016 05:33:51 GMT

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.

topic Re: [resolved] tmap-How do i check null pointer exception in DATE data type in Talend Studio

[resolved] tmap-How do i check null pointer exception in DATE data type

Re: [resolved] tmap-How do i check null pointer exception in DATE data type