Not able to start the camunda engine using mariadb

Camunda 7 Topics Discussion & Questions
1

We are trying to start camunda engine, connecting to a mariadb database, but getting error (see below). In the library folder of tomcat, there is a jar file containing class that extends org.camunda.bpm.container.impl.tomcat.TomcatBpmPlatformBootstrap to trigger the creation of the necessary db tables using flyway migration that execute mariadb sql scripts (fetched from camunda site). I also modified the conf/server.xml configuration to point to a mariadb database. Do you see any issue?

Error querying database. Cause: java.sql.SQLSyntaxErrorException: (conn=1048) Table ‘CAMUNDA_DB.ACT_GE_PROPERTY’ doesn’t exist

The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Property.xml

The error may involve org.camunda.bpm.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline

The error occurred while setting parameters

SQL: select * from ACT_GE_PROPERTY where NAME_ = ?

Cause: java.sql.SQLSyntaxErrorException: (conn=1048) Table ‘CAMUNDA_DB.ACT_GE_PROPERTY’ doesn’t exist

            at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
            at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectById(DbSqlSession.java:110)
            at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectById(DbEntityManager.java:212)
            at org.camunda.bpm.engine.impl.persistence.entity.PropertyManager.findPropertyById(PropertyManager.java:28)
            at org.camunda.bpm.engine.impl.HistoryLevelSetupCommand.checkStartupLockExists(HistoryLevelSetupCommand.java:106)
            at org.camunda.bpm.engine.impl.HistoryLevelSetupCommand.execute(HistoryLevelSetupCommand.java:38)
            at org.camunda.bpm.engine.impl.HistoryLevelSetupCommand.execute(HistoryLevelSetupCommand.java:30)
            at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:27)
2

@brajendra.kumar are you setting up the camunda for first time or upgrading the camunda version?

What’s your application setup? How does your process engine configuration and pom.xml file looks like?

3

@aravindhrs Thanks for the reply.

It is first time that I am setting up the camunda version 7.10. Camunda is run in tomcat container (camunda and engine-rest wars). I have attached server.xml and pom.xml.

pom.xml (1.5 KB) server.xml (3.0 KB)