-
Bug Report
-
Resolution: Unresolved
-
L3 - Default
-
None
-
7.14.0-alpha3
-
None
Flag cmmnEnabled is set to false in egine's configuration (standalone-full.xml).
Fresh Database without any tables.
During startup the CMMN-related tables are not getting created as expected.
But when opening Camunda Cockpit error messages appear on WildFly's server.log:
### Error querying database. Cause: java.sql.SQLException: The specified table (act_re_case_def) is not in the database.### Error querying database. Cause: java.sql.SQLException: The specified table (act_re_case_def) is not in the database. ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/CaseDefinition.xml### The error may involve org.camunda.bpm.engine.impl.cmmn.entity.repository.CaseDefinitionEntity.selectCaseDefinitionCountByQueryCriteria ### The error occurred while executing a query### SQL: select count(distinct RES.ID_ ) from ACT_RE_CASE_DEF RES inner join (select KEY_, TENANT_ID_, max(VERSION_) as MAX_VERSION from ACT_RE_CASE_DEF group by TENANT_ID_, KEY_) VER on RES.KEY_ = VER.KEY_ WHERE RES.VERSION_ = VER.MAX_VERSION and (RES.TENANT_ID_ = VER.TENANT_ID_ or (RES.TENANT_ID_ is null and VER.TENANT_ID_ is null)) ### Cause: java.sql.SQLException: The specified table (act_re_case_def) is not in the database. 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.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.lambda$selectOne$3(DbSqlSession.java:122) at org.camunda.bpm.engine.impl.util.ExceptionUtil.doWithExceptionWrapper(ExceptionUtil.java:247)
Hi langfr,
thanks for opening this issue. I can confirm, that this is a bug.
If you want to contribute a fix we will gladly accept a pull request. Let us know if you want to work on it and if we can help you in any way.
Otherwise, I will forward the ticket for prioritization.
Enjoy your weekend! Cheers,
Miklas