Active tasks during windows server updates

We currently have some long running tasks such as Build Project Analysis that can take up to 6 hours to complete. On Sunday, our sysadmin had to restart our server to apply some windows updates. There was a long running task instance that was running when they restarted.
When Kinetic and the task agent starts back up, it shows the task as active even though it isn’t. I can’t seem to delete the task now either.

How does everyone handle windows server updates? Do you have it in work instructions to cancel all tasks before restarting a server, or do you deal with the aftermath like I am now?

Allow removal of dead tasks from the System Monitor without Epicor Support - 4767

If you know a way, cough-cough, you modify the SysTask record by marking TaskStatus as Cancelled or Error and set the History flag to true.

You may also need to delete the associated record in the SysTaskKill table.

3 Likes

In my experience, we agree with infrastructure people on the time in which they can restart the servers and we do not schedule any task at that time (and also give margin for any scheduled running tasks before the agreed restart time period to finish on it’s own).

Cancelling the complex and long running tasks also sometime put them in hanging state (I think it have to do something with the progress level of the task). Invoice posting process usually flushes out itself but do take some time given large number of invoices were being posted. Report previews are pretty simple and usually a good candidate for DB update :slight_smile:

2 Likes

You can ask support for a data fix called FX_Del_SysTaskTables. It’s locked your version so it needs to be requested after an upgrade.