topic About SQLServer Engine, can't get the Task category value in Alfresco Archive

About SQLServer Engine, can't get the Task category value

fuhang — Wed, 16 Mar 2016 02:44:07 GMT

I countered a problem. My Activiti use SQLServer2012 verson, When I get a Task, can't get the category property of that task, but When I use oracle, it's ok.code : TaskQuery taskQuery = taskService.createTaskQuery().taskAssignee( assignee );….task.getCategory() is nullthe database ACT_RU_TASK table'

Re: About SQLServer Engine, can't get the Task category value

jbarrez — Fri, 18 Mar 2016 13:35:01 GMT

That sounds very odd indeed.
Can you wrap your code in a unit test that fails on your installation so we can try it out?
Should be easy doable by creating a standalone task and giving it a category.

Re: About SQLServer Engine, can't get the Task category value

fuhang — Sat, 19 Mar 2016 05:01:21 GMT

I am sure task category value exists. I found the problem occurrence place. But I can't solve this. This is sample code:
*********************code*********************
              List<Task> result = null;
if( StringUtils.isNotBlank( userId ) ) {
   String assignee = userId;
   TaskService taskService = getTaskService();
   TaskQuery taskQuery = taskService.createTaskQuery().taskAssignee( assignee );
   taskQuery = appendQueryCondition( taskQuery, condition );

                        // ! This is problem here, includeProcessVariables
   taskQuery = taskQuery.includeProcessVariables();

   result = taskQuery.listPage( page.getStart(), page.getLimit() );
   System.out.println( "===>" + result.get( 0 ).getCategory() );
                        // The print is ===>null
}
return result;
************************************************

When I commented out this "taskQuery = taskQuery.includeProcessVariables();" line, the running is nomal, geting the category value.
This is my process variables:
*******************database ACT_RU_VARIABLE*********************
ID_ REV_ TYPE_ NAME_ EXECUTION_ID_ PROC_INST_ID_ TASK_ID_ BYTEARRAY_ID_ DOUBLE_ LONG_ TEXT_ TEXT2_
30003 1 serializable contractNameList 30001 30001 NULL 30002 NULL NULL NULL NULL
30011 1 string unitId 30001 30001 NULL NULL NULL NULL ff808081511e3d1501511e40cac70001 NULL
30013 1 serializable applyDate 30001 30001 NULL 30012 NULL NULL NULL NULL

********************************************************************

Sorry for not pasting all of junit test codes.

Re: About SQLServer Engine, can't get the Task category value

jbarrez — Fri, 25 Mar 2016 12:27:22 GMT

I looked into the code, but when doing a .includeVariables, the task category is included.
Did a quick test, but for me the category is included:

<code>
@Deployment(resources={"org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml"})
public void testStartProcessInstanceWithVariables() {
    Map<String, Object> vars = new HashMap<String, Object>();
    vars.put("basicType", new DummySerializable());
    runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
    Task task = taskService.createTaskQuery().includeProcessVariables().singleResult();
    assertNotNull(task.getProcessVariables());
    assertNotNull(task.getCategory());
}
</code>