topic Is it possible to create a local task variable on a completion event? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-create-a-local-task-variable-on-a-completion/m-p/243602#M196732 <HTML><HEAD></HEAD><BODY><SPAN>I'd like to create a local task variable during the completion event for that task (User Task).&nbsp; I've attempted to do this with a TaskListener:</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />public class RoutingOptionAuditor implements TaskListener {<BR />&nbsp;&nbsp;&nbsp; private Expression routeExpression;<BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; public void notify(DelegateTask delegateTask) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String routingOption = getRoutingOption(delegateTask); // extracts the variable value to store; not shown here<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TaskService taskService = getTaskService(delegateTask);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taskService.setVariableLocal(delegateTask.getId(), "routingOption", routingOption);<BR />&nbsp;&nbsp;&nbsp; }<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>When the last line executes, Activiti coughs up a nice SQL exception: </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />### Error updating database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_VAR_EXE: PUBLIC.ACT_RU_VARIABLE FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) ('5')"; SQL statement:<BR />delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? [23503-192]<BR />### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline<BR />### The error occurred while setting parameters<BR />### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?<BR />### Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_VAR_EXE: PUBLIC.ACT_RU_VARIABLE FOREIGN KEY(EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) ('5')"; SQL statement:<BR />delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? [23503-192]<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I'm interpreting this error to mean that I've attempted to create a new local task variable while Activiti is in the middle of a transaction to delete the User Task.&nbsp; Is that correct?</SPAN></BODY></HTML> Fri, 04 Nov 2016 00:03:08 GMT robojeff 2016-11-04T00:03:08Z Is it possible to create a local task variable on a completion event? https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-create-a-local-task-variable-on-a-completion/m-p/243602#M196732 I'd like to create a local task variable during the completion event for that task (User Task).&nbsp; I've attempted to do this with a TaskListener<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ublic class RoutingOptionAuditor implements TaskListener {&nbsp;&nbsp;&nbsp; private Expression routeExpression;&nbsp;&nbsp;&nbsp; @Override&nbsp;&nbsp;&nbsp; public void notify(DelegateTask delegateTa Fri, 04 Nov 2016 00:03:08 GMT https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-create-a-local-task-variable-on-a-completion/m-p/243602#M196732 robojeff 2016-11-04T00:03:08Z Re: Is it possible to create a local task variable on a completion event? https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-create-a-local-task-variable-on-a-completion/m-p/243603#M196733 <HTML><HEAD></HEAD><BODY><P>I believe the following thread answers this question.<BR /><A __default_attr="228243" __jive_macro_name="thread" _jive_internal="true" class="jive_macro_thread jive_macro link-titled" href="https://community.alfresco.com/thread/228243-complete-task-with-variables" rel="nofollow noopener noreferrer"></A>&nbsp;</P><P>Greg</P><P><A href="https://migration33.stage.lithium.com/t5/tag/bp3/tg-p"></A>‌</P></BODY></HTML> Mon, 27 Feb 2017 14:21:43 GMT https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-create-a-local-task-variable-on-a-completion/m-p/243603#M196733 gdharley 2017-02-27T14:21:43Z