Severe MRP Slowdowns / Issues

Hello all,

Our MRP has been having a lot of issues lately, our process went from taking 8-9 hours to over 15, and EpicCare hasn’t given me a lot to work with in terms of coming up with a fix. Can someone please take a look at the log and hopefully give me an idea where to start?

Thanks so much!
TVC MRP Logs - (9.8 MB)

EpicCare’s only real idea on how to fix this would be to run fewer regenerative runs, and fix the “uncountable” number of revisions that aren’t approved.

HI Blake,

Is there any chance you are losing internet or network connection during the run? This seems very odd:

00:42:16 Finished Processing Part:R721906-002
00:42:36 System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

Searching on this type of error I found this post. Perhaps it will provide some clues:

We run full regen nightly and use 5 processes and schedulers. If one were to fail the others would keep going. Maybe bump yours up to 6? We don’t fail much anymore and back when we did it was due to excessively long deletion times on transfer order suggestions and also with bad methods built with resources from multiple plants. Haven’t had those in awhile however…


What version of Epicor are you on?

Also are you still on 3rd Party Hosted, that could be an issue too. Been down this road many times, youd be surprised what caused the slowness… sometimes faulty Firewall Config, NAS, SAN, a RAID Controller being bad, VMWare misconfigurations among other things.

Jose looks like ERP11.2.300.0

Also when did this start? Im assuming you ran MRP for many months prior to this slowness without issue.

1 Like

Wow, this is so common! Wish I had known a year ago.

Well, I just wrote up a PPT on that, since we conquered that, I think:

But that aside, I’d agree this issue is something else.

1 Like

It is showing Kinetic 2023.1.10, we are on the public cloud!

Wow Jason that’s an awesome detailed analysis. This is very useful for how to track down anything taking excessively long in the mrp. Thank you!


1 Like

Yea this is an awesome presentation!

1 Like