AnsweredAssumed Answered

TaskQuery stucks when quering for Task

Question asked by swamy2156 on Jul 8, 2013
Latest reply on Jul 10, 2013 by frederikheremans1
Hi.,

I am using activiti 5.12.1v and using Oracle database. In DB, ACT_RU_TASK table contains around 27,000 rows. While querying for task based on process instance id, While debugging came to know that its hangs at taskQuery.singleResult(). code is as follows.

      TaskQuery taskQuery =
          taskService.createTaskQuery().processInstanceId(businessProcessId);
      task = taskQuery.singleResult();

and my processEngineConfiguration bean definition as follows.

  <bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
    <property name="dataSource" ref="dataSource" />
    <property name="transactionManager" ref="transactionManager" />
    <property name="databaseSchemaUpdate" value="false" />
    <property name="jobExecutorActivate" value="true" />
  </bean>


This code worked fine for couple of days earlier when there are few entries in task table but not working now. Is there any additional configuration to get rid of this? Am I only one getting this problem in activiti world?

Can someone look into this.

Thanks,
Swamy.

Outcomes