SQL Server Performance Forum – Threads Archive

Locked Cube

Help urgently needed I have written an OLAP cube on SQL Server 2000 that I access via Terminal Services. This has worked for many months until recently, when I go to edit the cube I get the following message: ‘Unable to open the cube CUBE_NAME’ ‘User MACHINE_NAMEAdministrator on computer MACHINE_NAME has locked CUBE_NAME’ ‘Description: Cube editor has locked cube CUBE_NAME for writing’ I am logged in on the local machine (via terminal services) as Administrator and the MACHINE_NAME’s in the message above are the same as the local machine. What is causing the problem and what is the remedy? Your collective help is most welcome as it is many months of work that is now inaccessable. Thanks Andy

The only way I think right now is to restart Analaysis services.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks it worked. I tried stopping and then starting sqlserver but didn’t think of analysis services. Your help was much appreciated. Many Thanks Andy [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] (now a happy bunny)

Hi, I am also facing same error for cube reprocessing. And I had restarted the analysis server several times. But still I am getting the same error.
Please advice on same.

The only way I think right now is to restart Analaysis services. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>