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