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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Ho w to improve project Estimation performance - ProjForecastCost table

(0) ShareShare
ReportReport
Posted on by

Hi All,

We are facing performance issue while processing Project Estimation functionality, 

while debugging we found from the "ProjControlPeriod" class and "copyEstimateCost" method, if the "ProjForecastCost" table is having hundreds of records for particular Projid it is looping the same number of records form the "copyEstimateCost" method, we have tried deleting the records by keeping less number of records(10-30 records for particular ProjId) from the "ProjForecastCost" table , it is working , it is processing the functionality without stucking the application.

There is no customization on this functionality, we have verified the indexes on the "ProjForecastCost" table. WE observed that if the number of records is less then there are no issues, if the number of records is large then the application is going in the hung state(Freezes).

Please advise us how we can proceed in this issue.

copyEstimateCost.png

Regards,

Akbar

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi  Akbarpasha,

    What AX2012 version do you operate?

    Best regards,

    Ludwig

  • Akbarpasha Profile Picture
    on at

    Hi Ludwig,

    We have Microsoft Dynamics Ax 2012 R3 CU9, kernel version 6.3.2000.326 and Application version 6.3.2000.326

    Regards,

    Akbar

  • Akbarpasha Profile Picture
    on at

    Hi Experts,

    Please provide inputs on the above issue.

    Regards,

    Akbar

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans