[Tracy Yaklyvich, MBA]

?We have a fairly complicated report that typically takes 10 minutes or so to finish processing in MR.  Over the past few days I have tried to run the report but it remains in the Queued status for hours.  When I “remove” the report stays in the cancelling status and is never really removed.  Short of changing the report, any ideas on how I can get it to complete?  Thanks, Tracy

——————————
Tracy Yaklyvich, MBA
Controller
American Society of Health-System Pharmacists
Bethesda MD
——————————

[Steve Erbach]

,

What version of GP and what Management Reporter Cumulative Update are you using? How many users in GP typically? Remote Desktop access or is GP installed on individual workstations? Management Reporter using the legacy back-end database or the data warehouse?

Just the facts, ma’am!

Regards,?

——————————
“Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
WOW Logistics Company – Appleton, WI
Co-Chair, GPUG WI (Green Bay) Chapter
GP 2016 (16.00.0439) / MR 2012 CU15
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach
——————————
Welcome to Dynamics!
You do not have permission.
Call Steve.
(hat tip: Lou Spevack)
——————————
——————————————-

[Tracy Yaklyvich, MBA]

?Steve, my answers are below.  Please let me know what you think.  Thanks so much!

What version of GP and what Management Reporter Cumulative Update are you using? GP 2013 Version 12.00.2130;  MR 2012

How many users in GP typically? 10

Remote Desktop access or is GP installed on individual workstations?  Remote Desktop

Management Reporter using the legacy back-end database or the data warehouse? Data warehouse

——————————
Tracy Yaklyvich, MBA
Controller
American Society of Health-System Pharmacists
Bethesda MD
——————————
——————————————-

[Mark Wiley]

?Hi Tracey,

I would recommend stopping and starting the two MR services that are running on the Management Reporter server. You can do this under Control Panel >> Administrative Tools >> Services — OR — Go into Management Reporter’s Configuration Console. That might solve it. If it doesn’t, try re-booting the Management Reporter server.

——————————
Mark Wiley
Senior Consultant
Tribridge
Akron, OH
——————————
——————————————-

[Derek Krebs]

?…other note to add:

• Yes, restart the Mgt Reporter services to reiterate
• I would shy away from running report with transaction level on larger/longer reports with many rows/Periodic monthly columns/large trees and just generate with Financial & Account
• if the RAM on the Mgt Reporter server is increased that is an inexpensive, easy fix

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

[Steve Erbach]

,

You mean that running a Transaction-level P&L? that generates 600,000 rows in the Reporting.ReportLineTransaction table might be pushing it? Tell me about it!

Regards,

——————————
“Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
WOW Logistics Company – Appleton, WI
Co-Chair, GPUG WI (Green Bay) Chapter
GP 2016 (16.00.0439) / MR 2012 CU15
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach
——————————
Welcome to Dynamics!
You do not have permission.
Call Steve.
(hat tip: Lou Spevack)
——————————
——————————————-