Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Management reporter Da...
Microsoft Dynamics AX (Archived)

Management reporter Data Mart database size is getting huge

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi we are using Dynamics AX 2012 R3 and management reporter version 2.1.10001.112.

Data mart database is getting huge ~80GB at the moment even with test data (not much , Full database size is 618MB). Tables statistics shows big amount of data in 'FactAttributeValue' and 'ConvertedAmount'

I reckon, this issue is already fixed for CU10 of MR. (already googled but no luck)

What practices I'm missing? How to control the size of this database. why it is getting exponential even with small test data. Any experience you can share on how to minimize DB size, parameter setting or practices which you are following will be highly appreciated.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter Data Mart database size is getting huge

    Hi Andre,

    I am still looking two different versions on designer and viewer. However, this is of no worry for me at the moment as from the following link it seems to be a known issue (blogs.msdn.com/.../management-reporter-2012-cu11-hotfix-2-now-available.aspx)

    I was not executing client update of HF3 on other machines so that's why encounter version mismatch. I re-configured MR and installed client component on other machines and now I am able to publish and connect fine.

    I can't say at the moment how it'll be with performance. However, we'll get with some other fixes at least to carry on.

    Thanks for your assistance Andre.

    Regards

    Syed 

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Management reporter Data Mart database size is getting huge

    Hi Syed,

    The latest version we run at a customer is CU11 with HF2. Try to re-install the Report viewer with the CU11 hotfix 3 setup media. Then see if this fixes the version number.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter Data Mart database size is getting huge

    Hi Andre,

    Thanks for your response. At the moment, I deleted my DM database and reconfigured (which is 2GB now),.

    As you suggested, I tried installing CU11 (In the sequence, hotfix 2 first and then executed hotfix 3). Installation seems all good. However, I think I am having version mismatch between client and server.

    When I tried connecting to Report Designer and Report Viewer on server, I can connect fine. However, unable to open it from Dynamics AX (GL module). Please note that I have already published connection from MR console (using windows authentication). 

    I also gave a try to directly connect from the short cuts on other remote server and performed test connection. It is failing with the following message

    Opened fine from server

    Report designer version: 2.1.11002.11

    Report viewer version: 2.1.11002.5

    Please let me know your thoughts, seems a known issue

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Management reporter Data Mart database size is getting huge

    Hi Syed,

    I had a problem on a customer as well. The database grew to 90GB where the normal database was 6GB.  This was really exceptional. In your scenario, this looks similar.

    Our problem was fixed in CU11.  It is recommended to install the latest version. Also start with a clean installation, so delete the current MR and datamart databases.

    You also have to check the MR logs. Are there any synchronization jobs generating errors? If this is the case, please update it here. I can provide some SQL scripts to find possible causes.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans