Timeout while kie-server is starting up
Issue
- Some times the system can experiencing a time out when the server starts up.
- The time out occurs while the Kie server is registering queries.
-
Somes queries take a long time to respond - for instance:
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, EO.ENTITY_ID, NIL.SLA_DUE_DATE, NIL.SLACOMPLIANCE FROM AUDITTASKIMPL T LEFT JOIN PEOPLEASSIGNMENTS_POTOWNERS PO ON T.TASKID=PO.TASK_ID LEFT JOIN ORGANIZATIONALENTITY OE ON PO.ENTITY_ID=OE.ID LEFT JOIN PROCESSINSTANCELOG PIL ON PIL.PROCESSINSTANCEID=T.PROCESSINSTANCEID LEFT JOIN PEOPLEASSIGNMENTS_EXCLOWNERS EO ON T.TASKID=EO.TASK_ID LEFT JOIN NODEINSTANCELOG NIL ON NIL.WORKITEMID=T.WORKITEMID) "dbSQL" FETCH FIRST 0 ROWS ONLY
Environment
- Red Hat Process Automation Manager (RHPAM)
- 7.10.0,
- 7.10.1,
- 7.11.0,
- 7.11.1
- Oracle 19c
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.