Showing posts with label lock. Show all posts
Showing posts with label lock. Show all posts

Friday, March 9, 2012

Please, HELP! OLAP Cube Locked

When I try to process a cube on olap I receive this error message:

Could not lock object (user xxx on computer yyy has locked 'xxxxxxxx'

I already tried to find an option to unlock the cube and I do a restart of SQL service.
I'm worryed about my job !!!! :eek:
Please, HELP ME !!!! :(Is this only when someone else are editing the cube?

Think you can programmatically determinde if a cube is locked (using dso)

LOL...Relax..you can't loose your job cuz of a restriction ms placed.|||Thx Niconel but I' solved today (on morning Italy time) this issue.
Simply, all the OLAP DB was locked.
This is a problem related to the memory management of my server.
When I try to process a larger DB I obtain that error and the solution is: restart OLAP service from the Cluster Admin Consolle.
When I writed that I' m worried about my job I not refer to the data.
I' was worried about my professional skill level !!! :D
Thank you for your reply!
Byez,

Juppa.

Wednesday, March 7, 2012

please solve timeout error

i am facing timeout error problem on my server
using dot net applications
how to solve this
will no lock option causes thisrun perfmon
run a trace with profiler, determine what your longest running queries are,
improve the queries, index your tables, defragment your tables
http://sqlservercode.blogspot.com/
"raghu veer" wrote:

> i am facing timeout error problem on my server
> using dot net applications
> how to solve this
> will no lock option causes this|||Increase the query timeout seconds.
Camillo
"raghu veer" <raghuveer@.discussions.microsoft.com> wrote in message
news:69809B1D-C9A3-423F-8616-83DF6E5626DE@.microsoft.com...
> i am facing timeout error problem on my server
> using dot net applications
> how to solve this
> will no lock option causes this|||how to increase query time out
plz provide me the syntax
"jem777" wrote:

> Increase the query timeout seconds.
> Camillo
>
> "raghu veer" <raghuveer@.discussions.microsoft.com> wrote in message
> news:69809B1D-C9A3-423F-8616-83DF6E5626DE@.microsoft.com...
>
>