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/243999#M197129 <HTML><HEAD></HEAD><BODY><SPAN>I'd like to create a local task variable from a TaskListener when Activiti invokes it for a "complete" event:</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); // this code grabs some text from an enumerated form property value<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TaskService taskService = getTaskService(delegateTask);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taskService.setVariableLocal(delegateTask.getId(), "routingOption", routingOption);<BR />}<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>This code causes a 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>Does the "complete" TaskListener event occur too late in the task's lifecycle to be adding local task variables to it?&nbsp; If so, is there a recommended technique for trying to do this?</SPAN></BODY></HTML> Fri, 04 Nov 2016 15:51:01 GMT robojeff 2016-11-04T15:51:01Z 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/243999#M197129 I'd like to create a local task variable from a TaskListener when Activiti invokes it for a "complete" event<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 delegateTask) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String routingOption Fri, 04 Nov 2016 15:51:01 GMT https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-create-a-local-task-variable-on-a-completion/m-p/243999#M197129 robojeff 2016-11-04T15:51:01Z 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/244000#M197130 <HTML><HEAD></HEAD><BODY><P>I believe the following thread will answer your question:</P><P></P><P><A __default_attr="228243" __jive_macro_name="thread" _jive_internal="true" class="jive_macro_thread jive_macro link-titled" href="https://community.alfresco.com/message/807956-complete-task-with-variables" rel="nofollow noopener noreferrer"></A>&nbsp;</P><P></P><P>Thanks,<BR />greg</P><P><A href="https://migration33.stage.lithium.com/t5/tag/bp3/tg-p"></A>‌</P></BODY></HTML> Mon, 27 Feb 2017 01:26:20 GMT https://connect.hyland.com/t5/alfresco-archive/is-it-possible-to-create-a-local-task-variable-on-a-completion/m-p/244000#M197130 gdharley 2017-02-27T01:26:20Z