Process MRP Freezes in Next part to process activity

Hello Folks,

I’m running Process MRP in an newly created database where it’s stops at activity :Next part to process stage. I tried by restarting the task agent, deleting and creating a new task agent with all permission enabled. Since i can successfully run the same process in education database that available in the same instance.


when i tried to re-run the same process . It prompts error as below.
image
Kindly suggest an solution to fix the issue. As I have re-created the application server to find either it’s an issue with dll but same result.

It is my understanding that that is still running and you can’t run it until it completes. The only way I have ever gotten 2 to run almost simultaneously is when they are on a schedule and the schedule kicks it off.

Thanks Kimberley,

As you said it’s running for days too even but not goes to scheduled tasks, only way to remove it from ice.systask table to kill the process. Kindly suggest any other ways to achieve results.

I had an issue that MRP was stuck running and they only way I could kill it was by rebooting the server. I have noticed in E10 that I can’t cancel jobs easily or at all.

Have you looked at the MRP logs to see why it is stuck. There could be an issue with the part it is processing.

How can I check the log file, Can you specify the what’s the server path where i find those log files.

You should of set up a path when kicking off MRP. If you did not you will not have a log file. Other wise mine go to here…\{my appserver}\EpicorData\Companies\TASC\Log\manager\MRP_NetChng.log

for urgent issue like this, i will use SQL to find this active task then delete (remove) it form the task agent completely,
In SQL Management, run:

Select * from Ice.SysTask Where TaskStatus = ‘ACTIVE’

Find the SysTaskNum for the offending process.

then run:

Delete from Ice.SysTask where SysTaskNum = ‘Your Sys Task Num’

4 Likes

Try creating a new user named something like ‘sysagent’ and be sure you allow session impersonation. Have your TaskAgent use this user instead of the ‘manager’ user. Make sure you cycle your task agent and app pool after making this change and then see if MRP will run.

Currently I’m using this to delete the old processes.Once after deleting also again my process sturcks any problem with the environment that need to be changed in settings. Kindly suggest.

Hi Brandon,

I had tried with your solution but that doesn’t work as expected. Still the same issue presist. Any other setup need to be verified in aspects of environment or some dll need to be changed.

if it appears again as active and stuck there for long time as you explained, it means that it has been triggered again by the task scheduling or manually (you need to take control of this and stop all users from running this process), then i suggest to go to the system agent and disable it there (i,e. remove the scheduled task or disable it), then log on your epicor server Epicor Administration Console / server management then Task Agent Configuration and stop it then start it, however this will kill all active tasks including printing.


Hello @Kimberley,

When I check the same in my server I couldn’t find any log file available as the folder is empty. Any other way that i can check the status.

you need to specify the path and your log file name where i highlighted, at least run the process after setting the log file path and name, then after killing the process using the method i suggested, then you need to go open the log file and check why it has been stuck and at what stage

Hello @A.Baeisa,

Earlier i have defined my schedule type as Startup. Moreover i couldn’t find any specific schedules for MRP. Please find the screenshot.

never used this option, could be why it starting at each system start up, change it to once or daily and add the log path and name as i suggested and see.

1 Like

As you recommended i have changed the task agent properties and restarted the same.
While i run the process it stucks in the same stage. I have attached the log file. Can you able to find what’s the problem with the file.manager.txt (22.4 KB)

process stuck at finding DNS as per your log, never come across this before you may need to review your Epicor installation process, as it looks more like a server IP/location/Web access issue ,

image

i found many topics about it here, check it, unfortunately it is not my area of experties

OT- DNS Errors over Dial UP

@A.Baeisa

I too find the same but when there’s a problem in DNS or IP it shouldn’t work in education database right. In this case i can execute the same process in education database.
I’m wondering what’s wrong with the settings.
image
I found this table holds foreign key for Systask is something need to be deleted here.

unless if your education database is on the cloud or installed on a different server, try testing your DNS server connection from any other App to eliminate this possibility

has not had to do that, could be a system record of error ‘Failed to complete’ processes.