-
Bug
-
Resolution: Done
-
Critical
-
None
-
None
-
None
-
False
-
None
-
False
-
Migration
-
NEW
-
NEW
-
-
---
-
---
-
-
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
- clones
-
RHPAM-4578 ERROR "Table 'rhpam.taskEvent' doesn't exist" happens after upgrading to 7.12.0 or later
- Closed