dbTalk Databases Forums  

Strange locking issue between users !!! (SSAS 2005)

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


Discuss Strange locking issue between users !!! (SSAS 2005) in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default Strange locking issue between users !!! (SSAS 2005) - 11-17-2006 , 05:22 PM






Hi,

I just suffer a strange issue which is like a lock issue.
From 2 different stations, I open an analysis using the pivottable and I'm
using 2 different user accounts.
I open the same cube.

I start to play with the first station... and suddenly the pivottable stops
responding when I do something (like a drag/drop, filter or anything)
I don't kill it...

I go on my second station I open a new connection, to the same cube and then
I start playing in the data.
and when I do a first query, this unlock the first user!!!!!
then I continue to play in the cube.... everything is good and same behavior
my user 2 is locked! I wait 2 minutes and no result (normally the same query
takes 1 second)
So, I just change the query on the station 1 (a simple expand for example)
and the user 2 is unlocked!!!!

during all this time the server CPU is not used the queries are really
simple and takes less then 1 second.
and there is only these 2 users during theses tests!

I stop my service and start it again, and I can't reproduce the issue. But
I'm afraid about this problem if the issue appears again.

any idea???????
it was a very strange issue!!!!!

thanks.
Jerome.



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.