Deleting an incomplete task using its ID

Submitted by john.b.holland on Tue, 06/16/2020 - 00:54
1
0
-1

We have a workflow that seems to have created a phantom task, in addition to a legitimate one. The legitimate task has been done, and the rest of the workflow finished. Bonita considers this workflow complete. But the phantom task is in there and the workflow sends daily reminder emails because of it. If I have the task ID, can I delete it from the database?

1 answer

Submitted by Pierre-yves Monnet on Tue, 06/16/2020 - 18:34
1
0
-1

Hello,

That's very strange. A task may be active only if the case is active.

Could you check that in the database?

The task is in the "flownode_instance" table. In this table, you have a column name "rootcontainerid". This should be the caseID.

Could you run a select in the table "process_instance" table with this value?

select * from process_instance where id=4234

What is the value?

Do you have another active task with this ID

select * from flownode_instance where rootcontainerid=4234

Then could you install and run the Longboard page on this caseId ?

Thanks

Notifications