Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Master planning error
Microsoft Dynamics AX (Archived)

Master planning error

(0) ShareShare
ReportReport
Posted on by Kaushik Ramakrishna 2

Hi All,

When I try to run MRP in regeneration for all items. I get the below error after almost 2 hours.

Error     Master scheduling          Cannot execute the required database operation.

Error accessing database connection.

Error     Master scheduling          Stack trace: An error occurred while starting TTS transaction.

 

Stack trace

 

(S)\Classes\UserConnection\ttsbegin

(S)\Data Dictionary\Tables\ReqProcessList\Methods\setLevel - line 23

(S)\Classes\ReqTransCache_Periodic\setCurrentLevel - line 13

(S)\Classes\ReqCalc\insertDataItem - line 4

(S)\Classes\ReqCalcScheduleItemTable\insertDataItem - line 3

(S)\Classes\ReqCalc\processTask - line 54

(S)\Classes\ReqCalc\processTasks - line 38

(S)\Classes\ReqCalc\run - line 18

(S)\Classes\ReqCalcScheduleItemTable\run - line 59

(C)\Classes\ReqCalcScheduleItemTable\main - line 11

 

Error     Master scheduling          Unhandled exception

Warning             Master scheduling          Item coverage is partly updated.

We are using AX2012 R3 CU9.

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,820 Super User 2024 Season 2 on at
    RE: Master planning error

    Hi Kaushik,

    Are you saying you moved the model store or just some models from Dev to Prod?

    If you have moved the model store, you had to be sure all environment specific element IDs are the same. E.g. table IDs, field IDs, class IDs. If this was not the case, this could cause your issue.

  • Tim Schofield Profile Picture
    Tim Schofield on at
    RE: Master planning error

    There's a weird error like this which is thrown by master planning when there is a record with a blank item number in the item master (InventTable). If Net requirements is running but a full master scheduling across all items isn't running then it could be data. So for instance try running master scheduling with a filter query applied. If it runs for one item, try a bunch of items, and keep widening your selection criteria until you hit the error.  But of course try the AOS restart and Compile stuff first.

  • Kaushik Ramakrishna Profile Picture
    Kaushik Ramakrishna 2 on at
    RE: Master planning error

    We did this before moving the model from dev to prod.

  • Kaushik Ramakrishna Profile Picture
    Kaushik Ramakrishna 2 on at
    RE: Master planning error

    I tried both batch and client. Same error on both. It is happening everytime we run global MRP however net requirements is running fine. I had my developer investigate event log but found nothing there.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,820 Super User 2024 Season 2 on at
    RE: Master planning error

    Hi Kaushik,

    Did you run the Master scheduling using the batch framework or was it started on your client? It this reproducible or was it an incident? The error said there is a database connectivity error. This could be caused by a failover or other tasks on the SQL server that requires exclusive connections. Have you examined the SQL server logs already?

  • Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at
    RE: Master planning error

    I think you need to do the mini code fix dance. 1, 2+1, 3+1

    1. Restart AOS
    2. Incremental CIL
    3. Complete CIL

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,820 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,514 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans