Camunda Database Update Exception (UNKNWON column error on new Deployment)

Camunda 7 Topics Discussion & Questions
1

I am using Camunda version v7.9.0 integrated with Spring boot using Camunda BPM Spring Boot Starter.
I was able to create the basic flow and It was running as expected.
After making some changes in the flow and deploying it again, I am getting the following error:

### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ResourceEntity.insertResource (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Unknown column 'TYPE_' in 'field list'

and

### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.JobEntity.insertTimer (batch index #1) failed. Cause: java.sql.BatchUpdateException: Unknown column 'CREATE_TIME_' in 'field list'
### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.JobEntity.insertTimer (batch index #1) failed. Cause: java.sql.BatchUpdateException: Unknown column 'CREATE_TIME_' in 'field list'

Some details around the issue:

  • TYPE_ column is present in the database in act_ru_job table.
  • I have not changed Camunda version or Spring version.
  • I guess this is specific to Timer entity I am using for continous update.

I am not sure what changed which resulted in unknown column issue in the Camunda database.

Spring and Camunda Versions as mentioned below:

  • Spring Boot: 2.0.3.RELEASE
  • camunda-bpm-spring-boot-starter-webapp: 3.0.0

Any help would be appreciated. Thanks.

2

What is the version of the Camunda Spring Boot Starter?

3

Hey Yana, I have updated the question with respective versions I am using. Please check.