Lock request time out period exceeded

[FISCAL]

Hi,

Processing & dumping 200k size csv file into one of the SQL table and at the same time if some other user tries to access the same table where still it is dumping records, I get the following error- 

[This is a ASP.NET driven application with the use of Telerik ORM version 2010.2.714.1]

Message: 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()

Source: Telerik.OpenAccess.Runtime

StackTrace: System.Exception Throw()

Full Error Log:
 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.RT.ExceptionWrapper.Throw() at OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.executeQueryAll(ApplicationContext context, ImmutableQueryDetails query, CompiledQuery compiledQuery, Object[] para, Int32 skip, Int32 take) at OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.getAllQueryResults(CompiledQuery cq, Object[] para, Int32 skip, Int32 take) at OpenAccessRuntime.DataObjects.OpenAccessQueryImp.executeWithArrayImp(Object[] parameters) at Telerik.OpenAccess.RT.QueryResultImpl.check() at Telerik.OpenAccess.RT.ListEnumerator.get_Count() at Telerik.OpenAccess.Query.ExpressionExecution.PerformDatabaseQuerySingle[TResult,T](Piece`1 piece, Int32& found, Int32 elemAt) at Telerik.OpenAccess.Query.ExpressionExecution.PerformQuerySingle[T,TResult](Piece`1 piece, Expression expression) at Telerik.OpenAccess.Query.Piece`1.System.Linq.IQueryProvider.Execute[TResult](Expression expr) at System.Linq.Queryable.Sum(IQueryable`1 source) at APForensicsDataRepository.InvoiceAnalysis.DetectionRepository.GetTotalnvoiceValues(Int32 processID) in D:\APForensics\branches\InvoiceAnalysisModule\APForensicsDataRepository\InvoiceAnalysis\DetectionRepository.cs:line 81 at APForensicsDataRepository.InvoiceAnalysis.DetectionRepository.ListAllDPFProcess() in D:\APForensics\branches\InvoiceAnalysisModule\APForensicsDataRepository\InvoiceAnalysis\DetectionRepository.cs:line 69 at IsisWebApp.WebUI.InvoiceAnalysis.Detection.frmInvoiceDatasetListing.PopulateGrid() in D:\APForensics\branches\InvoiceAnalysisModule\APForensicsWebApp\WebUI\InvoiceAnalysis\Detection\frmViewDataList.aspx.cs:line 128 


Any idea?

Many thanks.

M G

[Jan Blessenohl]

Hello M G,
Our connection pool has a timeout where we close connecrtions that are busy for a certain time, default is 2 minutes. This should show you where you have too long running operations.

You can set this timeout to 0 which means we do not care or just increase the number of seconds. The timeout can be set in the DSL via the Model Settings Dialog or with the old wizard via Telerik->OpenAccess->Configuration->BackendConfigurations

All the best,
Jan Blessenohl
the Telerik team

[FISCAL]

Many thanks Jan.

I will try to reset to 0.

Cheers,
MG

[Ingo Oltmann]

Hello Jan,

what exactly is the name of the property you are talking about?

Regards,
Ingo

[Jan Blessenohl]

Hello Ingo Oltmann,
I am talking about this:
http://www.telerik.com/help/openaccess-orm/active-connection-timeout.html

Or if you use the new context you have to modify the backendconfiguration before you call the context ctor with:

backendConfig.ConnectionPool.ActiveConnectionTimeout = 1200;

Regards,
Jan Blessenohl
the Telerik team

[Patrice Boissonneault]

What is the unit of the

ActiveConnectionTimeout

property?

1200 seems like an odd number for 2 minutes?

Thanks.

[Jan Blessenohl]

Hello Patrice Boissonneault,
Please have a look here.

All the best,
Jan Blessenohl
the Telerik team

[Patrice Boissonneault]

The article you refer to is talking about seconds where are in your example, you are specifying 1200.  Does that mean 1200 seconds or are those milliseconds (in which case this would only be 1.2 second...).  I'm confused.  Can you please precise the unit of this property.
Thanks.

[Jan Blessenohl]

Hi Patrice,
The documentation is right, it is in seconds. 2 minutes --> 120 seconds.

Regards,
Jan Blessenohl
the Telerik team