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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Project worker reserva...
Microsoft Dynamics AX (Archived)

Project worker reservation screen timing out

(0) ShareShare
ReportReport
Posted on by howalker 1,212

AX 2012: When I am trying to use the worker reservation function on a project, the screen hangs and takes an unacceptably long time to return data, often longer than 10 minutes.  When it does return data, some of the workers' names are repeated and some of the hours that are displayed make no sense.  For example, AX shows me > 101,000 hours for one person in one month.  I assume that AX is finding these records in the tables, and the long query times are due to AX having to sum all these records.  However, no one has done any mass loads of workers in the last few weeks, and only a handful have been added using the standard AX HR transactions.  Any tips for a functional person on diagnosing the problem would be appreciated since technical resources are scarce right now. 

*This post is locked for comments

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

    Hi Howard,

    Have you searched on Issue search for possible hotfixes? (https://fix.lcs.dynamics.com)

    Do you have customizations or an add-on in this area?

  • howalker Profile Picture
    howalker 1,212 on at

    I have not searched but will do that now.  We have a customized interface under development, but the developers have confirmed it is not far enough developed to have ever been tested.  They confirmed the code has never been executed or invoked.  We are proceeding to stop the AOS, clear the cache, and the re-start the AOS.  We also have a backup, and will consider restoring the database (both transactional and model) back to the day before this started happening.  I am still looking for other solutions before taking the restore approach.  

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,118 Super User 2026 Season 1 on at

    Hi Howard,

    Please keep this thread updated once you know more.

  • Suggested answer
    howalker Profile Picture
    howalker 1,212 on at

    The problem I reported has to do with the the transfer pricing set up between legal entities.  AX was taking a long time to display worker records and dramatically overstating hours because the system was finding a huge number of records in the database caused by duplicative configuration in the transfer pricing config.  However, this duplication is not apparent when you look at the config.  

    Before the problem was identified, specific workers were set up by name to be available to another legal entity other than their own. For example, fictitious worker Charles de Gaulle was an employee of the French legal entity and James Bond was an employee of the UK.  We set up transfer pricing for him to work on USA projects.  We also had configuration for all of France to be available to USA projects and to UK projects.  We had USA employees available to UK projects and France projects.  

    After deleting all this configuration and deleting the duplicated records in the database tables, we added back only a single line item for each legal entity: all of UK available to USA projects in the USA legal entity config, and all USA available to France projects in the France legal entity config.  Correspondingly all of France available to UK projects in the UK legal entity config (and as just stated, all of UK available to USA projects).  The results were what we were expecting from the beginning, and no records were duplicated.  Because all of UK was available to USA projects, and all of USA was available to France projects, this chaining made James Bond visible and selectable inside a France project.  Because all of France was available to UK projects, and all of UK was available to USA projects, this chaining made Charles de Gaulle visible and selectable inside a USA project.  Hours were displayed properly.  Solved (though only through trial and error and not because any documentation told us this).

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,118 Super User 2026 Season 1 on at

    Hi Howard,

    Thanks for the feedback. Interesting to read and learn. Can you mark your own answer so the thread will get the status 'Answered'?

  • Community Member Profile Picture
    Community Member on at

    Dear Howard,

    Thanks for sharing this experience, I have one question please, how many records you have before removing duplicate?

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sanhthosh.Kumar.K Profile Picture

Sanhthosh.Kumar.K 2

#2
Raed Salah Bzour Profile Picture

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans