topic Re: timeStamp Error when Click the deployed workflow in Alfresco Archive

timeStamp Error when Click the deployed workflow

seema — Mon, 07 Mar 2016 12:18:41 GMT

Hii 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..

Re: timeStamp Error when Click the deployed workflow

vasile_dirla — Mon, 07 Mar 2016 12:38:41 GMT

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.)

Re: timeStamp Error when Click the deployed workflow

seema — Mon, 07 Mar 2016 12:55:51 GMT

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

Re: timeStamp Error when Click the deployed workflow

vasile_dirla — Mon, 07 Mar 2016 13:49:27 GMT

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

Re: timeStamp Error when Click the deployed workflow

seema — Tue, 08 Mar 2016 05:39:34 GMT

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.

Re: timeStamp Error when Click the deployed workflow

seema — Tue, 08 Mar 2016 06:52:30 GMT

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.