Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Project report is extremely slow from workstation but only when others are in GP

Posted on by 75,730

Here is a head scratcher for you.

Reports->Project->History->Time sheets

You are on the server and select any time sheet and click Print. The 35+ pages will print to the screen in about 45 seconds.

Now, if you are the only person in GP and run the exact same report on a workstation for the same time sheet you get the exact same performance.

However, if anyone else logs into GP and does not even do anything, it will take over 30 minutes for the same report to appear on the screen.

On the server it does not matter if someone else is in GP.

What could possibly be causing such a discrepancy?

Categories:
  • Suggested answer
    Shannon Aune Profile Picture
    Shannon Aune on at
    RE: Project report is extremely slow from workstation but only when others are in GP

    I agree that it seems strange that just being logged in would cause the performance issue that you are seeing. Maybe you can enable a SQL profile trace and see what events either have longer durations of time passing, or have more calls being made, when you compare both scenarios. Hopefully that will give you some things to pursue further.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Project report is extremely slow from workstation but only when others are in GP

    It is only this report. They enter a lot entries per timesheet which explains the 45 pages. No modifications have been made to this report. I do not see the connection between having no one else in GP and having someone just sitting on their homepage.

  • Suggested answer
    Shannon Aune Profile Picture
    Shannon Aune on at
    RE: Project report is extremely slow from workstation but only when others are in GP

    Hi Richard,

    Is this issue only occurring on this Project Timesheet History report, or are you able to reproduce the same performance issue on any report (i.e. any project reports) or does this just occur on this report? Does it occur on any other non project related reports as well? Are you using the canned report or is this report modified? Just trying to help to narrow down further what else could be coming into play.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans