<?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 Set a variable after ActivitiExecution.take results in foreign key constraint violation error in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/set-a-variable-after-activitiexecution-take-results-in-foreign/m-p/204704#M157834</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; I've encountered the error described below&amp;nbsp; (occured with Activiti BPM 5.18) while playing with ActivityBehavior .&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; I'm just wondering whether it is an issue or I've just misused a ActivityExecution reference.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; I've made a simple unit test consisting of a start event, a service task and a none end event.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; The service task just calls the Java test.BpmTaskUnitTest1 class below.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;package test;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;import org.activiti.engine.impl.pvm.PvmActivity;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;import org.activiti.engine.impl.pvm.delegate.ActivityBehavior;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;import org.activiti.engine.impl.pvm.delegate.ActivityExecution;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;public class BpmTaskUnitTest1&amp;nbsp; implements ActivityBehavior {&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;/**&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; * Set serial version&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; */&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;private static final long serialVersionUID = 1L;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;@Override&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;public void execute(ActivityExecution execution) throws Exception {&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;PvmActivity activity = execution.getActivity();&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;System.out.println("[DEBUG] —-&amp;gt; call ActivityExecution.take");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;execution.take(activity.getOutgoingTransitions().get(0));&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;System.out.println("[DEBUG] —-&amp;gt; set variable");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;execution.setVariable("variable", "myValue");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;}&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;}&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; When stated the process raises the exception of "java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (OGW_BPM_3.ACT_FK_VAR_EXE) violated - child record found.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; Setting the debug level for both iBatis and Activiti log, I observed that DbSqlSession class tried to insert a "VariableInstanceEntity" while there wasn't a corresponding&amp;nbsp; parent table record any longer:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; … persistence.entity.ExecutionEntity - destroying ProcessInstance[712534]&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; …&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; … impl.db.DbSqlSession - flush summary: 10 insert, 0 update, 0 delete.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; … &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; … impl.db.DbSqlSession -&amp;nbsp;&amp;nbsp; insert VariableInstanceEntity[id=712541, name=variable, …&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; …&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; impl.interceptor.CommandContext - Error while closing command context org.apache.ibatis.exceptions.PersistenceException:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; ### Error updating database.&amp;nbsp; Cause: java.sql.SQLIntegrityConstraintViolationException: &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&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; ORA-02291: integrity constraint (OGW_BPM.ACT_FK_VAR_PROCINST) violated - parent key not found&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; …&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; Bye.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Andrea&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 18 Aug 2015 16:53:45 GMT</pubDate>
    <dc:creator>andrealuciano71</dc:creator>
    <dc:date>2015-08-18T16:53:45Z</dc:date>
    <item>
      <title>Set a variable after ActivitiExecution.take results in foreign key constraint violation error</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/set-a-variable-after-activitiexecution-take-results-in-foreign/m-p/204704#M157834</link>
      <description>Hi,&amp;nbsp;&amp;nbsp;&amp;nbsp; I've encountered the error described below&amp;nbsp; (occured with Activiti BPM 5.18) while playing with ActivityBehavior .&amp;nbsp;&amp;nbsp;&amp;nbsp; I'm just wondering whether it is an issue or I've just misused a ActivityExecution reference.&amp;nbsp;&amp;nbsp;&amp;nbsp; I've made a simple unit test consisting of a start event, a service task and a</description>
      <pubDate>Tue, 18 Aug 2015 16:53:45 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/set-a-variable-after-activitiexecution-take-results-in-foreign/m-p/204704#M157834</guid>
      <dc:creator>andrealuciano71</dc:creator>
      <dc:date>2015-08-18T16:53:45Z</dc:date>
    </item>
    <item>
      <title>Re: Set a variable after ActivitiExecution.take results in foreign key constraint violation error</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/set-a-variable-after-activitiexecution-take-results-in-foreign/m-p/204705#M157835</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi Andrea,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;If you first set the variable and then call the take method on the execution, does it work then?&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>Wed, 19 Aug 2015 20:06:08 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/set-a-variable-after-activitiexecution-take-results-in-foreign/m-p/204705#M157835</guid>
      <dc:creator>trademak</dc:creator>
      <dc:date>2015-08-19T20:06:08Z</dc:date>
    </item>
    <item>
      <title>Re: Set a variable after ActivitiExecution.take results in foreign key constraint violation error</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/set-a-variable-after-activitiexecution-take-results-in-foreign/m-p/204706#M157836</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Yes, it does.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;The error occurs whenever, and only if, a variable is set after the call to take().&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Kind regards.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Andrea&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Aug 2015 20:19:29 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/set-a-variable-after-activitiexecution-take-results-in-foreign/m-p/204706#M157836</guid>
      <dc:creator>andrealuciano71</dc:creator>
      <dc:date>2015-08-19T20:19:29Z</dc:date>
    </item>
  </channel>
</rss>

