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.
Showing posts with label lock. Show all posts
Showing posts with label lock. Show all posts
Friday, March 9, 2012
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...
>
>
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...
>
>
Subscribe to:
Posts (Atom)