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