Hi Guys,
I have a solution with a rather large set of products. I am trying to run the index but no matter what I do, I get the timeout message and eventually a Native Lock message.
Usually this timeout was thrown when the time needed to run the Count() operation exceeded 20 seconds. Since the timeout is not editable, I can't get past this step.
Here is the error (not sure if it helps)
<span style="cursor: pointer; color: red" title=" at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Dapper.SqlMapper.<QueryImpl>d__61`1.MoveNext() in D:\Dev\dapper-dot-net\Dapper NET40\SqlMapper.cs:line 1589
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType) in D:\Dev\dapper-dot-net\Dapper NET40\SqlMapper.cs:line 1479
at Jayco.eCommerce.JaycoProductIndexBuilder.GetSerialNumbers(String productId) in C:\Projects\BrandFusion\Jayco-FloydPepper\src\Jayco.eCommerce\Infrastructure\Indexing\JaycoProductIndexBuilder.cs:line 44
at Jayco.eCommerce.JaycoProductIndexBuilder.ExtendDocument(IndexDocument document) in C:\Projects\BrandFusion\Jayco-FloydPepper\src\Jayco.eCommerce\Infrastructure\Indexing\JaycoProductIndexBuilder.cs:line 25
at Dynamicweb.eCommerce.Indexing.ProductIndexBuilder.WriteDoc(IndexDocument doc, Int64 currentAutoId)
at Dynamicweb.eCommerce.Indexing.ProductIndexBuilder.ProcessProducts()
at Dynamicweb.eCommerce.Indexing.ProductIndexBuilder.Build(IIndexWriter writer, Tracker tracker)" class="ng-binding">Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</span>
Please help,
Thanks,
Adrian
