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.
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