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

Webapp uses reserved word "ROOT" as table alias name

    XMLWordPrintable

Details

    • Bug Report
    • Resolution: Fixed
    • L3 - Default
    • 7.3.0, 7.3.0-alpha2
    • 7.2.0-alpha6
    • None
    • 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. 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

              smirnov Roman Smirnov
              langfr Frank Langelage
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce