timeStamp Error when Click the deployed workflow

[seema]

Hi
i m create a workflow in actviti 5.14 and wants to deploy in actviti 5.19 but its give error  java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp?
i m using Mysql 5.6 for database and Actviviti5.19.


full log error file in is attached bellow .?
plz help..

[vasile_dirla]

would be great if you could provide the xml file for your process so the other people could try it.

it seems there is a zero date to be inserted in the db and currently I don't know what is that date used for (maybe it should not be null or zero).

(if you will provide this parameter to the DB connection url: zeroDateTimeBehavior=convertToNull, the dates as '0000-00-00' will be automatically converted to NULL.)

[seema]

Thanks for your reply.
I am attaching my xml file which i created for the boundary timer event.

[vasile_dirla]

please check your database and see if you have in the table ACT_RE_DEPLOYMENT any entries with DEPLOY_TIME_ = 0000-00-00

[seema]

I have checked ACT_RE_DEPLOYMENT table. Yes, there is a entry with DEPLOY_TIME_ = 0000-00-00. The process which i deployed is stored with 0000-00-00 time.

[seema]

I am using activiti-5.19.0 , mysql Server version: 5.6.28-0ubuntu0.14.04.1 . when i deployed a process.bpmn20.xml file in activiti it is showing error which i have attached below in .txt format.
I gave an another try by changing db.properties file of activiti-explorer and added this code to db.properties ie.
jdbc.url=jdbc:mysql://localhost:3306/activiti?zeroDateTimeBehavior=convertToNull
After adding this code, process.bpmn20.xml deployment is successful. when i click on start, process instance is generated. But when i clicked on My instances tab , it is showing the following error:
invocation of method valueChange in org.activiti.explorer.ui.process.ProcessInstancePage$1 failed.