web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

MRP and Scheduler Helpers in AX

(0) ShareShare
ReportReport
Posted on by

Okay, I'm having a heck of a time trying to track down what, if anything, the scheduler helpers are doing for my master planning.  I'm an AX administrator so for the most part I'm doing my analysis by digging in to the BATCH* tables, REQLOG and then that table specifically designed (supposedly) to track item process duration: REQPROCESSITEMTRACE.  Now, when I select all PROCESSID/THREADID combinations from that trace table, I'm only showing a handful of threads total, yet I thought each scheduler helper would spawn their own thread.  So if I've configured MRP to use seven scheduler helpers and 20 as an "item distribution factor", I would expect to see eight threads for that task (one for the main process + seven helpers).

Does anyone have additional insight on how I know whether or not helpers are actually being used?  Our MRP takes around six hours - if I can, I would love to speed that up.

It's probably worth noting I have two AOS's - one is a dedicated batch server and has four cores, so I configured it for a max of eight batch threads.  My other AOS has eight cores, so I configured it for a max of 16 batch threads (cores x 2 is what I've seen recommended).

*This post is locked for comments

I have the same question (0)
  • GeorgeB Profile Picture
    345 on at
    RE: MRP and Scheduler Helpers in AX

    Note also that in AX2009 SP1 there is a KB 2693422 - a hot fix available for those using helpers for Master Schedule.  I suspect similar issues exist with AX2012 Feature Pack and for now have stopped using helpers with pleasing result.  A setting of Zero helpers has doubled process time from 10 to 20 minutes, but it has removed a few anomalies from the Master Plan result.  Being a perfectionist, I will be seeing if a fix is available for AX2012!

  • Community Member Profile Picture
    on at
    Re: MRP and Scheduler Helpers in AX

    Allen, is the problem you mention that you can see only one thread in ReqProcessItemTable even if multiple threads were used?

    I experienced this problem and found out there was a bug in standard appl – AX2009 RU5 (5.0.1500.2985). Due to bug in passing parameters to helpers they never write into the ReqProcessItemTrace table.

    Fixing this is easy.

    In the ReqCalc class just add the parameter isItemTraceEnabled into the CurrentThreadList macro.

  • Community Member Profile Picture
    on at
    Re: MRP and Scheduler Helpers in AX

    Thanks Zaheer,

    But how do I know they are actually processing any data?  The fact they are "executing" doesn't tell me much.  Based on the document I'm reading (Master Planning Performance, May 2010) it would appear I should see those helpers (as THREADID's) in the REQPROCESSITEMTRACE table, correct?  I am not, so I'm wondering if the data gets purged, or if the threads actually were initialized but never used.  Basically I want to know what, if anything, the helper threads are doing - literally in SQL query format so I can put it into an SSRS report.

    I'm almost certain my configuration is not optimal, but I don't want to just tinker without some supporting evidence and/or data, which should exist somewhere - I just need to find it.

    Does my question make sense?

  • Zaheer Pottayil Profile Picture
    270 on at
    Re: MRP and Scheduler Helpers in AX

    Allen,

        You should be able to see the scheduler status while MRP is executing in the batch job->tasks screen. You said you have set up 7 scheduling helpers. One of the issues we had faced was that MRP initialization process took a long time. The scheduler helpers were timing out (There seems to be a set timout before they automatically end if idle) before the initialization was complete. A workaround for this was to increase the number of scheduler helpers (99). Since the AOS is configured for 8 batch threads, hence only 7 (plus the main thread) will be used at any given time but if one set of helper expires another becomes available. When the MRP ends, all the remaining threads automatically end.

    ZP

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans