-
Bug Report
-
Resolution: Fixed
-
L3 - Default
-
None
-
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
- is related to
-
CAM-1249 Add CI job for running webapp unit testsuite with DB table prefix
- Closed