How do you delete an Active Task in System Monitor?

Epicor ERP 10
1

I was trying to run Global Scheduling and EPICOR got hung up while Calculating the Scheduling order process. I am on EPICOR 10.2.100.9.

2

You can develop an updateable BAQ against the ICE.SysTask and define a custom delete action. When you run the BAQ, select the stuck task and then run the custom action to delete that task

image
image1920×1080 431 KB

image
image1920×1080 339 KB

5 Likes
4

Open system monitor and press on the x. It does take a while for some of the bigger tasks e.g. 30 seconds

image

1 Like
5

Also look up System Agent, where you can find scheduled tasks and delete them.

6

Hey Matt,

Does that work for Calculate Global Scheduling Order? It didn’t do anything when I tried last night. I had to use the BAQ @mjfwagner suggested.

7

Hey Mark,

Thanks for the post, this worked perfectly.

8

See KB0044649 or KB0115574.

I used:

use EPICOR_TEST  -- Run in test database first
delete from ice.SysTask where taskstatus = 'active' and SysTaskNum = '1070172'

Be sure to do the other Task Agent Configuration / Recycle steps too.

9

Im surprised that Epicor is deleting it, versus the more professional method. Brought to you by Mr. @josecgomez

BEGIN TRANSACTION

UPDATE Ice.SysTask
SET    EndedOn = GETDATE(),
       TaskStatus = 'ERROR',
       History = 1,
       AgentSchedNum = 0,
       AgentTaskNum = 0
WHERE  StartedOn < GETDATE()
       AND TaskStatus = 'Active'

COMMIT TRANSACTION
5 Likes
10

Can also be done with the Ice.BO.SysTaskSvc REST service for you cloud users.

11

I’m confused. How does this end the task? Seems like you are just deleting records or marking them completed.

12

It doesn’t. The task ended but the SysTask record doesn’t get updated.

1 Like
13

how i define custom delete action.?