Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / MRP runs for very long...
Finance | Project Operations, Human Resources, ...
Suggested answer

MRP runs for very long time

(0) ShareShare
ReportReport
Posted on by Vaishnavi 45

Hi All,

Our MRP started to take longer times every month and now it runs for almost 14 hours. This is a huge impact for us.

We have tried increasing helpers, upgrading SQL hardware from an infrastructure point of view.

From AX, When we see session logs, we find that the step-> Recalculate item levels takes most of the time (13+ hours).

We do not have customizations in these classes, but we do have a lot of items. Also, we have experienced behavior that it runs quite quicker( 2 hours) in weekends and on holidays where there are no active users.

Any pointers would mean a lot.

Thank you.

  • rpm Profile Picture
    rpm 10 on at
    RE: MRP runs for very long time

    Additional information for those interested...

    AX Environment: AX 2012R3 CU13

    The current MRP configuration related information:

    1. Single AOS Batch server dedicated to MRP batch

    • 4 CPU(s)
    • 32 GB Memory
    • 8 Maximum Batch Threads

    2. MRP Batch Job

    • 7 Helpers
    • Regenerative
    • Tracking process task duration

    3. Master Planning Configuration

    • BOM Circularity 
      • Level of circularity: Line
      • Check Strategy:  Optimize for low complexity
      • Max levels: 15
    • Number of tasks per bundle:  10
    • Use of cache: Maximum
    • Pre-processing/Post-Processing selected

    We have tried multiple changes to these settings without any success.

  • rpm Profile Picture
    rpm 10 on at
    RE: MRP runs for very long time

    Hi.

    I work with Vaishnavi.

    We actually don't receive any "item level is incorrect for item" in the mrp infologs. The only messages that appear is a line per helper indicating that coverage was updated:

    835812.Capture.PNG

    I have read the recommendation  "delete the previous plan" before running MRP from many blogs. However, I have not found a lot of information on what this does exactly.

    Also, which plan(s) should be deleted?  

    We are currently running two plans. A static master plan and a dynamic master plan. A nightly regenerative plan is being run on the static master plan, with the results being copied into the dynamic plan.

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: MRP runs for very long time

    Check the mro log - you probably have al lot of these messages ;Item level is incorrect for item" xxx

    You should run mrp full regen when no-one else is logged on. 

    Under Periodic and BOM you have a routine called "Recalculate BOM Levels" -run this first, or at least once a week or whenever creating an ew item.

    To understand why read :http://fedotenko.info/multithreaded-mrp-and-related-issues/ and also why its not so easy tog et right.

    Consider whether al items need mrp planning, (and level update).

    Before you run mrp always delete the previous plan.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,245 Super User 2025 Season 1 on at
    RE: MRP runs for very long time

    Hi Vaishnavi,

    You can watch a YouTube movie about this topic. Several years back, Microsoft had a session on an event which got recorded: Help! MRP is slow! It can be an eye-opener for you as there are many tips to improve the performance..

  • Suggested answer
    Adrian Serban Profile Picture
    Adrian Serban on at
    RE: MRP runs for very long time

    Hi Vaishnavi,

    The fact that “Recalculate item level” is taking the most time, can be related to the BOM circularity check. Please check how the Circularity check strategy is setup, see following blog for details: cloudblogs.microsoft.com/.../.

    There is a number of KB’s related to the performance of this functionality, (recalculating the BOM level) that I suggest you to check: KB: 4042154 Poor performance of recalculating the BOM level with high number of variant items; KB: 4020816 Circularity check is very slow on the BOM; KB: 4022020 AX takes a long time to finish the Check circularity process for large amount of data; KB: 3192966 Improve BOM level calculation performance, causing delays in MRP and firming; KB: 4093436 SHA1HASH impacting slow performance of MRP BOM level recalculation and circularity check; KB: 4076859 High memory usage during BOM circularity check with high complexity option leads AOS to crash.

    Thank you,

    Adrian Serban

  • Vaishnavi Profile Picture
    Vaishnavi 45 on at
    RE: MRP runs for very long time

    Thanks Sergei,

    We have scheduled the MRP at night times currently so that user activity is less. Its same time window during weekdays and weekends.

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,091 on at
    RE: MRP runs for very long time

    Hi Vaishnavi,

    Are you running the same job on workdays and on weekends with the same parameters? Is there any time window on workdays when user activity is minimal and you can run MRP at this time?

    Personally I would start with real-time query analysis (docs.microsoft.com/.../activity-monitor, DB maintenance, and index tuning (check missing index blog.sqlauthority.com/.../).

    Additional information can be found in www.linkedin.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,925 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans