255
I have a client that is using Management Reporter for financial statements and their Management Report database size is now over 50GB. One particular table (ReportLineTransaction) seems to be part of the problem. Is there a setting, in Management Report, that deletes history or truncate the transaction from tables? It looks like this table holds information for specific report IDs, rowindex.
*This post is locked for comments
Please install Management Reporter RU5:
blogs.msdn.com/.../management-reporter-ru5-brings-new-features-support-for-new-countries.aspx
I hear you, but I am merely a consultant which it sounds as if you are as well. It doesn't make sense. You are right, but Microsoft has acknowledged that fact and is working on solutions. The MR 2012 Service Pack from September 28 resolves some of these issues.
We had one customer who's database grew to 70GB's in a matter of weeks. In the meantime you could build a SQL script that would clear out those tables on a job.
Why is there not a setting of somekind to automate deletion of reports after a specific time period? The situation is causing many of my multi-company, large transactional customers a nighmare in overall slowdowns not only in MR but in GP as the database goes uncontrollably. I went in and removed some versions and took their db size from 11 gb to 4 gb, but to have to maintain removing these on a manual basis seems arceaic.
There is no TK to my knowledge. We worked directly with the MSFT product team on this to get some of the issues resolved but you still have to manually clean up your report versions. Go to Report Viewer app of MR and right click on the reports and go to Versions. Delete the versions. If the report is too big it may time out.
Version 2012 with the latest SP fixes some issues with time outs that prevent deleting large report instances.
We are having the same issue with a client - it has grown to 10 GB within a couple of weeks. Where, EXACTLY, do we go to remove historical instances and WHY is this issue not in the Techknoeledge database on MS PartnerSource Support any where? If there is a TK hiding somewhere in PartnerSource and you please provide the number? The oline support database has become nearly impossible to find any real help.
Anders,
I have the same issue with my DB & log file. What was the solutions ? Please.
Thx
Hello Randal,
We are still working with the issue with Beratung. If you delete the unused versions of reports from the library, and then shrink the database, is it still quite large? I will send you an email as we are gathering some additional information on this.
Thanks,
April
April,
Can you post here the information being discussed? I as Beratung have MR clients running very large MR databases causing slowness, consumption of disk space and adding significant time to the database backups. If unable to post, send email to rmayer@summitgroupsoftware.com Thanks!
Hello Beratung,
I tried sending it again, but just in case its aolson@microsoft.com. I am aware of the issue but would like to discuss it with you.
Thanks,
April
April,
Please resend your contact info.
We found the cause of the issue, and it may even explain why users complain that MR is slower than FRx.
Every time you generate a Transaction Detial Level report it writes every transaction line to the ReportLineTransaction table. That table does not truncate those records until you delete the historical instance from the Viewer application. If you don't delete them on a regular basis that table will grow rather quickly every time you generate one of those reports. The problem lies in the fact that the table is indexed and written to frequently. Unless you truncate the table be deleting the instances of the report and/or reindex the table, MR will slowdown. Writing large amounts of data to an indexed table that is large and growing is a heavy operation. It will most likely take exponentially more time to write to the table then it does to read the data to create the report. That may explain the complete around performance of MR. I beleive FRx just wrote each reports data to its own flat file; hence, a huge diference.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (