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