Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-1238

Query exception in cockpit with multiple tenants/schemas

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.0.1, 7.1.0, 7.1.0-alpha1
    • None
    • cockpit
    • None

      see attached fix for query

      When inspecting process variables in cockpit we get an exception:

      Caused by: org.h2.jdbc.JdbcSQLException: Tabelle "ACT_RU_INCIDENT" nicht gefunden
      Table "ACT_RU_INCIDENT" not found; SQL statement:
      select
      INSTANCE.ID_,
      INSTANCE.BUSINESS_KEY_,
      INSTANCE.START_TIME_,
      INCIDENT.INCIDENT_TYPE_,
      INCIDENT.INCIDENT_COUNT_
      from
      (

      select RES.* ,

      HISTORY.START_TIME_

      from
      cc.ACT_RU_EXECUTION RES

      left join
      cc.ACT_HI_PROCINST HISTORY
      ON
      RES.ID_ = HISTORY.PROC_INST_ID_

      WHERE RES.ID_ = RES.PROC_INST_ID_

      and RES.PROC_DEF_ID_ = ?

      order by START_TIME_ asc
      LIMIT ? OFFSET ?
      ) INSTANCE

      left join
      (

      select
      INCIDENT.PROC_INST_ID_, INCIDENT.INCIDENT_TYPE_, count(INCIDENT.ID_) INCIDENT_COUNT_
      from
      ACT_RU_INCIDENT INCIDENT

      where
      INCIDENT.PROC_DEF_ID_ = ?

      group by
      INCIDENT.PROC_INST_ID_, INCIDENT.INCIDENT_TYPE_
      ) INCIDENT
      on
      INSTANCE.ID_ = INCIDENT.PROC_INST_ID_ [42102-168]
      at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
      at org.h2.message.DbException.get(DbException.java:169)
      at org.h2.message.DbException.get(DbException.java:146)
      at org.h2.command.Parser.readTableOrView(Parser.java:4770)
      at org.h2.command.Parser.readTableFilter(Parser.java:1084)
      at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1690)
      at org.h2.command.Parser.parseSelectSimple(Parser.java:1797)
      at org.h2.command.Parser.parseSelectSub(Parser.java:1684)
      at org.h2.command.Parser.parseSelectUnion(Parser.java:1527)
      at org.h2.command.Parser.readTableFilter(Parser.java:1026)
      at org.h2.command.Parser.readJoin(Parser.java:1354)
      at org.h2.command.Parser.parseJoinTableFilter(Parser.java:1696)
      at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1691)
      at org.h2.command.Parser.parseSelectSimple(Parser.java:1797)
      at org.h2.command.Parser.parseSelectSub(Parser.java:1684)
      at org.h2.command.Parser.parseSelectUnion(Parser.java:1527)
      at org.h2.command.Parser.parseSelect(Parser.java:1515)
      at org.h2.command.Parser.parsePrepared(Parser.java:405)
      at org.h2.command.Parser.parse(Parser.java:279)
      at org.h2.command.Parser.parse(Parser.java:251)
      at org.h2.command.Parser.prepareCommand(Parser.java:217)
      at org.h2.engine.Session.prepareLocal(Session.java:415)
      at org.h2.engine.Session.prepareCommand(Session.java:364)
      at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
      at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
      at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:626)
      at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:677)
      at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:663)
      at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:404)
      at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:72)
      at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:82)
      at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:54)
      at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:70)
      at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
      at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
      at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
      at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
      at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
      at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
      ... 53 more

        This is the controller panel for Smart Panels app

              smirnov Roman Smirnov
              danielk Daniel Klotz
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: