Stuck Active Tasks

josecgomez · November 14, 2018, 1:32pm

I have a metric crap load of tasks just sitting in active but they are not actually active they are super old. Any way to clear this?

Banderson · November 14, 2018, 1:57pm

ClearActiveTasks.baq (29.6 KB)

I used this one when I get that. I only have one most of the time though, so I don’t think my query handles multiple rows, but I’m sure you can figure out how to make it work.

josecgomez · November 14, 2018, 2:08pm

Thank you!

Jason_Woods · June 2, 2020, 4:05pm

Thanks @Banderson! I just used this and it is perfect. I had to install it on a newer environment to see what you did. For everyone else, once you have a uBAQ with SysTask (filter by TaskStatus = ‘Active’):

Create Custom Action (“Delete” is best)
Add an Advanced BPM to the Base Processing of “RunCustomAction”
Use the Invoke BO widget with Ice.SysTask.DeleteByID and the configured parameter of queryResultDatasetResultsRow.SysTask_SysTaskNum
Save BPM
Run Get List
In the bottom right of the Analyze tab, select the dropdown for Delete, and click “Run Custom”