Deleting mining structure is taking hours

Question

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....

Answer 1

Is 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]

Answer 2

Hi,

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

<Cancel xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<SPID>SESSION_SPID</SPID>

<CancelAssociated>1</CancelAssociated>

</Cancel>

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.

Regards

gc

Answer 3

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?

Answer 4

FYI: We restarted the SSAS service and it resolved the problem.