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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Project Maintenance sc...
Microsoft Dynamics SL (Archived)

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

(0) ShareShare
ReportReport
Posted on by John Lian 22

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?

*This post is locked for comments

I have the same question (0)
  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Project Maintenance screen (PA.PRJ.00) SLOW to load project when it has hundreds of tasks

    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

  • John Lian Profile Picture
    John Lian 22 on at
    RE: Project Maintenance screen (PA.PRJ.00) SLOW to load project when it has hundreds of tasks

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

  • Verified answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Project Maintenance screen (PA.PRJ.00) SLOW to load project when it has hundreds of tasks

    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.

  • John Lian Profile Picture
    John Lian 22 on at
    RE: Project Maintenance screen (PA.PRJ.00) SLOW to load project when it has hundreds of tasks

    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!

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans