Tasks stuck in ACTIVE status

Hello,

Has anyone else had a problem with some tasks that stay ACTIVE even after they appear to complete or crash?

The only workaround I have found so far is to delete the task from the ice.systask table. However, there has got to be a better way. I would prefer to not loose the task history.

Thanks

Something to think about if you delete records in systask table.

If a task is tried to be cancelled there is a record in the SysTaskKill table. If you just delete a task that has been cancelled from the System Monitor you may have a mismatch between the SysTask table and the SysTaskKill table. Support first had me delete the hung task from the table directly but I was left with a record in the systaskkill table.

If you have this mis-match stop the task agent configurations and delete the records from systaskkill and restart task agent to get the tables back in sync.

Kristine Fierce
Business Systems Analyst
Ag Leader Technology

Thank you, I will start doing that.

I’ve always ignored the SysTaskKill table thinking it would clear up on it’s own but I see that it does not.

Thank you,
Andy

Thank you.
It works perfectly.

I had the same problem with ACTIVE task.
A delete from ice.systask and ice.systaskKill has solved the problem.

Regards,