Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum / Management Reporter Pr...
Microsoft Dynamics GP forum
Suggested answer

Management Reporter Process Service keeps stopping

(0) ShareShare
ReportReport
Posted on by TD2012 935

We have reports stuck in que in MR.  I have been through all the troubleshooting tips, including starting and stopping the service and application, we even detached and re-attached the database but we cannot get these reports out of the que.  Is there a script I can run to remove them? 

While trying to troubleshoot we realized that the process service keeps stopping and restarting itself, every 2 minutes or so.  This happens while logged in as the management reporter administrator or the domain administrator or with everyone logged off the server (but not shut down).  This is a new install and these were the first reports we tried to print.  My client tried to remove the first report because it wasn't doing anything and it is still "cancelling" days later.  He did do this from a virtual machine, not sure if that matters.  We can't test this by running a report from a computer directly logged in to the domain because we can't get these reports out of the que.  We are on version 2012 sp2

Occassionally there is an error ( says you don't have permission) but then it starts a few seconds later.  We had security issues with the install but I thought after we were able to integrate with all of our companies and imort our reports from FRx we had fixed all the security issues.

Thank you for any help with this.

Tracey D

 

  • Ryan Sandness Profile Picture
    Ryan Sandness on at
    RE: Management Reporter Process Service keeps stopping

    I did have a chance to go back and do some testing. I wasn't able to reproduce this issue with the information I had. If an issue pops up again, it would be best to open a support ticket and send in a .tdbx of the report so we can try to reproduce the issue here.

    Thanks for the additional information.

    Ryan

  • Maria Carrero Profile Picture
    Maria Carrero 150 on at
    RE: Management Reporter Process Service keeps stopping

    Hi Ryan,

    I have CU9 for Mexico Localization.

    Thanks,

  • Ryan Sandness Profile Picture
    Ryan Sandness on at
    RE: Management Reporter Process Service keeps stopping

    Hi Mary,

    I haven't seen stuck reports or the service stopping in over 18 months. Make sure you are on a recent Cumulative Update of Management Reporter. If you are on a recent CU, I'd love for you to email me and show me what your formula was.

    Thanks!

    Ryan

  • Suggested answer
    Maria Carrero Profile Picture
    Maria Carrero 150 on at
    RE: Management Reporter Process Service keeps stopping

    Hi,

    I had the same problem. I had a report with the definition row with a complex calculate. I removed this formula, and the problem was fixed.

    When I tried to generate this report with this problem, the service was stopping.

    Try check if you have some complex formula in your reports.

    Regards,

    Mary

  • Suggested answer
    Ryan Sandness Profile Picture
    Ryan Sandness on at
    Re: Management Reporter Process Service keeps stopping

    Hello,

    This was narrowed down to a issue where the client has a timezone that doesn't exist on the server. This was fixed with the Management Reporter RU2 release.

    Thanks

    Ryan

  • TD2012 Profile Picture
    TD2012 935 on at
    Re: Management Reporter Process Service keeps stopping

    Our time zones were all correct.  I didn't see this script before, wish I'd known then, this cost my client a lot of money in consultant fees to fix and we have no idea what exactly fixed it.  

  • David Laster Profile Picture
    David Laster 85 on at
    Re: Management Reporter Process Service keeps stopping

    1st, Make sure the time zone of the client machine is the exact same as the MR server.  

    2nd, run this script against the MR database: SELECT TimeZoneId, * FROM.[Scheduling].[Trigger]

    3rd, the TimeZoneId needs to be the same for all reports.  

    My issue was fixed by running a SQL script to setTimeZoneId= 'Eastern Standard Time' which was the server time zone.  The reports immediatly began running after this update was run.

    Also, check your row formats.  Are you restricting rows to units of the tree?  Make sure that each one of those rows has a GL account assigned or the report will also get stuck.

  • TD2012 Profile Picture
    TD2012 935 on at
    Re: Management Reporter Process Service keeps stopping

    Not sure what fixed it.  They did all Windows updates, unistalled MR, then re-installed it.  Made sure to do all steps "run as administrator".  Honestly, for all the hours it took it would have been cheaper to just get GP support involved.  Sorry I couldn't be of more help.  I had 2 IT 'pros' work on it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter Process Service keeps stopping

    Having the same problem here.  Any resolution on this yet?  We have a client down trying to run MR2012 reports.

  • TD2012 Profile Picture
    TD2012 935 on at
    Re: Management Reporter Process Service keeps stopping

    No, I have not been able to get this fixed.  I have some IT people working on it - does your event viewer have the same error regarding time zone?  I meant we were on rollup 1 as well.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans