Error datetime

Camunda 7 Topics Discussion & Questions
,
1

in the cryo form a variable that calculates a date and the value is put into that variable. but if the date value gives 2019-11-03 gives the following error. seems to be a mistake in mysql, only occurs with this date

Cannot submit task form 632887bf-de49-11e9-8056-005056ae67f1: ENGINE-03083 Exception while executing Batch Database Operations with message ’ ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.insertHistoricJobLogEvent (batch index #2) failed. 1 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Data truncation: Incorrect datetime value: ‘2019-11-03 00:00:00’ for column ‘JOB_DUEDATE_’ at row 1 ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.insertHistoricJobLogEvent (batch index #2) failed. 1 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Data truncation: Incorrect datetime value: ‘2019-11-03 00:00:00’ for column ‘JOB_DUEDATE_’ at row 1 java.sql.BatchUpdateException: Data truncation: Incorrect datetime value: ‘2019-11-03 00:00:00’ for column ‘JOB_DUEDATE_’ at row 1 com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: ‘2019-11-03 00:00:00’ for column ‘JOB_DUEDATE_’ at row 1 '. Flush summary: [ INSERT HistoricVariableInstanceEntity[8d6f6fd2-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d6f6fd5-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d6f6fd8-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d6f6fda-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d6f6fdc-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d70323a-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d70323b-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d70323c-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d70323d-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d70323e-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d70323f-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703240-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703241-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703242-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703243-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703244-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703245-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703246-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703247-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703248-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d703249-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableInstanceEntity[8d70324a-de49-11e9-8056-005056ae67f1] INSERT HistoricJobLogEventEntity[8d6fe415-de49-11e9-8056-005056ae67f1] INSERT HistoricJobLogEventEntity[8d700b26-de49-11e9-8056-005056ae67f1] INSERT HistoricJobLogEventEntity[8d708082-de49-11e9-8056-005056ae67f1] INSERT HistoricJobLogEventEntity[8d708084-de49-11e9-8056-005056ae67f1] INSERT AuthorizationEntity[8d708086-de49-11e9-8056-005056ae67f1] INSERT UserOperationLogEntryEventEntity[8d6f96f4-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d6f6fd4-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d6f6fd6-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d6f6fd7-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d6f6fd9-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d6f6fdb-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d6f6fdd-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d70595c-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d70595d-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d70595e-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d70595f-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705960-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705961-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705962-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705963-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705964-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705965-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705966-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705967-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705968-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d705969-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d70596a-de49-11e9-8056-005056ae67f1] INSERT HistoricVariableUpdateEventEntity[8d70596b-de49-11e9-8056-005056ae67f1] ]

2

To solve this problem just update the mysql-connector version

2 Likes
3

Hey man,
I know this is closed but as a note: This issue is likely related to Daylight Savings Time. 11-03 was the end of DST. I hit this error today in our scheduler, which is the start of DST. The error happened on our system only for an hour, between 02:00 and 03:00.

-M

4