topic No process instance in execution in Alfresco Archive

No process instance in execution

tdtappe — Fri, 19 Apr 2013 12:04:40 GMT

After getting some unexpected NPEs using CDI (e.g. injecting ProcessInstance) I had a look into the activiti tables and noticed some tasks having a process instance id assigned - but their assigned execution do not have a process instance id.Is this supposed to be possible/allowed?Can anyone shed so

Re: No process instance in execution

frederikherema1 — Mon, 22 Apr 2013 06:59:11 GMT

Can you confirm if I understand your question correct: You have ACT_RU_EXECUTION entries that don't have a PROC_INST_ID_ set.

Re: No process instance in execution

tdtappe — Mon, 22 Apr 2013 07:53:25 GMT

Yes - a whole bunch of them.

Re: No process instance in execution

jbarrez — Mon, 22 Apr 2013 10:08:20 GMT

That can only be done by casting and setting the process instance id your self.

Are you sure this are "first-class" tasks of a process instance? Ie. they are not standalone tasks or subtasks (parentId != null)?

Re: No process instance in execution

tdtappe — Mon, 22 Apr 2013 14:21:47 GMT

AFAICT I don't set any process instance id on my own.
As for the standalone tasks or subtasks: I think I don't have any of these. At least not on purpose.

If I don't miss anything the only thing I do in my app concerning Activiti is starting process instances via RuntimeService and completing tasks via TaskService. And for the time being (I am just exploring Activiti) my process definitions are fairly simple - without any subprocesses or anything.

Re: No process instance in execution

tdtappe — Mon, 22 Apr 2013 20:03:43 GMT

What just popped into my mind: Could this problem be related to suspended processes? While exploring Activiti I made some tests with suspending processes.

Re: No process instance in execution

tdtappe — Tue, 23 Apr 2013 12:44:31 GMT

No, I haven't got suspended processes any longer in my database.

Re: No process instance in execution

frederikherema1 — Wed, 24 Apr 2013 08:25:19 GMT

Can you post a dump of the related ACT_RU_EXECUTION entries that don't have an execution ID defined? Executions without a process-instance shouldn't exist actually… You're using cdi 'BusinessProcess' I presume?

Re: No process instance in execution

tdtappe — Thu, 25 Apr 2013 08:07:43 GMT

Sure. Need some time though - I have to restore a backup of the database first.
What I noticed in the meantime was that obviously only "old" processes were affected. So after removing those "invalid" processes I didn't run into problems (so far). So probably there must have been something strange at that time. But for the time being I have no idea what that could have been. As I mentioned before I did some tests with suspended processes. And I removed pseudo tasks which I used to "pause" the processes right after they were started. Also I switched two service tasks right at the beginning and at the end of the process to "async".

Re: No process instance in execution

tdtappe — Thu, 25 Apr 2013 10:16:06 GMT

Here you are!

Re: No process instance in execution

frederikherema1 — Tue, 30 Apr 2013 06:43:20 GMT

Sorry, I was referring to the ACT_RU_TASK table, that have the missing executtion-ids. I don't see anything in our code that could be causing the absence/disappearing of the ID. So you are saying you cannot reproduce the issue with your process? If you still can, perhaps it's a good idea to extract the process that is showing this behavior, simplify it and create a simple unit-test so we can look closer.

Re: No process instance in execution

tdtappe — Tue, 30 Apr 2013 07:52:26 GMT

No, I don't have act_ru_task records without execution id.

I will try to restore the state when this problem occured.
I just added three more table exports that might be helpful just in case I can't reproduce the problem.

Thanks so far!