dbTalk Databases Forums  

Re: Lock problem in analysis services

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: Lock problem in analysis services in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrej Hudoklin
 
Posts: n/a

Default Re: Lock problem in analysis services - 09-23-2003 , 10:03 AM






Hi,

just restart the OLAP service, that is MSSQLServerOLAPService.

bye,
Andrej



"Bjørn Tingstadengen" <bti (AT) ementor (DOT) no> wrote

I have a OLAP datatabase with serveral cubes. During
editing one of the cubes the network went down. Now I have
a locking problem with this particular cube:

"could not lock object (user xxx on computer xxx has
locked xxx. Description: Cube editor has locked cube xxx
for writing)"

I cannot delete, edit the cube etc. How do I solve the
problem?


Thanks in advance
Bjørn T



Reply With Quote
  #2  
Old   
Pete Hohenhaus
 
Posts: n/a

Default Re: Lock problem in analysis services - 09-23-2003 , 01:09 PM






Bjørn Tingstadengen <bti (AT) ementor (DOT) no> wrote

Quote:
I have a OLAP datatabase with serveral cubes. During
editing one of the cubes the network went down. Now I have
a locking problem with this particular cube:

"could not lock object (user xxx on computer xxx has
locked xxx. Description: Cube editor has locked cube xxx
for writing)"

I cannot delete, edit the cube etc. How do I solve the
problem?


Thanks in advance
Bj rn T
Have you tried stopping and starting MS OLAP Services in the Services
component of Administrative Tools?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.