Nested exception is java.sql.SQLException: Cannot convert value '2018-10-17 09:40:10.000000' from column 6 to TIMESTAMP


#1

hi all: The error happen when I create a new model process with Flowable Modeler Designer.

below is error trace:
Caused by: java.lang.NumberFormatException: $958e538c-d1ad-11e8-bd25-002324ea9ce8Item Audit ProcessitemAuditProcess ?2018-10-17 09:40:10.000000admin2018-10-17 09:40:10.000000admin1黷{“id”:“canvas”,“resourceId”:“canvas”,“stencilset”:{“namespace”:“http://b3mn.org/stencilset/bpmn2.0#"},“properties”:{“process_id”:“itemAuditProcess”,“name”:"Item Audit Process”},“childShapes”:[{“bounds”:{“lowerRight”:{“x”:130,“y”:193},“upperLeft”:{“x”:100,“y”:163}},“childShapes”:[],“dockers”:[],“outgoing”:[],“resourceId”:“startEvent1”,“stencil”:{“id”:“StartNoneEvent”}}]}?塒NG

Regards.
JINLIANG LIU


#2

Which database are you using?


#3

Sorry!I use mysql 5.6.Thanks!

Additionally,same tables were locked.Below error logs on bootstrap.
2018-10-24 15:31:45.791 INFO 22356 — [ main] l.e.j.JdbcExecutor : SELECT LOCKED FROM mysql.ACT_ADM_DATABASECHANGELOGLOCK WHERE ID=1
2018-10-24 15:31:45.795 INFO 22356 — [ main] l.l.StandardLockService : Waiting for changelog lock…