SBX - Search With Button

SBX - Forum Post Title

Project Maintenance screen (PA.PRJ.00) SLOW to load project when it has hundreds of tasks

Microsoft Dynamics SL Forum

John Lian asked a question on 3 May 2019 3:39 PM
My Badges

Question Status

Verified

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?

Reply
Carolyn Froton responded on 8 May 2019 9:59 AM
My Badges

Hello John,

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?

Best Regards,

Jana MacDonald

Project Support specialist Microsoft Dynamics SL

Reply
John Lian responded on 8 May 2019 3:15 PM
My Badges

In one example, one project has over 400 tasks.  It takes over 1 minute to pull up that project into Project Maintenance screen.

Reply
Carolyn Froton responded on 9 May 2019 12:03 PM
My Badges
Verified Answer

Hello John,

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  

select *  

from PJPTDSUM, PJACCT  

where  

PJPTDSUM.project = @parm1 and  

PJPTDSUM.pjt_entity  like  @parm2 and  

PJPTDSUM.acct like @parm3 and  

PJPTDSUM.acct = pjacct.acct and  

PJACCT.id1_sw = 'Y'  

order by  

PJPTDSUM.project,  

PJPTDSUM.pjt_entity,  

PJACCT.sort_Num  

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.

Best Regards,

Jana MacDonald 

Microsoft Dynamics Support

Project controller series.

Reply
John Lian responded on 9 May 2019 4:21 PM
My Badges

Hi Jana,

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.

Thanks!

Reply
Carolyn Froton responded on 9 May 2019 12:03 PM
My Badges
Verified Answer

Hello John,

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  

select *  

from PJPTDSUM, PJACCT  

where  

PJPTDSUM.project = @parm1 and  

PJPTDSUM.pjt_entity  like  @parm2 and  

PJPTDSUM.acct like @parm3 and  

PJPTDSUM.acct = pjacct.acct and  

PJACCT.id1_sw = 'Y'  

order by  

PJPTDSUM.project,  

PJPTDSUM.pjt_entity,  

PJACCT.sort_Num  

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.

Best Regards,

Jana MacDonald 

Microsoft Dynamics Support

Project controller series.

Reply

SBX - Two Col Forum

SBX - Migrated JS