[CAM-3135] Webapp uses reserved word "ROOT" as table alias name - camunda JIRA

XML

Word

Printable

Details

Type: Bug Report
Status: Closed
Priority: L3 - Default
Resolution: Fixed
Affects Version/s: 7.2.0-alpha6
Fix Version/s: 7.3.0, 7.3.0-alpha2
Component/s: None
Labels:
None

Description

ROOT is a reserved word for IBM Informix database.
Please choose a different name.

24.11. 23:25:33,624 FINE cockpit.base.selectIncidentWithCauseAndRootCauseIncidentsCount#debug ==> Preparing: select count(distinct RES.ID_) from ( select RES.*, CAUSE.PROC_INST_ID_ CAUSE_PROC_INST_ID_, CAUSE.PROC_DEF_ID_ CAUSE_PROC_DEF_ID_, CAUSE.ACTIVITY_ID_ CAUSE_ACTIVITY_ID_, ROOT.PROC_INST_ID_ ROOT_PROC_INST_ID_, ROOT.PROC_DEF_ID_ ROOT_PROC_DEF_ID_, ROOT.ACTIVITY_ID_ ROOT_ACTIVITY_ID_, ROOT.INCIDENT_MSG_ ROOT_INC_MSG_, ROOT.CONFIGURATION_ ROOT_INC_CONF_ from ACT_RU_INCIDENT RES left join ACT_RU_INCIDENT CAUSE on RES.CAUSE_INCIDENT_ID_ = CAUSE.ID_ left join ACT_RU_INCIDENT ROOT on RES.ROOT_CAUSE_INCIDENT_ID_ = ROOT.ID_ WHERE ( RES.PROC_INST_ID_ = ? ) ) RES
24.11. 23:25:33,671 FINE cockpit.base.selectIncidentWithCauseAndRootCauseIncidents#debug ==> Preparing: SELECT SKIP ? FIRST ? * FROM ( select RES.* from ( select RES.*, CAUSE.PROC_INST_ID_ CAUSE_PROC_INST_ID_, CAUSE.PROC_DEF_ID_ CAUSE_PROC_DEF_ID_, CAUSE.ACTIVITY_ID_ CAUSE_ACTIVITY_ID_, ROOT.PROC_INST_ID_ ROOT_PROC_INST_ID_, ROOT.PROC_DEF_ID_ ROOT_PROC_DEF_ID_, ROOT.ACTIVITY_ID_ ROOT_ACTIVITY_ID_, ROOT.INCIDENT_MSG_ ROOT_INC_MSG_, ROOT.CONFIGURATION_ ROOT_INC_CONF_ from ACT_RU_INCIDENT RES left join ACT_RU_INCIDENT CAUSE on RES.CAUSE_INCIDENT_ID_ = CAUSE.ID_ left join ACT_RU_INCIDENT ROOT on RES.ROOT_CAUSE_INCIDENT_ID_ = ROOT.ID_ WHERE ( RES.PROC_INST_ID_ = ? ) ) RES order by RES.ID_ asc )
24.11. 23:25:33,668 SEVERE org.camunda.bpm.engine.impl.interceptor.CommandContext#close Error while closing command context: org.apache.ibatis.exceptions.PersistenceException:

1. 1. Error querying database. Cause: java.sql.SQLException: A syntax error has occurred.
  2. The error may exist in org/camunda/bpm/cockpit/plugin/base/queries/incident.xml
  3. The error may involve cockpit.base.selectIncidentWithCauseAndRootCauseIncidentsCount
  4. The error occurred while executing a query
  5. SQL: select count(distinct RES.ID_) from ( select RES.*, CAUSE.PROC_INST_ID_ CAUSE_PROC_INST_ID_, CAUSE.PROC_DEF_ID_ CAUSE_PROC_DEF_ID_, CAUSE.ACTIVITY_ID_ CAUSE_ACTIVITY_ID_, ROOT.PROC_INST_ID_ ROOT_PROC_INST_ID_, ROOT.PROC_DEF_ID_ ROOT_PROC_DEF_ID_, ROOT.ACTIVITY_ID_ ROOT_ACTIVITY_ID_, ROOT.INCIDENT_MSG_ ROOT_INC_MSG_, ROOT.CONFIGURATION_ ROOT_INC_CONF_ from ACT_RU_INCIDENT RES left join ACT_RU_INCIDENT CAUSE on RES.CAUSE_INCIDENT_ID_ = CAUSE.ID_ left join ACT_RU_INCIDENT ROOT on RES.ROOT_CAUSE_INCIDENT_ID_ = ROOT.ID_ WHERE ( RES.PROC_INST_ID_ = ? ) ) RES
  6. Cause: java.sql.SQLException: A syntax error has occurred.
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66)
    at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectOne(DbSqlSession.java:99)
    at org.camunda.bpm.cockpit.impl.db.QueryServiceImpl$3.execute(QueryServiceImpl.java:60)
    at org.camunda.bpm.cockpit.impl.db.QueryServiceImpl$3.execute(QueryServiceImpl.java:57)
    at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
    at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:97)
    at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)
    at org.camunda.bpm.cockpit.impl.db.CommandExecutorImpl.executeCommand(CommandExecutorImpl.java:39)
    at org.camunda.bpm.cockpit.impl.db.QueryServiceImpl.executeQueryRowCount(QueryServiceImpl.java:57)
    at org.camunda.bpm.cockpit.impl.plugin.base.resources.IncidentRestService.queryIncidentsCount(IncidentRestService.java:90)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
    at org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:140)
    at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:103)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:86)
    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
    at org.camunda.bpm.engine.rest.filter.CacheControlFilter.doFilter(CacheControlFilter.java:47)
    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
    at org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilterSecure(SecurityFilter.java:67)
    at org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilter(SecurityFilter.java:51)
    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
    at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:59)
    at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:56)
    at org.camunda.bpm.webapp.impl.security.SecurityActions.runWithAuthentications(SecurityActions.java:38)
    at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:56)
    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
    at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
    at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
    at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
    at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
    at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
    at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
    at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
    at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
    at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
    at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    at io.undertow.server.handlers.MetricsHandler.handleRequest(MetricsHandler.java:62)
    at io.undertow.servlet.core.MetricsChainHandler.handleRequest(MetricsChainHandler.java:59)
    at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)
    at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247)
    at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76)
    at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166)
    at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)
    at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:767)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: java.sql.SQLException: A syntax error has occurred.
    at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
    at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3132)
    at com.informix.jdbc.IfxSqli.D(IfxSqli.java:3412)
    at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2325)
    at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2250)
    at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1225)
    at com.informix.jdbc.IfxPreparedStatement.f(IfxPreparedStatement.java:307)
    at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:288)
    at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:181)
    at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:6053)
    at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:2481)
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:800)
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:775)
    at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:434)
    at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:54)
    at com.sun.proxy.$Proxy211.prepareStatement(Unknown Source)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:75)
    at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:85)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:57)
    at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:73)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:59)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)
    ... 70 more
    Caused by: java.sql.SQLException
    at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
    at com.informix.jdbc.IfxSqli.D(IfxSqli.java:3417)
    ... 96 more

mgm-controller-panel

This is the controller panel for Smart Panels app

Attachments

Activity

People

Assignee:: Roman Smirnov

Reporter:: Frank Langelage

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 24/Nov/14 11:42 PM

Updated:: 05/Mar/15 1:33 PM

Resolved:: 30/Jan/15 9:29 AM