search

camunda / camunda-bpm-platform

Flexible framework for workflow and decision automation with BPMN and DMN. Integration with Quarkus, Spring, Spring Boot, CDI.
https://camunda.com/
Apache License 2.0
4.12k stars 1.56k forks source link

Camunda Cockpit is not aware of cmmnEnabled = false #2410

Open ThorbenLindhauer opened 4 years ago

ThorbenLindhauer commented 4 years ago

This issue was imported from JIRA:

Field Value
JIRA Link CAM-12465
Reporter d0dqRLp
What is this name? This pseudonym name was generated based on the user name in JIRA to protect the personal data of our JIRA users. You can use this identifier to search for issues by the same reporter.
Has restricted visibility comments true

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:

    1. 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.
    1. 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
    1. 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))
    1. 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)

Links:

ThorbenLindhauer commented 4 years ago

This comment was imported from JIRA and written by user @mboskamp

Hi d0dqRLp,

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

ThorbenLindhauer commented 4 years ago

This comment was imported from JIRA and written by user @ThorbenLindhauer

Hi Frank,

Thanks for raising the ticket. We will try to address it during 7.15 development, but cannot promise it at this point. If you would like to fix it yourself, that is also very welcome and we can help with the implementation approach.

Best regards, Thorben