Null pointer exception error

[Anonymous]

Hi,

tMssqlInput -> tJavaRow -> tDBRow(Delete query)

This is my job flow. There is no data in input table and I have used date in where condition of delete query. I am getting following error:

Exception in component tJavaRow_1 (Emp_Del)
java.lang.NullPointerException
at java.util.Calendar.setTime(Unknown Source)
at routines.system.FastDateParser$DateParser.format(FastDateParser.java:99)
at java.text.DateFormat.format(Unknown Source)
at routines.TalendDate.formatDate(TalendDate.java:135)
at drc_etl_dw.emp_del_0_1.Emp_Del.tDBInput_1Process(Emp_Del.java:1328)
at drc_etl_dw.emp_del_0_1.Emp_Del.runJobInTOS(Emp_Del.java:2014)
at drc_etl_dw.emp_del_0_1.Emp_Del.main(Emp_Del.java:1505)

How to solve the error?

Thanks,

Dhara

[Anonymous · Accepted solution]

Hi Dhara,

     The error is in tjavarow  which means you are trying to do some date processing using some java functions and when null value is coming, its throwing error.

     Could you please add Null condition check in your logic and avoid doing date processing for null values? Then things will work fine. If you are still facing the issue, please share the logic you are using with tJavarow and we can take it from there.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