Conversion Workbench tasks stuck in System Monitor Active Tasks

Kinetic ERP
1

Hello,
We upgraded our 10.2.400 production instance to 11.2.400.36 last night (7/18/25). While running Conversion Workbench, two tasks got to a certain percent complete and then stopped progressing. I was able to get them restarted and they show in Conversion Workbench as Complete.

But today I needed to reimport a custom posting rule and was not able to because it said there was a GL Import job already running.

Checked System Monitor and the two conversion tasks are still Active:

image
image863×223 9.52 KB

In System Monitor, I tried deleting the two active tasks but nothing happens. I’ve Recycled IIS, stopped and started Application Pool, stopped and started Task Agent, and rebooted the server. But the tasks will not delete.

Does anyone have any ideas about how to delete these tasks so I can import a new version of one of our custom posting rules?

Thanks!
Kelly

2

Remove from ice.systaskKill and update TaskStatus in ice.systask should fix.

1 Like
3

here is the script I run.

/* set task num below */
use EpicorProduction
--use EpicorPilot
declare @tasknum integer
Set @tasknum = 1562416

select top 10 *
from ice.SysTask
where TaskStatus = 'Active' and SysTaskNum = @tasknum


--BEGIN TRANSACTION

UPDATE Ice.SysTask
SET    EndedOn = GETDATE(),
       TaskStatus = 'ERROR'
--       History = 1
--       AgentSchedNum = 0,
where     SysTaskNum = @tasknum 
		--and 	StartedOn < GETDATE()
       --AND TaskStatus = 'Active'

--COMMIT TRANSACTION



delete ice.systask
where     sysTaskNum = @tasknum
1 Like
4

almost same as mine :slight_smile:

declare @TaskID int=1205046
update ice.SysTask set EndedOn = GetDate(), TaskStatus = 'CanCELLeD', History = 1 where SysTaskNum IN (@TaskID)
delete ice.systaskkill where SysTaskNum IN (@TaskID)
1 Like
5

First of all, thanks so much to both of you for your reply on a weekend! Truly above and beyond!
I will give that a try and reply back.
Kelly

1 Like
6

Thank you both for sharing your knowledge and helping me with my issue. Obviously, both solutions were accurate but I chose the one with the least amount of typing. :grin:
Thanks again!
Kelly

1 Like
7

There is also an Epicor Idea for this:

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

This is for people who don’t have direct access to SQL, or those who’d rather not.

4 Likes