nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Process instance query problem

michael_nepyjwo

Hello,

I think I'm having an issue with the runtime service and a process instance query:
the query code is :
…
return runtimeService.createProcessInstanceQuery().processDefinitionId(processDefinition.getId())
.orderByProcessInstanceId().asc().list();
}
…

-processDefinition.getId() is defined and exists in the database.
-a matching process instance exists in the database and the runtime service should return a list with this process instance but it returns an empty list…

Thanks for your answer.

Best regards,

Michaël Nepyjwoda

PS: I can provide screenshots of the code and the database if it helps you but you will have to tell me how to post them.

Find more posts tagged with

Comments

martin_grofcik

Hi Michaël,

Try to debug your code and
on the line

<br>return runtimeService.createProcessInstanceQuery().processDefinitionId(processDefinition.getId())<br>.orderByProcessInstanceId().asc().list();<br>

try to execute runtimeService.createProcessInstanceQuery().list() - you will see all process instances in the engine.
Check whether key is not misused as Id.

Regards
Martin

michael_nepyjwo

Hello Martin,

I've just tried what you suggested but the runtime service returns an empty list while some process instances are defined in the ACT_HI_PROCINST table…

Some other idea ?

jbarrez

- The runtime service will NOT return process instances from ACT_HI_PROCINST, but from ACT_RU_EXECUTION.

- Does runtimeService.createProcessInstanceQuery().list() give you anything?

michael_nepyjwo

Hi Joram,

runtimeService.createProcessInstanceQuery().list() returns an empty list and ACT_RU_EXECUTION is empty.

michael_nepyjwo

Joram,

I found what was wrong: the runtime service only returns active process instances and mine were finished.
So there is no more problem.

Have I something to do to close this post ?

Thanks.

jbarrez

Ok, good to hear. No need to close post, replying it's working is enough 🙂