Was able to fix the issue but it required a failover, restore with recovery of the impacted db's on the previous principal and then failover back to the original node....

Hi John,

I'm facing exactly the same issue on two production databases since a VM failure.

Can you share how/if you found a solution ?  So far the tlog is growing on...

The solution is here : http://sqlmag.com/reporting/managing-analysis-services-activity-14-feb-2010

To show running queries, execute this MDX query :

SELECT * FROM $SYSTEM.DISCOVER_COMMANDS

order by command_start_time

GO

SELECT * FROM $SYSTEM.DISCOVER_SESSIONS

GO

SELECT * FROM $SYSTEM.DISCOVER_CONNECTIONS

GO

Find the...

citrowske (3/29/2010)

---

I got it to uninstall. Found the following link in the Experts-Exchange.

http://support.microsoft.com/kb/953505

It looks scarier than it really was. I didn't have to do most of it. For me,...