topic Duplicate message reception in message catching event in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/duplicate-message-reception-in-message-catching-event/m-p/156515#M110758 <HTML><HEAD></HEAD><BODY><SPAN>We have a cronjob that periodically (every 5s) tries to send a message to an arbitrary process execution waiting on an intermediate message catching event. In each run, the cronjob determines waiting process executions via </SPAN><BR /><PRE class="language-java line-numbers"><CODE>RuntimeService.createExecutionQuery().messageEventSubscriptionName(messageName).list()<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>and sends the message via </SPAN><BR /><PRE class="language-java line-numbers"><CODE>RuntimeService.messageEventReceived(..)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>We experience the odd behaviour that two subsequent cronjob runs (5s apart) sometimes deliver the message to the same process execution (i.e. the execution query yields identical execution IDs), leading to an SQL exception during insert into ACT_RU_EXECUTION (ORA-02291: integrity constraint (ACT_FK_EXE_PROCINST) violated - parent key not found). There are no loops in our process, every execution expects only a single message.</SPAN><BR /><BR /><SPAN>I would expect that the process execution that received a message immediately gets removed from the message event listener list, so duplicate message reception is impossible. Can someone explain to me at which point in time the RuntimeService.messageEventReceived persists the information that the message was successfully delivered? Is this only done when the receiving process execution yields its thread?</SPAN><BR /><BR /><SPAN>Many thanks!</SPAN><BR /><SPAN>/Dennis</SPAN><BR /></BODY></HTML> Wed, 02 Oct 2013 14:18:38 GMT waldo 2013-10-02T14:18:38Z Duplicate message reception in message catching event https://connect.hyland.com/t5/alfresco-archive/duplicate-message-reception-in-message-catching-event/m-p/156515#M110758 We have a cronjob that periodically (every 5s) tries to send a message to an arbitrary process execution waiting on an intermediate message catching event. In each run, the cronjob determines waiting process executions via RuntimeService.createExecutionQuery().messageEventSubscriptionName(messageNam Wed, 02 Oct 2013 14:18:38 GMT https://connect.hyland.com/t5/alfresco-archive/duplicate-message-reception-in-message-catching-event/m-p/156515#M110758 waldo 2013-10-02T14:18:38Z Re: Duplicate message reception in message catching event https://connect.hyland.com/t5/alfresco-archive/duplicate-message-reception-in-message-catching-event/m-p/156516#M110759 <HTML><HEAD></HEAD><BODY><SPAN>Is it possible that the process execution takes more than 5 seconds? When the message is received a transaction is started and the process is executed until the next wait state. Only then the message event listener is removed from the database. If you have some long running logic you could add async behaviour to complete the transaction faster.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Thu, 03 Oct 2013 19:23:21 GMT https://connect.hyland.com/t5/alfresco-archive/duplicate-message-reception-in-message-catching-event/m-p/156516#M110759 trademak 2013-10-03T19:23:21Z