Unable to start RHPAM due to jbpmHumanTasksWithVariables query timeout
Issue
After working with RHPAM 7.0 for some time, we have around 20.000 tasks created. During the server startup, the query service to fetch task variables is throwing the below error:
ERROR [org.dashbuilder.exception.ExceptionManager] (default task-15) Can't lookup on specified data set: jbpmHumanTasksWithVariables: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: jbpmHumanTasksWithVariables
Caused by: org.kie.server.common.rest.NoEndpointFoundException: No available endpoints found
It seems this query is trying to fetch all data from the database, and due to the high record count, it is not responding within SLA and request times out.
Environment
- Red Hat Process Automation Manager
- 7.0.0
- 7.0.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
