One of our clients is experiencing this issue in SL 2018 CU1. They also experienced the same back in 2011 which they just upgraded from. So it's not a new issue.
Many of their projects have a lot of tasks, hundreds. It would take 1 minute to load such a project into Project Maintenance (PA.PRJ.00) screen, from the time that the project ID is keyed in, to the time the data is displayed. While loading, the screen is not responding.
I could confirm that the speed is directly caused by the number of tasks, as the loading time improves with the reduction of tasks linked to the project.
Is this a known issue that will be addressed? Is there a workaround?
Thank you for your submission, I will research the issue.
But NO..I don't remember anyone submitting a case with this issue. And its likely true.
Hundreds of tasks means what...how many hundreds of tasks?
Project Support specialist Microsoft Dynamics SL
In one example, one project has over 400 tasks. It takes over 1 minute to pull up that project into Project Maintenance screen.
It looks like bug 27537-project maintenance is slow to open with a lot of tasks, and a lot of budgets
I just inserted 800 tasks and it opens in less than maybe 5 seconds. so its the fact that its reading the budgets.
This bug is not fixed, and has been closed as Wont fix
They have a workaround given: Alter the PJPTDSUM_spk2 proc so it never returns any records. This is the proc that loads the budget tab in project maintenance. and this proc is not used anywhere else in the system.
create procedure PJPTDSUM_spk2 @parm1 varchar (16) , @parm2 varchar (32) , @parm3 varchar (16) as
from PJPTDSUM, PJACCT
PJPTDSUM.project = @parm1 and
PJPTDSUM.pjt_entity like @parm2 and
PJPTDSUM.acct like @parm3 and
PJPTDSUM.acct = pjacct.acct and
PJACCT.id1_sw = 'Y'
One would thing that the bolded item should be set to something other than Y or N, perhaps G
Try it and let me know.
Otherwise , you can create a case in Support and I can ask for a HF for 2018 , and it would be for CU3 (CU2 is released already) so they wouldn't see a fix for at least 6 months...not sure when CU3 will be available , likely by the end of the year.
Microsoft Dynamics Support
Project controller series.
The workaround works. But expectedly it caused no data to display on the budget tab, which is not a good permanent fix.
I will open a case to ask for a HF.
Business Applications communities