This question is locked. New answers and comments are not allowed.
Hi,
We are using Telerik Open Access version = v2.0.50727 in our ASP.NET (3.5) application. We get very weird error - "Lock request time out period exceeded" SQL Server query analyser does not repond at all. I am posting the error stack trace..
Telerik.OpenAccess.Exceptions.LockNotGrantedException: Telerik.OpenAccess.RT.sql.SQLException: Lock request time out period exceeded. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.next() at OpenAccessRuntime.Relational.fetch.FetchResultImp.rsNext() at OpenAccessRuntime.Relational.fetch.FetchResultImp.hasNext() at Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) at Telerik.OpenAccess.RT.ExceptionWrapper.Throw() at OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.fetchNextQueryResult(ApplicationContext context, RunningQuery runningQuery, Int32 skipAmount) at OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.getNextQueryResult(QueryResultWrapper aQrs, Int32 skipAmount) at OpenAccessRuntime.DataObjects.ForwardQueryResult.get_Item(Int32 indexParam) at Telerik.OpenAccess.RT.ListEnumerator.setCurrent(Int32 _pos) at Telerik.OpenAccess.RT.ListEnumerator.Move(Int32 relative) at Telerik.OpenAccess.RT.ListEnumerator.MoveNext() at Telerik.OpenAccess.Query.TypedEnumerator`1.System.Collections.IEnumerator.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
.....
I would appreciate if any of you can explain why it is happening?
Many thanks.
MG
We are using Telerik Open Access version = v2.0.50727 in our ASP.NET (3.5) application. We get very weird error - "Lock request time out period exceeded" SQL Server query analyser does not repond at all. I am posting the error stack trace..
Telerik.OpenAccess.Exceptions.LockNotGrantedException: Telerik.OpenAccess.RT.sql.SQLException: Lock request time out period exceeded. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.next() at OpenAccessRuntime.Relational.fetch.FetchResultImp.rsNext() at OpenAccessRuntime.Relational.fetch.FetchResultImp.hasNext() at Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) at Telerik.OpenAccess.RT.ExceptionWrapper.Throw() at OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.fetchNextQueryResult(ApplicationContext context, RunningQuery runningQuery, Int32 skipAmount) at OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.getNextQueryResult(QueryResultWrapper aQrs, Int32 skipAmount) at OpenAccessRuntime.DataObjects.ForwardQueryResult.get_Item(Int32 indexParam) at Telerik.OpenAccess.RT.ListEnumerator.setCurrent(Int32 _pos) at Telerik.OpenAccess.RT.ListEnumerator.Move(Int32 relative) at Telerik.OpenAccess.RT.ListEnumerator.MoveNext() at Telerik.OpenAccess.Query.TypedEnumerator`1.System.Collections.IEnumerator.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
.....
I would appreciate if any of you can explain why it is happening?
Many thanks.
MG
1 Answer, 1 is accepted
0
Hi M G,
This error indicates that there is a long running transaction that has locked certain rows for more than the lock timeout period. Here is an article that provides some details.
As suggested in an earlier forum question, did you try increasing the 'connection timeout' value on the connection pool? Do you have a long running transaction that could be causing lock timout, in which case you could consider breaking it into shorter transactions,if possible.
All the best,
Ady
the Telerik team
This error indicates that there is a long running transaction that has locked certain rows for more than the lock timeout period. Here is an article that provides some details.
As suggested in an earlier forum question, did you try increasing the 'connection timeout' value on the connection pool? Do you have a long running transaction that could be causing lock timout, in which case you could consider breaking it into shorter transactions,if possible.
All the best,
Ady
the Telerik team
Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!