RHPAM is throwing table doesn't exist using MariaDB
Issue
The following issue is happening after installing RHPAM 7.12 on Openshift and using a MariaDB 10.3 database, the kieserver is throwing the following error:
[0m•[31m22:43:12,671 ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (ServerService Thread Pool -- 87) SELECT * FROM (select t.activationTime, t.actualOwner, t.createdBy, t.createdOn, t.deploymentId, t.description, t.dueDate, t.name, t.parentId, t.priority, t.processId, t.processInstanceId, t.processSessionId, t.status, t.taskId, t.workItemId, t.lastModificationDate, pil.correlationKey, pil.processInstanceDescription ,oe.id, nil.sla_due_date, nil.slaCompliance,(select COUNT(errInfo.id) from ExecutionErrorInfo errInfo where errInfo.ACTIVITY_ID = t.taskId and errInfo.PROCESS_INST_ID = pil.processInstanceId and errInfo.ERROR_ACK = 0 and errInfo.ERROR_TYPE = 'Task') as errorCount, i18n.text as subject, i18n.language as language, task.formname as formname, (SELECT 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 pil.processInstanceId = t.processInstanceId left join PeopleAssignments_BAs ba on...
•[0m•[0m22:43:12,693 INFO [org.jbpm.kie.services.impl.query.persistence.PersistDataSetListener] (ServerService Thread Pool -- 87) Data set jbpmHumanTasksWithAdminExtended removed from db storage
•[0m•[0m22:43:12,693 INFO [org.jbpm.kie.services.impl.query.QueryServiceImpl] (ServerService Thread Pool -- 87) Unregistered jbpmHumanTasksWithAdminExtended query successfully
•[0m•[31m22:43:12,767 ERROR [org.kie.server.services.jbpm.JbpmKieServerExtension] (ServerService Thread Pool -- 87) Error when loading default query definitions from default-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:843)
at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4390)
at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.loadAndRegisterQueryDefinitions(JbpmKieServerExtension.java:841)
at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.registerDefaultQueryDefinitions(JbpmKieServerExtension.java:859)
at deployment.ROOT.war//org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:216)
at deployment.ROOT.war//org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:182)
at deployment.ROOT.war//org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:140)
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.9.SP1-redhat-00001//io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)
at io.undertow.servlet@2.2.9.SP1-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:219)
at io.undertow.servlet@2.2.9.SP1-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:187)
at io.undertow.servlet@2.2.9.SP1-redhat-00001//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42)
at io.undertow.servlet@2.2.9.SP1-redhat-00001//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at org.wildfly.extension.undertow@7.4.1.GA-redhat-00003//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at org.wildfly.extension.undertow@7.4.1.GA-redhat-00003//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at org.wildfly.extension.undertow@7.4.1.GA-redhat-00003//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at org.wildfly.extension.undertow@7.4.1.GA-redhat-00003//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
at io.undertow.servlet@2.2.9.SP1-redhat-00001//io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:255)
at org.wildfly.extension.undertow@7.4.1.GA-redhat-00003//org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:96)
at org.wildfly.extension.undertow@7.4.1.GA-redhat-00003//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=602) Table 'pam_dev.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=602) Table 'pam_dev.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.4.35.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 'pam_dev.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.processId, t.processInstanceId, t.processSessionId, t.status, t.taskId, t.workItemId, t.lastModificationDate, pil.correlationKey, pil.processInstanceDescription ,oe.id, nil.sla_due_date, nil.slaCompliance,(select COUNT(errInfo.id) from ExecutionErrorInfo errInfo where errInfo.ACTIVITY_ID = t.taskId and errInfo.PROCESS_INST_ID = pil.processInstanceId and errInfo.ERROR_ACK = 0 and errInfo.ERROR_TYPE = 'Task') as errorCount, i18n.text as subject, i18n.language as language, task.formname as formname, (SELECT 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 pil.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 NodeIn...
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
Environment
- Red Hat Process Automation Manager (RHPAM)
- 7.12.1
- Red Hat OpenShift Container Platform (RHOCP)
- 4.9.9
- MariaDB
- 10.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.