Microsoft Dynamics AX (Archived)

Master planning error

(0) Share

Report

Posted on by Kaushik Ramakrishna

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

I have the same question (0)

All responses (6)

Answers (0)

Fredrik Sætre 12,644 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 300,894 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Kaushik Ramakrishna 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kaushik Ramakrishna 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tim Schofield on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,894 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No