Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / The "release to p...
Finance | Project Operations, Human Resources, ...
Suggested answer

The "release to production" report takes too long to generate

(0) ShareShare
ReportReport
Posted on by norbertb 90

I have a problem generating a report. Warehouse: SUR_C. For example, today the report from the beginning of the month to today has been set up. It gets around 4h-6h. Before, it was 1.5h-3h. And it always took a dozen or so minutes. We always make such a report at the end of the month, i.e. for example, we made a report for the entire October 2020.
Once there was a situation where on one of the computers the same report was generated for 1.5 hours and on mine it was 3 hours. Why is it taking so long? Do you have any ideas for a solution to make the report run shorter?

  • norbertb Profile Picture
    norbertb 90 on at
    RE: The "release to production" report takes too long to generate

    Ludwig,

    what do you think a programmer should improve?

  • norbertb Profile Picture
    norbertb 90 on at
    RE: The "release to production" report takes too long to generate

    Hi Ludwig,

    actually the problem is it takes too long to generate. Now 4h-6h is being generated. 3 months ago it was generated in 15 minutes. Here's the problem. Fact - I will probably have to talk to the developer.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: The "release to production" report takes too long to generate

    Hello norbertb,

    I am wondering what report that is?

    I don't know a standard "release to production" report and assume that this is something that has been developed especially for your company.

    Is that right?

    If so, can you have a talk with the developer who created that report?

    There might be something wrong in the general design.

    Also, can you let us know for what you need this report for?

    In other words, what kind of business process does this report support and why is it needed?

    Many thanks and best regards,

    Ludwig

  • norbertb Profile Picture
    norbertb 90 on at
    RE: The "release to production" report takes too long to generate

    Hi Andre

    Thank you for your answer!

    Could I find out where to check the reasons mentioned? I'm just a beginner :)

    There is nothing I can do in AX while generating a report, all AX is unresponsive and there is no way to do anything - all you have to do is wait for the report to be completed. Nothing special is happening in the task manager - just "not responding" information is there.

    I don't have any programs running on my computer. In AX, I only run the production release report directly. Nothing else.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,888 Super User 2025 Season 1 on at
    RE: The "release to production" report takes too long to generate

    Hi Norbert,

    It can be related to many different causes. To know the answer, you have to start monitoring the system. You can e.g.:

    - check SQL activity monitoring at time of slowness if there are blocking transactions

    - review fragmented indexes. Potentially reorganize or rebuild indexes

    - check all other activity running at the same time

    - monitor hardware resources from the SQL server and AOS servers to see if there is a shortage on e.g. CPU or memory

    - use SQL performance reports to check for long running queries or missing indexes.

    - review coding used to build the report

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,888 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,772 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans