Cannot Delete Deployments - Postgres Error

Camunda 7 Topics Discussion & Questions
1

When trying to delete deployments (processes or decisions) I get an error on all deployments. It does not matter if I check cascade or not. I keep getting the same error:

image

Checking the server logs I see this:

### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/CamundaFormDefinition.xml
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.CamundaFormDefinitionEntity.selectCamundaFormDefinitionByDeploymentId-Inline
### The error occurred while setting parameters
### SQL: select * from ACT_RE_CAMFORMDEF where DEPLOYMENT_ID_ = ?
### Cause: org.postgresql.util.PSQLException: ERROR: relation "act_re_camformdef" does not exist
  Position: 15
                at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
                at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.lambda$executeSelectList$1(DbSqlSession.java:111)
                at org.camunda.bpm.engine.impl.util.ExceptionUtil.doWithExceptionWrapper(ExceptionUtil.java:254)
                ... 87 more
        Caused by: org.postgresql.util.PSQLException: ERROR: relation "act_re_camformdef" does not exist
  Position: 15
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
                at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
                at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
                at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
                at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157)
                at jdk.internal.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
                at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                at java.base/java.lang.reflect.Method.invoke(Method.java:566)
                at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
                at com.sun.proxy.$Proxy4.execute(Unknown Source)
                at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
                at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
                at org.apache.ibatis.executor.BatchExecutor.doQuery(BatchExecutor.java:92)
                at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)

What can be done to resolve this? I haven’t noticed any other errors while using Camunda. Thanks!

2

Hi @CraigS
A few questions to clarify.

  1. What Camunda version are you running?
  2. Did you perform any upgrades recently?
  3. Did it ever work before?
3

@Alex_Voloshyn Thanks for the quick reply. Here are the answers to your questions:

  1. 7.16.0
  2. We moved from Docker to Tomcat but I am not certain if that was the point at which deletions stopped working. The timeline isn’t exactly clear to me.
  3. I have been able to delete deployments before without issue.
4

Table ACT_RE_CAMFORMDEF was added in camunda 7.16. Do you really have this table in your database?

5

Did you upgrade Camunda version during this move?

6

@Alex_Voloshyn Thanks, that was the exact issue. Our docker container was pointed 7.15 but Tomcat was pointed to 7.16. We got it working.

@MaximMonin Thanks for the input, it was indeed a versioning issue when we moved from Tomcat to Docker.