Hello,
I have a workflow that contains a receive task. Once in that state, the workflow awaits for a signal to move into an end state. I have a process instance that ended without receiving that signal and its last state is the receive task. Are there any means to troubleshoot this by using the activiti tables? I checked in act_hi_actinst and I can see the last transition was to the rececive task and that there is an END_TIME_ value of that but I don't know how to find out what happened after receive task ended - why the end state was not reached. Searching in the RU* tables I can't find any trace of that instance and an attempt to resume the workflow returns an error (ProcessInstance not found).
If it helps, this is what the incomplete workflow looks like:
mysql> select ACT_ID_,ACT_NAME_,ACT_TYPE_,START_TIME_,END_TIME_,DURATION_ from act_hi_actinst where PROC_INST_ID_='cd4df260-1693-11e6-b480-5254007475b8' order by START_TIME_ asc;
+——————-+——————-+——————+———————+———————+———–+
| ACT_ID_ | ACT_NAME_ | ACT_TYPE_ | START_TIME_ | END_TIME_ | DURATION_ |
+——————-+——————-+——————+———————+———————+———–+
| pushGateway | Exclusive Gateway | exclusiveGateway | 2016-05-10 02:44:34 | 2016-05-10 02:44:34 | 1 |
| startRunOrder | Start | startEvent | 2016-05-10 02:44:34 | 2016-05-10 02:44:34 | 1 |
| updatePushedTask | Update Pushed | receiveTask | 2016-05-10 02:44:34 | 2016-05-10 23:30:28 | 74753517 |
| activationGateway | Exclusive Gateway | exclusiveGateway | 2016-05-10 23:30:28 | 2016-05-10 23:30:28 | 12 |
| finishTask | Finish | receiveTask | 2016-05-10 23:30:28 | 2016-05-10 23:30:40 | 12068 |
+——————-+——————-+——————+———————+———————+———–+
And this is a complete workflow:
+——————-+——————-+——————+———————+———————+———–+
| ACT_ID_ | ACT_NAME_ | ACT_TYPE_ | START_TIME_ | END_TIME_ | DURATION_ |
+——————-+——————-+——————+———————+———————+———–+
| pushGateway | Exclusive Gateway | exclusiveGateway | 2016-05-10 02:44:34 | 2016-05-10 02:44:34 | 1 |
| startRunOrder | Start | startEvent | 2016-05-10 02:44:34 | 2016-05-10 02:44:34 | 1 |
| updatePushedTask | Update Pushed | receiveTask | 2016-05-10 02:44:34 | 2016-05-10 16:11:39 | 48424745 |
| activationGateway | Exclusive Gateway | exclusiveGateway | 2016-05-10 16:11:39 | 2016-05-10 16:11:39 | 9 |
| finishTask | Finish | receiveTask | 2016-05-10 16:11:39 | 2016-05-11 10:39:36 | 66476750 |
| endRunOrder | End | endEvent | 2016-05-11 10:39:36 | 2016-05-11 10:39:36 | 0 |
+——————-+——————-+——————+———————+———————+———–+