Report Recovery in SMP v7.1
Well, I finally did it. Not that I was trying to, it's just that the SMP doesn't/can't recover from my mistake. Hours of work down the drain, unless someone can help.
I created a report and thought I'd done everything right. Saved it and of course it began to run, and run, and run, and run. 10-15 minutes later, I get a message that the report timed out and to contact my administrator. Well, I'm the administrator and I don't have a clue.
The console doesn't lock. I can select another report or menu item and navigate away from this report. But because reports autorun, I can't get back to this report to edit it. If I click the browser's stop button, the report/query stops running, but the screen is still dimmed with the "Please wait" bar in the middle.
I can right-click the report and "view XML", but what a pain to decipher all that crud to find all my parameters and SQL statements.
Already set to 800 seconds.
Already set to 800 seconds. That's why it takes so long to get the timeout. Not sure if that would help get the edit button back since it's already timing out. Don't really want to wait even longer for my report to appear or timeout...
I went ahead and re-created the report from scratch. I viewed the XML, and was able to retrieve my SQL query and parameters. Not exactly an ideal solution, but it worked. Had to start over two more times before getting it right.
Whatever you do, don't ever make a mistake with your SQL and parameters. It's terrible.