MRP Issues

Good Morning
We have been having some issues with our ‘MRP with Forecast’ runs, these happen on a Thursday evening starting at 17:30,
Every other weekday evening we run MRP without Forecast and in most cases this completes OK.
I am not an Epicor or SQL Admin so am spending a lot of time reading articles here and making small changes that seem to clear a problem only to find another,
We had some trouble with VSS snapshots causing issues on the SQL server, extended the log backup interval to find VSS snapshots still running, these turned out to be the virus software so they got disabled last week,
Friday Morning MRP had failed,
IIS was recycling the App Pool at the time MRP seemed to give up so that was moved out side the MRP window,
This morning MRP has failed, this time I have an error that I have not seen before in the MRP log.
I am hoping someone here with more know how than me can help push me in the right direction,

MRP starts and gets to Building Partlist @ 17:53, just over 5hrs later it fails and reports the connection has been broken,
What connection and why?

Here is that section of the MRP log, There is a Stack Trace after this if it is of any use?

17:53:20 Building PartList Level: 0-0
22:03:54 Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunSubTask: The underlying provider failed on EnlistTransaction.
Inner Exception:
The requested operation cannot be completed because the connection has been broken.

It repeats this until 23:58 at which point this happens, I have removed our actual part number

23:58:25 Process 1 not responding. Abandoned during process ‘Processing Part~XXXXXXXX’

Then at 05:00 MRP is cancelled which is what the System Monitor reports

05:00:11 Cancelling from MrpExp mrp

So my current target is to work out what happens at 22:03 and why the connection breaks

Thank You

You have a timeout on the server. Default is 9 hours, so I guess someone made it 5 hours (odd, usually people extend the timeout…).

You’re still on E10? I don’t remember that far back, but the file will be approximately here on your app server:

C:\inetpub\wwwroot\Production\Server\web.config

(Or whatever you call Production)

Do a Ctrl+F for 5:00:00 and change it. (I think there is more than one occurrence?)

Oh and welcome to the group! Sounds like you are on a new adventure!

1 Like

Hello Jason

You are correct, the system.transactions defaultsettings timepoout was set to 5 hrs,
I have now put this back out to 9 hrs and we will see what happens this Thursday night,

Certainly is a new adventure, we have been running Epicor for around 6 years but I have not been involved in the Admin side to much until now,

Thank You

1 Like

Have you considered excluding the part from the MRP run by unchecking the Process MRP field.

If MRP completes then at least you know it part specific, rather than something at a system level.