How to increase limit from 20000 variables in REST API in activiti?

Flowable Engine
#1

When making a REST API call to query historic tasks using the parameter “includeProcessVariables”: “true” , a maximum of 20,000 variables are returned. The results of the REST API when using “includeProcessVariables”: “true” are cut off as soon as the 20,000th variable is in the REST API response.

A customer have around 500 process variable in on process and for that he is only able to get the first 40 process Data with includeProcessVariables=true.

In docs , it is mentioned that the limit of 20000 is for performance reason. Can this limit be changed. I am thinking to increase the limit to 100000 or more.

Same issue here https://github.com/flowable/flowable-engine/issues/1348 , https://issues.alfresco.com/jira/browse/ACTIVITI-1065

#2

I haven’t dug too deeply into this code, but my guess is that something like this would work:

    @Bean
    EngineConfigurationConfigurer<SpringProcessEngineConfiguration> processEngineConfigurationEngineConfigurationConfigurer(){
        return engineConfiguration -> {
            System.out.println("configuring Process Engine");
            engineConfiguration.setHistoricTaskQueryLimit(100000);
            engineConfiguration.setHistoricProcessInstancesQueryLimit(100000);
        };
    }

Edit, I just realized the subject says “in Activiti”, are you using Flowable or Activiti?

#3

My bad, I am using flowable.

#4

@wwitt is there a way I can filter only a few process variables while making this call? I am always interested in a few variables not all.

Regards

#5

You’d need to craft some custom queries using the Java APIs, here are some examples from the documentation:


#6

Hi! Is it possible to set those limits with spring properties (in application.properties or with environment variables)?

#7

No, this property isn’t exposed. You’d need a simple EngineConfigurer bean to set it.