Timeout while kie-server is starting up

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content