Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-10134

ERROR "Table 'rhpam.taskEvent' doesn't exist" happens after upgrading to 7.12.0 or later

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • None
    • None
    • None

      When using MySQL DB or Maria DB, after upgrading to 7.12.0 or later the following ERROR happens in kie-server log:

      04:48:20,036 ERROR [org.kie.server.services.jbpm.JbpmKieServerExtension] (ServerService Thread Pool -- 84) Error when loading default query definitions from defau
      lt-query-definitions.json: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmHumanTasksWithAdminExtended
      at deployment.ROOT.war//org.dashbuilder.dataset.DataSetManagerImpl.getDataSetMetadata(DataSetManagerImpl.java:189)
      at deployment.ROOT.war//org.jbpm.kie.services.impl.query.QueryServiceImpl.replaceQuery(QueryServiceImpl.java:205)
      at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.lambda$loadAndRegisterQueryDefinitions$4(JbpmKieServerExtension.java:842)
      at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4390)
      at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.loadAndRegisterQueryDefinitions(JbpmKieServerExtension.java:840)
      at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.registerDefaultQueryDefinitions(JbpmKieServerExtension.java:858)
      at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:214)
      at deployment.ROOT.war//org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:184)
      at deployment.ROOT.war//org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:142)
      at deployment.ROOT.war//org.kie.server.services.impl.KieServerLocator$KieServerLocatorHelper.<clinit>(KieServerLocator.java:25)
      at deployment.ROOT.war//org.kie.server.services.impl.KieServerLocator.getInstance(KieServerLocator.java:32)
      at deployment.ROOT.war//org.kie.server.remote.rest.common.Bootstrap.contextInitialized(Bootstrap.java:51)
      at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)
      at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:219)
      at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:187)
      at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.j
      ava:42)
      at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
      at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda
      $create$0(UndertowDeploymentInfoService.java:1551)
      at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda
      $create$0(UndertowDeploymentInfoService.java:1551)
      at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda
      $create$0(UndertowDeploymentInfoService.java:1551)
      at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda
      $create$0(UndertowDeploymentInfoService.java:1551)
      at io.undertow.servlet@2.2.16.Final-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:255)
      at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentServi
      ce.java:96)
      at org.wildfly.extension.undertow@7.4.4.GA-redhat-00011//org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java
      :78)
      at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
      at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
      at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
      at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
      at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
      at java.base/java.lang.Thread.run(Thread.java:829)
      at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.JBossThread.run(JBossThread.java:513)
      Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: (conn=1234293) Table 'rhpam.taskEvent' doesn't exist
      at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.model.Select.fetch(Select.java:197)
      at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.SQLDataSetProvider._getColumns(SQLDataSetProvider.java:415)
      at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.SQLDataSetProvider._getDataSetMetadata(SQLDataSetProvider.java:327)
      at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.SQLDataSetProvider.getDataSetMetadata(SQLDataSetProvider.java:260)
      at deployment.ROOT.war//org.dashbuilder.dataset.DataSetManagerImpl.getDataSetMetadata(DataSetManagerImpl.java:187)
      ... 31 more
      Caused by: java.sql.SQLSyntaxErrorException: (conn=1234293) Table 'rhpam.taskEvent' doesn't exist
      at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:177)
      at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
      at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228)
      at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:334)
      at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:505)
      at org.jboss.ironjacamar.jdbcadapters@1.5.3.Final-redhat-00001//org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:397)
      at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.JDBCUtils.executeQuery(JDBCUtils.java:123)
      at deployment.ROOT.war//org.dashbuilder.dataprovider.sql.model.Select.fetch(Select.java:190)
      ... 35 more
      Caused by: java.sql.SQLException: Table 'rhpam.taskEvent' doesn't exist
      Query is: SELECT * FROM (select t.activationTime, t.actualOwner, t.createdBy, t.createdOn, t.deploymentId, t.description, t.dueDate, t.name, t.parentId, t.priority, t.pr
      ocessId, t.processInstanceId, t.processSessionId, t.status, t.taskId, t.workItemId, t.lastModificationDate, pil.correlationKey, pil.processInstanceDescription ,oe.id, ni
      l.sla_due_date, nil.slaCompliance,(select COUNT(errInfo.id) from ExecutionErrorInfo errInfo where errInfo.ACTIVITY_ID = t.taskId and errInfo.PROCESS_INST_ID = pil.proces
      sInstanceId and errInfo.ERROR_ACK = 0 and errInfo.ERROR_TYPE = 'Task') as errorCount, i18n.text  as subject, i18n.language as language, task.formname as formname, (SELEC
      T te1.userId FROM taskEvent te1 LEFT JOIN taskEvent te2 ON te1.id < te2.id WHERE te2.id IS NULL) as lastUser from AuditTaskImpl t  left join ProcessInstanceLog pil on pi
      l.processInstanceId = t.processInstanceId left join PeopleAssignments_BAs ba on t.taskId = ba.task_id left join OrganizationalEntity oe on ba.entity_id = oe.id left join
       NodeInstanceLog ...
      at org.mariadb//org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:119)
      at org.mariadb//org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:200)
      at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:328)
      ... 39 more
      

              rhn-support-egonzale Enrique Gonzalez Martinez (Inactive)
              rhn-support-hmiura Hiroko Miura
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: