Tuesday, July 31, 2012 8:30 PM
I issued a delete in SSMS to a mining structure (simply right clicked on it and picked delete), the delete objects window opened and I clicked okay. This window has been 'executing' for hours on our development server. Any ideas what would cause it to take so long to delete? Its not that big of a database....
Wednesday, August 01, 2012 12:48 AMAnswererIs somebody else performing some actions on the same database? (e.g. somebody send query to retrain the mining structure, so your query is waiting for the other query to complete)
Tatyana Yakushev [PredixionSoftware.com]
Wednesday, August 01, 2012 10:30 AM
You can always use some DMX and XMLA code:
--MDX to find active sessions
SELECT * FROM $system.DISCOVER_SESSIONS
--XMLA "to kill" sesion with given SESSION_SPID
If there were some active sessions using this mining structure DROP won't work (use XMLA "to kill" it and then DROP) .
Be careful, do not kill important sessions.
Wednesday, August 01, 2012 12:23 PM
When I run the "select * from $system.Discover_Sessions" command I get the following message:
The $system cube either does not exist or has not been processed.
Then if I right click in SSMS and choose process all I get is this window below. I let it sit there for 30 minutes and the window hasnt changed. The green circle continues to spin but nothing else happens.
Any ideas what would cause this or how to resolve?
- Marked As Answer by ZackBostonMA Wednesday, August 01, 2012 2:34 PM
Wednesday, August 01, 2012 2:34 PM
FYI: We restarted the SSAS service and it resolved the problem.