topic Re: ACT_HI_VARINST table - TASK_ID_ in Alfresco Archive

ACT_HI_VARINST table - TASK_ID_

lixkid — Mon, 13 May 2013 09:59:28 GMT

Hi,My goal is to get all HistoricVariableInstances with specific taskId from ACT_HI_VARINST table, but every row in that table (which represents HistoricVariableInstance) is set to NULL.Is there a way to associate process variable with a task which might result in TASK_ID_ (in table ACT_HI_VARINST)

Re: ACT_HI_VARINST table - TASK_ID_

jbarrez — Tue, 14 May 2013 08:03:27 GMT

What is your history level? For variable history, you need to set it higher than default.

Re: ACT_HI_VARINST table - TASK_ID_

lixkid — Tue, 14 May 2013 10:37:12 GMT

What is your history level? For variable history, you need to set it higher than default.

Even after I changed property "history" (in the definition of processEngineConfiguration bean in activiti.cfg.xml) by setting it to "full" with the following code:
<code>
<bean id="processEngineConfiguration" class="org.activiti.cdi.CdiJtaProcessEngineConfiguration">
   …
   <property name="history" value="full" />
   …
</bean>
</code>

values in column TASK_ID_ (table ACT_HI_VARINST) are set to NULL.

Do you please have any other suggestions?

Re: ACT_HI_VARINST table - TASK_ID_

lixkid — Wed, 15 May 2013 07:00:34 GMT

I have found a solution to my problem in this post .

In order for task id to be saved in TASK_ID_ column (table ACT_HI_VARINST), it needs to be associated with process variables by using the following code:
<code>
taskService.setVariablesLocal(task.getId(), vars);
</code>

Re: ACT_HI_VARINST table - TASK_ID_

frederikherema1 — Tue, 21 May 2013 18:42:46 GMT

Thanks for sharing the solution!