E10 Reports Stuck In Scheduled

Do you have scheduled tasks?  I ask because we started seeing it about the time I created scheduled that run every five minutes for Multi-Company Direct  consolidation to our financial consolidation company’s master book.  I had surmised that the app pool stop and DB detach/re-attach when I did restores was doing something to the task agent service when it could not run the task.  I have been considering stopping or temporarily disabling those schedules prior to the DB restore.  There might be other things besides restores that impact scheduled tasks and mess up the task agent service.  Just a thought.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 08, 2015 4:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 Reports Stuck In Scheduled

 

 

We have this issue as well.  Roughly every other day reporting stops working.  We also have a script we keep handy to quickly restart the Task Agent.  Ours doesn't seem to be connected to restoring the DB. I would love to figure out the root of the problem.

In E10 I am trying to run any report and it stays in scheduled even though I am telling it to run now. This has happened once before and a server retart fixed this, however, during a live business day that can't happen. Anyone know how to fix this without having to bring users down? Thanks.

On the E10 server stop and restart the Epicor ICE Task Agent service.  It will not affect users except in a good way (reports will run) because things aren’t running as it is.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 08, 2015 12:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 Reports Stuck In Scheduled

 

 

In E10 I am trying to run any report and it stays in scheduled even though I am telling it to run now. This has happened once before and a server retart fixed this, however, during a live business day that can't happen. Anyone know how to fix this without having to bring users down? Thanks.

Todd,


Thank you very much. Worked perfectly. Do you know why this happens so I can maybe avoid it. Or is it an Epicor issue?

I have the following in a batch command file on the server desktop for easy access.  I need to run it (run as administrator) whenever I restore a DB (Pilot to Test for example) which seems to make the task agent get stuck.

 

NET STOP "EpicorICETaskAgent3.0.7.0"

NET START "EpicorICETaskAgent3.0.7.0"

PAUSE

 

If you have recently restored a DB that could have done it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 08, 2015 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 Reports Stuck In Scheduled

 

 

Todd,

 

Thank you very much. Worked perfectly. Do you know why this happens so I can maybe avoid it. Or is it an Epicor issue?

We have this issue as well.  Roughly every other day reporting stops working.  We also have a script we keep handy to quickly restart the Task Agent.  Ours doesn't seem to be connected to restoring the DB. I would love to figure out the root of the problem.