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

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) / ProdRouteJob table loc...
Microsoft Dynamics AX (Archived)

ProdRouteJob table locked by user

(0) ShareShare
ReportReport
Posted on by Erivelto Tschoeke 60

Gentlemen, I have serious problem actually, I have a lot of problems with  ProdRouteJob table locked by users when they are registering their production´s day. I have around 30 users using DAX in the same time. My mainly question is: There is how I have a route and in the production order moment "scheduling resources" do not anything? Do not  scheduling resources and release the production order? if i´m not clearly i will try answer the questions about this.

Thanks for help.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,553 Super User 2026 Season 1 on at

    Hi Erivelto,

    Please elaborate. Are journals locked in use by users which do not have them open? Do you experience slowness? Did you monitor SQL server for possible table locks? You can also enable SQL monitoring from within the AX client options. Then you get next to the table which is blocked also information about the source code used for that process.

  • Erivelto Tschoeke Profile Picture
    Erivelto Tschoeke 60 on at

    Hi André, there are not journals locked, the problem is in the table ProdRouteJob. How as I told, I have a lot of users registering production in almost same time. Today I will be monitoring this table with SQL Monitor to have some idea about. As soon I get some result I will show you. Thanks a lot.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans