I get this error "exception occurred in the persistence layer" with "column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist"

Maik · June 14, 2022, 9:13am

Hello Camunda Community/Devs

I added a new Service Task to my model and now the process crashes once I reach that task.
What information should I provide, so that you can help me?

I run

Spring Boot Application
Camunda Engine v7.17.0

Most of the Error:

2022-06-14 11:01:10.649 ERROR 12284 --- [nio-8080-exec-7] org.camunda.bpm.engine.context           : ENGINE-16004 Exception while closing command context: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.

org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
	at org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:133) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:364) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:323) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:295) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:272) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:188) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:72) ~[camunda-engine-spring-7.17.0.jar:7.17.0]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.15.jar:5.3.15]
	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:70) ~[camunda-engine-spring-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.FormServiceImpl.submitTaskForm(FormServiceImpl.java:91) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.rest.sub.task.impl.TaskResourceImpl.submit(TaskResourceImpl.java:153) ~[camunda-engine-rest-jaxrs2-7.17.0.jar:7.17.0]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
[...]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.56.jar:9.0.56]
	at java.base/java.lang.Thread.run(Thread.java:833) ~[na:na]
Caused by: org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation 'INSERT ExternalTaskEntity[29767]' with message '
### Error flushing statements.  Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
org.postgresql.util.PSQLException: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344
org.postgresql.util.PSQLException: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344
'. Flush summary: 
 [
  INSERT HistoricVariableInstanceEntity[29759]
  INSERT UserOperationLogEntryEventEntity[29762]
  INSERT HistoricVariableUpdateEventEntity[29761]
  INSERT HistoricVariableUpdateEventEntity[29763]
  INSERT HistoricExternalTaskLogEntity[29768]
  INSERT HistoricActivityInstanceEventEntity[Activity_0fimz6v:29766]
  INSERT HistoricActivityInstanceEventEntity[Gateway_1lxbnbr:29764]
  INSERT ExecutionEntity[29765]
  INSERT VariableInstanceEntity[29759]
  INSERT ExternalTaskEntity[29767]
  DELETE TaskEntity[29390]
  UPDATE ExecutionEntity[29349]
  DELETE ExecutionEntity[29388]
  UPDATE HistoricActivityInstanceEventEntity[Activity_1q3n3fr:29389]
  UPDATE HistoricTaskInstanceEventEntity[29390]
]
	at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:132) ~[camunda-engine-7.17.0.jar:7.17.0]
	... 160 common frames omitted
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error flushing statements.  Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:254) ~[mybatis-3.5.6.jar:3.5.6]
	at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushBatchOperations(DbSqlSession.java:444) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.db.sql.BatchDbSqlSession.executeDbOperations(BatchDbSqlSession.java:74) ~[camunda-engine-7.17.0.jar:7.17.0]
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:341) ~[camunda-engine-7.17.0.jar:7.17.0]
	... 159 common frames omitted
Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:149) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:114) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:252) ~[mybatis-3.5.6.jar:3.5.6]
	... 162 common frames omitted
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
	at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165) ~[postgresql-42.3.1.jar:42.3.1]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365) ~[postgresql-42.3.1.jar:42.3.1]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:558) ~[postgresql-42.3.1.jar:42.3.1]
	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:881) ~[postgresql-42.3.1.jar:42.3.1]
	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:904) ~[postgresql-42.3.1.jar:42.3.1]
	at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1634) ~[postgresql-42.3.1.jar:42.3.1]
	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) ~[HikariCP-4.0.3.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na]
	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:123) ~[mybatis-3.5.6.jar:3.5.6]
	... 166 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2674) ~[postgresql-42.3.1.jar:42.3.1]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2364) ~[postgresql-42.3.1.jar:42.3.1]
	... 173 common frames omitted

2022-06-14 11:01:10.652  WARN 12284 --- [nio-8080-exec-7] org.camunda.bpm.engine.rest.exception    : ENGINE-REST-HTTP500 org.camunda.bpm.engine.rest.exception.RestException: Cannot submit task form 29390: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
	at org.camunda.bpm.engine.rest.sub.task.impl.TaskResourceImpl.submit(TaskResourceImpl.java:170)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
[...]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
	at org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263)
	at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:133)
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:364)
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:323)
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:295)
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:272)
	at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:188)
	at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119)
	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:72)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:70)
	at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)
	at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35)
	at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
	at org.camunda.bpm.engine.impl.FormServiceImpl.submitTaskForm(FormServiceImpl.java:91)
	at org.camunda.bpm.engine.rest.sub.task.impl.TaskResourceImpl.submit(TaskResourceImpl.java:153)
	... 146 more
