Getting error in date field while generating report

[manoj.p]

Hi,

Iam generating a simple report in jasper studio and im using mysql database.

I have a date field in mysql it is in  Current_Timestamp.

But during ETL process some fields are  filled with (0000-00-00 00:00:00) when i run the report it will give   "Unable to get value for field 'date' of class 'java.sql.Timestamp"  error.

Can anyone help me please??

Thanks in advance.

 

[hozawa]

Fix your database table to default date to the current date/time.