Stuck Active Tasks

[josecgomez]

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 (Brandon Anderson)]

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]

Thank you!

[Jason_Woods]

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’):

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