Caused by: org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation 'INSERT ExternalTaskEntity[29767]' with message '
### Error flushing statements.  Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
org.postgresql.util.PSQLException: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344
org.postgresql.util.PSQLException: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344
'. Flush summary: 
 [
  INSERT HistoricVariableInstanceEntity[29759]
  INSERT UserOperationLogEntryEventEntity[29762]
  INSERT HistoricVariableUpdateEventEntity[29761]
  INSERT HistoricVariableUpdateEventEntity[29763]
  INSERT HistoricExternalTaskLogEntity[29768]
  INSERT HistoricActivityInstanceEventEntity[Activity_0fimz6v:29766]
  INSERT HistoricActivityInstanceEventEntity[Gateway_1lxbnbr:29764]
  INSERT ExecutionEntity[29765]
  INSERT VariableInstanceEntity[29759]
  INSERT ExternalTaskEntity[29767]
  DELETE TaskEntity[29390]
  UPDATE ExecutionEntity[29349]
  DELETE ExecutionEntity[29388]
  UPDATE HistoricActivityInstanceEventEntity[Activity_1q3n3fr:29389]
  UPDATE HistoricTaskInstanceEventEntity[29390]
]
	at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:132)
	... 160 more
Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error flushing statements.  Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:254)
	at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushBatchOperations(DbSqlSession.java:444)
	at org.camunda.bpm.engine.impl.db.sql.BatchDbSqlSession.executeDbOperations(BatchDbSqlSession.java:74)
	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:341)
	... 159 more
Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.insertExternalTask (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:149)
	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129)
	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122)
	at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:114)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:252)
	... 162 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into ACT_RU_EXT_TASK (
      ID_,
      WORKER_ID_,
      TOPIC_NAME_,
      LOCK_EXP_TIME_,
      RETRIES_,
      ERROR_MSG_,
      ERROR_DETAILS_ID_,
      SUSPENSION_STATE_,
      EXECUTION_ID_,
      PROC_INST_ID_,
      PROC_DEF_ID_,
      PROC_DEF_KEY_,
      ACT_ID_,
      ACT_INST_ID_,
      TENANT_ID_,
      PRIORITY_,
      LAST_FAILURE_LOG_ID_,
      REV_
    ) values (
      '29767',
      NULL,
      'create-inquiry',
      NULL,
      NULL,
      NULL,
      NULL,
      1,
      '29765',
      '29349',
      'Process_Vertriebsanfrage:1:29308',
      'Process_Vertriebsanfrage',
      'Activity_0fimz6v',
      'Activity_0fimz6v:29766',
      NULL,
      0,
      NULL,
      1
    ) was aborted: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344  Call getNextException to see other errors in the batch.
	at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:558)
	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:881)
	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:904)
	at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1634)
	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:123)
	... 166 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "last_failure_log_id_" of relation "act_ru_ext_task" does not exist
  Position: 344
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2674)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2364)
	... 173 more

Note: I read several of the similar topics here, but either they didn’t apply to my situation, or they haven’t actually been answered.
Examples:

So I would also be happy if those would be answered.

GotnOGuts · June 14, 2022, 8:49pm

Have you ever updated your Engine?

If so, you MUST also run the DB upgrade scripts. LAST_FAILURE_LOG_ID_ was a column added in one of the upgrades, which suggests that you updated your Engine (eg. 7.16 to 7.17) without updating the DB.

Maik · June 15, 2022, 6:44am

I saw the Update from 7.16 to 7.17 | docs.camunda.org

But I don’t really understand how I am supposed to run the script.
Here Install the Database Schema | docs.camunda.org it says

Execute the corresponding update scripts

That is nice, but how?

Maik · June 15, 2022, 7:25am

For example this step (if I would want to use Liquibase)

You can pass on the connection details to your database instance via parameters as described in the Liquibase documentation

I don’t know my connection details, since it is a spring boot application. And I don’t know where my current DB is, so that I don’t even know where to point this tool to.

GotnOGuts · June 15, 2022, 5:25pm

Unfortunately, if you don’t know where your database is, there’s not a lot I can do to help you.
You need to know how to connect to your database, and how to apply SQL scripts to maintain a system that has a database in it.

From the link you shared, following through to Maven, I could find the script that does the “ALTER TABLE” command to add the LAST_FAILURE_LOG_ID_ column (which was added to the software in 7.17)

If you can’t figure out how to update your database, then perhaps try with 7.16 software (same level as your database is on).

I would expect that somewhere in your Spring Boot application you configured your Database connection. That might be a good place to start.

Maik · June 20, 2022, 12:30pm

Thank you for replying.
I found it and was able to run the Camunda supplied script with DBeaver.

Version 7.16 was a non-option for us, because of some of the Tasklist UI.

system · January 31, 2024, 10:18am