<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic selectTaskByQueryCriteria returns null in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179922#M133052</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;activiti-engine version - 5.17.0&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;With the following call to taskService,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-java line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;org.activiti.engine.task.Task task = taskService.createTaskQuery()&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; .taskTenantId("tenantId")&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; .taskId("1630666")&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; .singleResult();&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;the resultant task is being returned as null.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;org.apache.ibatis.transaction.managed.ManagedTransaction&amp;nbsp; - Opening JDBC Connection&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria&amp;nbsp; - ooo Using Connection [Transaction-aware proxy for target Connection&amp;nbsp; from DataSource [org.apache.commons.dbcp.BasicDataSource@4cede921]]&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria&amp;nbsp; - ==&amp;gt;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="color:RED;"&gt;Preparing: select distinct RES.* from ACT_RU_TASK RES WHERE RES.ID_ = ? and RES.TENANT_ID_ = ? order by RES.ID_ asc LIMIT ? OFFSET ? &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria&amp;nbsp; - ==&amp;gt; Parameters: 1630666(String), tenantId(String), 2147483647(Integer), 0(Integer)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria&amp;nbsp; - &amp;lt;==&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Total: 0&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.activiti.engine.impl.db.DbSqlSession&amp;nbsp; - flush summary: 0 insert, 0 update, 0 delete.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.activiti.engine.impl.db.DbSqlSession&amp;nbsp; - now executing flush…&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.apache.ibatis.transaction.managed.ManagedTransaction&amp;nbsp; - Closing JDBC Connection [Transaction-aware proxy for target Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@67b2ccc4]]&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.activiti.engine.impl.interceptor.LogInterceptor&amp;nbsp; - — TaskQueryImpl finished ——&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;If I run the same query directly on mysql db, I get the expected row in the resultset. I know this might not be enough information, but just wished to know if anyone else has seen this problem before. Is it related to some cache not being refreshed and trying to read stale data or something?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 24 Sep 2015 19:48:48 GMT</pubDate>
    <dc:creator>aseem</dc:creator>
    <dc:date>2015-09-24T19:48:48Z</dc:date>
    <item>
      <title>selectTaskByQueryCriteria returns null</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179922#M133052</link>
      <description>activiti-engine version - 5.17.0Hi,With the following call to taskService,org.activiti.engine.task.Task task = taskService.createTaskQuery()&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; .taskTenantId("tenantId")&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; .taskId("1630666")&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; .singleResult();‍‍‍‍‍‍the resultant task is being returned as null.or</description>
      <pubDate>Thu, 24 Sep 2015 19:48:48 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179922#M133052</guid>
      <dc:creator>aseem</dc:creator>
      <dc:date>2015-09-24T19:48:48Z</dc:date>
    </item>
    <item>
      <title>Re: selectTaskByQueryCriteria returns null</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179923#M133053</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;When are you executing the TaskService call? Inside the process instance execution?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Best regards,&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 25 Sep 2015 14:49:57 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179923#M133053</guid>
      <dc:creator>trademak</dc:creator>
      <dc:date>2015-09-25T14:49:57Z</dc:date>
    </item>
    <item>
      <title>Re: selectTaskByQueryCriteria returns null</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179924#M133054</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Yes. I can see an entry in ACT_RU_EXECUTION for the corresponding PROC_INST_ID_ which I assume means that I'm making that call inside the process instance execution. Does that make sense?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 25 Sep 2015 15:07:46 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179924#M133054</guid>
      <dc:creator>aseem</dc:creator>
      <dc:date>2015-09-25T15:07:46Z</dc:date>
    </item>
    <item>
      <title>Re: selectTaskByQueryCriteria returns null</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179925#M133055</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Guess I found out the problem. I was deleting workflow instance which might be invalidating the cache, but since the transaction wasn't committed yet, it explains why I could see that taskId in the ACT_RU_TASK table but not in localCache.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;So this was a non issue, but a problem in the client code.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 30 Sep 2015 21:02:03 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/selecttaskbyquerycriteria-returns-null/m-p/179925#M133055</guid>
      <dc:creator>aseem</dc:creator>
      <dc:date>2015-09-30T21:02:03Z</dc:date>
    </item>
  </channel>
</rss>

