[Tracy Yaklyvich, MBA]

Does anyone know how to determine where the bottleneck on an MR report is?  I made some changes to a report and now it times out before finishing.

Thanks, Tracy

——————————
Tracy Yaklyvich, MBA
Controller
American Society of Health-System Pharmacists
Bethesda MD
tyaklyvich@ashp.org
——————————

[Rob Klaproth]

Hi Tracy,

Unfortunately there is no easy way to find out what changes caused the report to run slower.   You will have to revert your report back to the original (hopefully you saved a copy of the row, column, or tree that you changed).  Step through each change one by one.   Save the report and run it again until you find the change that is causing the problem. 

I know it’s painful but it’s pretty much the only way with any software program to troubleshoot what change caused this problem unless there is a debug mode and you’re a developer that knows how to read software code. (I don’t believe MR has a debug mode since it’s not an open source program). 

You can also also review the error logs in the configuration console.  What errors are you getting before during and after the timeout? 

What kind of changes are you making? Generally I find that if you change the report to show transaction and account detail it may slow it down tremendously because it has to get all the transactions so you can drill down, versus just the summary data. 

Adding a few more units to the tree can also bog it down.  Using a huge range rather than calling out the individual accounts on the rows can also be a problem. 

Let us us know what changes you’re making.  It might also be an issue with your data mart. You may want to have your It update MR to the latest version they fixed a lot of data mart errors in CU16. 

Lasty, worst case scenario there is a hack to edit the xml config on the server to increase the timeout so the report will run.  This is bad but if it’s a worst case scenario I can show you the edit to the file.

——————————
Rob Klaproth
Dynamics Certified Professional
(GP Install & Configure)
Sr. GP Consultant
Armanino, LLP
San Diego, CA
——————————
——————————————-

[Tamara DeStefano]

Tracy,
I would recommend making a simple column layout (Just Description and YTD). Then use the current report with the new column.  If it still times out, you can assume your issue is in the row layout. If it does not, it is likely in your column.  Once you identify which has the issue, try adding a few rows or columns at a time to a new definition until you time out again.

I hope that helps. Good luck!
-Tammy

——————————
Tamara DeStefano
Senior Accountant
Phigenics, LLC
Downers Grove IL
——————————
——————————————-

[Derek Krebs]

?Another simple trick is to Restart the Mgt Reporter services.

——————————
Derek Krebs
Sr Consultant
MSX Group
derek.krebs@msxgroup.com
——————————
——————————————-