D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Master Scheduling Deadlock Errors

  • 1.  Master Scheduling Deadlock Errors

    Posted 11 days ago
    Occasionally, I am getting the following error message from running Master scheduling which is run as a batch job during the night;
    Cannot select a record in Net requirements (ReqTrans).
    Deadlock, where one or more users have simultaneously locked the whole table or part of it.


    I was getting this error when I originally made use of 8 helpers, but reducing this to 0 seemed to resolve the issue, however it has begun to reoccur. There doesn't appear to be an issue with the item setup as I can manually run master scheduling without error.

    Has anyone else encountered this issue and is there a workaround or a solution?

    I'm thinking that the code needs amending to include Try..catch..retry keywords.

    ------------------------------
    Paul Fildes
    Steelite International Ltd
    Stoke-On-Trent
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Master Scheduling Deadlock Errors

    MICROSOFT MVP
    Posted 11 days ago
    Hi Paul,

    Which exact version of AX 2012 are you using? Have you searched LCS for a potential known issue?

    ------------------------------
    kind regards,

    André Arnaud de Calavon
    Product manager, Microsoft MVP - Microsoft Dynamics Business Solutions
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Master Scheduling Deadlock Errors

    Posted 10 days ago
    We have had similar issues, getting worse and worse over time, mainly when using helpers, but also occasionally without helpers. Below some of the actions we have taken, to solve the issue :

    Custom code

    Re-design custom code in class\ReqCalc Note: Part 1 (updating fields)

    Clean orphan data

    SQL job to clean up Orphan data

    PAGE lock (REQ)

    Disable PAGE lock for Main REQ tables

    New Index

    New Index creation on ReqTransTable

    Circularity checks

    Clean systematically circularity checks

    PAGE lock (Batch)

    Disable PAGE lock for Main Batch tables

    PAGE lock (ReqLog)

    Disable PAGE lock for ReqLog


    For us the sum of these actions solved the issues. Good luck

    ------------------------------
    Patricia Liekens
    Lantmännen Unibake Holding A/S
    Copenhagen
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role