<?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 The value of ACT_INST_ID_ is null in table ACT_HI_DETAIL from sub process in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/the-value-of-act-inst-id-is-null-in-table-act-hi-detail-from-sub/m-p/244924#M198054</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Dear all:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Sorry about my poor English and I will try my best to describe the problem I encountered.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Now I am using the following code (with SQL )to query the historical variables values in my flow listeners:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;1. HistoricActivityInstance previousAct = historyService.createNativeHistoricActivityInstanceQuery().sql("select * from ACT_HI_ACTINST where TASK_ID_ = #{taskId}").parameter("taskId", previousTaskId).singleResult();&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;*By this code I can get the previous Act Instance&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;2. HistoricVariableUpdate previousTaskIdVar = (HistoricVariableUpdate) historyService.createNativeHistoricDetailQuery().sql("select * from ACT_HI_DETAIL where ACT_INST_ID_ = #{actInstId} and NAME_ = #{name}").parameter("actInstId", previousAct.getId()).parameter("name", "previousTaskId").singleResult();&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;*Since the process variable "previousTaskId" will keep being updated during the process move forward, sometimes I need to update the variable's value back to a certain state. By this code, I can update the value of "previousTaskId" to the corresponding value I need with the history record stored in ACT_HI_DETAIL. And what I need here for the query condition is "ACT_INST_ID_ ".&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The mechanics was perfect until I added a embedded subprocess in my bpmn.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I realized that the ACT_HI_DETAIL&amp;nbsp; table won't store the proper ACT_INST_ID_ value if a variable update event was happened in my&amp;nbsp; embedded subprocess. The ACT_INST_ID_ will be set as NULL in the table column. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Could anyone share some advice? I really need a way to store proper ACT_INST_ID_&amp;nbsp; value to the ACT_HI_DETAIL table when running my subprocess!&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I will be so much appreciated if anyone can help!&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thank you!&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 14 Nov 2016 12:01:16 GMT</pubDate>
    <dc:creator>scryed0204</dc:creator>
    <dc:date>2016-11-14T12:01:16Z</dc:date>
    <item>
      <title>The value of ACT_INST_ID_ is null in table ACT_HI_DETAIL from sub process</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/the-value-of-act-inst-id-is-null-in-table-act-hi-detail-from-sub/m-p/244924#M198054</link>
      <description>Dear all&lt;IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" /&gt;orry about my poor English and I will try my best to describe the problem I encountered.Now I am using the following code (with SQL )to query the historical variables values in my flow listeners:1. HistoricActivityInstance previousAct = historyService.createNativeHistoricActivityInstanceQu</description>
      <pubDate>Mon, 14 Nov 2016 12:01:16 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/the-value-of-act-inst-id-is-null-in-table-act-hi-detail-from-sub/m-p/244924#M198054</guid>
      <dc:creator>scryed0204</dc:creator>
      <dc:date>2016-11-14T12:01:16Z</dc:date>
    </item>
    <item>
      <title>Re: The value of ACT_INST_ID_ is null in table ACT_HI_DETAIL from sub process</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/the-value-of-act-inst-id-is-null-in-table-act-hi-detail-from-sub/m-p/244925#M198055</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Your problem seems to be the same as this one:&amp;nbsp; &lt;/SPAN&gt;&lt;A href="https://activiti.atlassian.net/browse/ACT-4144" rel="nofollow noopener noreferrer"&gt;https://activiti.atlassian.net/browse/ACT-4144&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; You must have/create an user to see the details, but in short:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;code&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;If I store variables with:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; processEngine.getTaskService().setVariable(taskId, "var_1", "this is a save var");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;With activiti 5.19.0.2. In the database. ACT_HI_DETAIL table: the "ACT_INST_ID_" field is null.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;With activiti 5.16.4 the field has the correct value (the ID of the activity).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/code&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; The bug is fixed in this pull request: &lt;/SPAN&gt;&lt;A href="https://github.com/Activiti/Activiti/pull/1068" rel="nofollow noopener noreferrer"&gt;https://github.com/Activiti/Activiti/pull/1068&lt;/A&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; But not yet merged into master.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Vlad,&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 16 Nov 2016 13:03:25 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/the-value-of-act-inst-id-is-null-in-table-act-hi-detail-from-sub/m-p/244925#M198055</guid>
      <dc:creator>motorina0</dc:creator>
      <dc:date>2016-11-16T13:03:25Z</dc:date>
    </item>
    <item>
      <title>Re: The value of ACT_INST_ID_ is null in table ACT_HI_DETAIL from sub process</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/the-value-of-act-inst-id-is-null-in-table-act-hi-detail-from-sub/m-p/244926#M198056</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;PR merged into master and into activiti6 branch.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Please make a new build and re-check if the bug reproduces.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 21 Nov 2016 14:12:50 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/the-value-of-act-inst-id-is-null-in-table-act-hi-detail-from-sub/m-p/244926#M198056</guid>
      <dc:creator>motorina0</dc:creator>
      <dc:date>2016-11-21T14:12:50Z</dc:date>
    </item>
  </channel>
</rss>

