SQL Server Performance

Locked Cube

Discussion in 'ALL SQL SERVER QUESTIONS' started by andyt_uk, Mar 5, 2004.

  1. andyt_uk New Member

    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.


  2. satya Moderator

    The only way I think right now is to restart Analaysis services.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. andyt_uk New Member

    Thanks it worked. I tried stopping and then starting sqlserver but didn't think of analysis services.<br /><br />Your help was much appreciated.<br /><br />Many Thanks<br /><br />Andy [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] (now a happy bunny)
  4. rajkadam New Member

    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.

Share This Page