web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics AX (Archived) / AX2009 MRP finishes ea...
Microsoft Dynamics AX (Archived)

AX2009 MRP finishes early and doesn't process everything

(0) ShareShare
ReportReport
Posted on by DavidAtOuray 100

We have had a solidly running optimized static MRP that runs (with helpers) every night for years now. It normally takes about 15 minutes and processes around 10K order lines at this point.

Mid last week, it suddenly started finishing in 5 minutes and processes only ~2K lines, it basically only processes about 5 items inventory and then just stops and hence our inventory data on the majority of items is wrong. Needless to say this is a major issue for us. Since the MRP think its "fine" there are no errors thrown. We have spent the last couple days troubleshooting this and still haven't managed to figure out what is going on. We think there is erroneous data possibly somewhere in salesline or inventtable, but there is a lack of tracing for MRP (unlike AX 2012...).

The only other person that I could find on the net that has this similar issue, said they had a blank ITEMID in the inventtable, unfortunately we do not have such an entry and thus the problem continues.

Any ideas on how to further troubleshoot 2009 MRP?? Even our vendor/partner hasn't been able to figure this out yet.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    If you don't have any customization around MRP then this must be a data issue.

    I suggest you should try to debug data by processing it part be part like with some filter like

    Item group

    Consider validating Item coverage setup and master planning group attached

    consider deleting master plan data before you try to process the data.

    There may be some master planning data setup issue.

    Please debug and provide more details about your findings, that will help us look into solution.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,141 Super User 2025 Season 2 on at

    H Davida

    In addition to Nitesh's answer (debugging might help finding the cause):  

    Is anyone aware of possible setup changes? Do you still have a backup of the database when it was still working? Then you could compare setup and transaction data as well.

  • DavidAtOuray Profile Picture
    DavidAtOuray 100 on at

    Hey guys,

    Thank  you for your prompt replies!

    More details on issue and possible related happenings:

    -We are a 3 person IT department and as far as we know, nobody  has touched any settings for our MRP.

    -We run the MRP at 1:30am every morning. Last good run was 5/7 1:30am. (MST btw)

    -There is no customization to the MRP code, beyond adding a provision for handling blank itemids, which was added after this issue started.

    -on 5/7 during the day, around 10AM, we ran a single instance of a dynamic plan on a single item. Since this we have noticed that when you open "Net requirements" on a salesline, it defaults to the dynamic plan, as opposed to defaulting to the static plan as it always has. Normally we never run dynamic plans.

    Here is what we have tried up to this point:

    - Manually running by item group, one after another- this actually works surprisingly...which makes things more confusing. Also this is run on a client machine as opposed to the AOS server when in batch. But if you add multiple item groups in on these runs, it continues to show the same issue of not planning everything.

    -Deleted AOI files and restarted AOS

    -Deleted the static plan data (Master Planning > Periodic > Delete Plan)

    -We did validate item coverage groups and everything looks fine

    What we are going to try today:

    -Creating 2 databases, one from 5/7 ~1am and one from 5/8 at the same time. Any tips on what tables/data we should be looking at? ReqTrans perhaps?

    -Delete and recreate batch job with different user to run as

    -Run full MRP on client PC naturally, instead of on server

    Any further assistance is appreciated!! Thanks again!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,141 Super User 2025 Season 2 on at

    Hi,

    Can you tell more about the blank item id customization. Where did you apply changes and for what reason? Was there some time between importing the customizations and start using it?

    You can indeed try to recreate the batch job to see if this helps.

  • DavidAtOuray Profile Picture
    DavidAtOuray 100 on at

    Sure, the change was made in ReqTransCache_Periodic\createListsFromQueryRun

    In the first while loop:

    while (runQuery.next())

       {

           inventTable = runQuery.get(tablenum(InventTable));

          //start blank itemid handling

           if (inventTable.ItemId == "")

           {

               continue;

           }

          //end blank itemid handling

           if (!levelItemMap.exists(inventTable.bomLevel))

           {

               itemSet = new Set(Types::String);

               levelItemMap.insert(inventTable.bomLevel, itemSet);

           }

           else

               itemSet = levelItemMap.lookup(inventTable.bomLevel);

           itemSet.add(inventTable.ItemId);

       }

    Also another potential solution we are looking at is SysLastValue table entries for the user that runs the MRP job. We have been told that occasionally it can store old queries and might be doing this and hence not running through all items needed.

    Thanks!

  • Verified answer
    DavidAtOuray Profile Picture
    DavidAtOuray 100 on at

    So we finally fixed it, unfortunately I will have to wait for further testing in the temp testing db we created to narrow it down precisely, but I will mention the steps we took that got the MRP working normally again:

    1- Usage data for the account that runs the nightly job was reset (deleted the entries in SysLastValue, same thing). It's worth noting that we did do this much earlier in the troubleshooting process and, alone, it didn't seem to fix it. Plus when considering #3, this step probably did nothing to affect it.

    2- Deleted unfinished scheduling process from Master Planning > Inquiries > Processes > Unfinished scheduling processes

    3- Recreated MRP night batch job and changed user that runs it at the same time (same rights though).

    Thanks for all your suggestions!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,141 Super User 2025 Season 2 on at

    Hi Davida,

    Thanks for the feedback. Can you verify your own answer, so this question will be marked as answered?

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans