topic Re: Process Instance Query returning completed or cancelled workflows (MS SQL) in Alfresco Archive

Process Instance Query returning completed or cancelled workflows (MS SQL)

cchen — Mon, 16 May 2016 18:29:36 GMT

I am trying to use a ProcessInstanceQuery to return all active workflows initiated by bpm_initiator. However, a number of inactive workflows are getting returned. When these inactive workflows are returned, exceptions are thrown, since bpm_package has been deleted. When querying ACT_RU_VARIABLE for

Re: Process Instance Query returning completed or cancelled workflows (MS SQL)

jbarrez — Wed, 18 May 2016 16:41:48 GMT

what does 'inactive' mean for you? It's not a concept from Activiti. Do you mean suspended?

> getRuntimeService().createProcessInstanceQuery().variableValueEquals("bpm_initiator", userLoginName)

This returns all instances wth that variable, irregardless of the state, you'd need to add more constraints to the query to filter more narrowly.

Re: Process Instance Query returning completed or cancelled workflows (MS SQL)

cchen — Wed, 18 May 2016 18:12:33 GMT

Yes, I do mean suspended.

To counter your point about all instances with that variable getting returned… We are not seeing all instances getting returned. As in, not all suspended (completed or cancelled) workflows are returned but just a few of them are getting returned along with the active workflows. Is this possibly an issue with MS SQL?

Additionally, to constrain my query, is adding <java>.active()</java> appropriate?

Re: Process Instance Query returning completed or cancelled workflows (MS SQL)

jbarrez — Thu, 26 May 2016 13:15:37 GMT

Yes, as the javadocs says:

<code>

/**
   * Only select process instances which are active, which means that
   * neither the process instance nor the corresponding process definition
   * are suspended.
   */
ProcessInstanceQuery active();
</code>

About your other problem: how many are returned. There is a limit on the total amount returned, i believe. But it should be a large value.