Management Reporter Process Service keeps stopping

(0) Share

Report

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

*This post is locked for comments

All responses (12)

Answers (0)

Ryan Sandness on at

Like (0)

Report

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 150 on at

Like (0)

Report

RE: Management Reporter Process Service keeps stopping

Hi Ryan,

I have CU9 for Mexico Localization.

Thanks,
Ryan Sandness on at

Like (0)

Report

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 150 on at

Like (0)

Report

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 on at

Like (0)

Report

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 935 on at

Like (0)

Report

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 85 on at

Like (0)

Report

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 935 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 935 on at

Like (0)

Report

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.