Developer forum

Forum » Development » Strange error in local environment

Strange error in local environment

Aki Ruuskanen
Aki Ruuskanen
Reply

Hi,

I have a strange problem in  my local environment. Maybe somebody here have a suggestion. 

The problem is that my local environment does not want to start. :)  

I just get a timeout with this error. The last thing it tries to do is "Dynamicweb.Ecommerce.Frontend.UrlHandling.ShopUrlDataProvider.InitializeProductUrlDataIndex()".

I have tried to copy our production database to my local site. Same error. 

I have removed all our custom DLLs. Same error. 

I have copied the globalsettings.aspx from production. Same error. 

I am running out of ideas? Maybe some smarter person here has some idea.  :) 

[Win32Exception (0x80004005): The wait operation timed out]

[SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +273
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +765
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4616
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +88
   System.Data.SqlClient.SqlDataReader.get_MetaData() +103
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +621
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3344
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +707
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +302
   Dynamicweb.Data.Database.CreateDataReader(IDbCommand command, CommandBehavior behavior) +563
   Dynamicweb.Data.Database.CreateDataReader(String sql, IDbConnection connection, IDbTransaction transaction, CommandBehavior behavior, Int32 commandTimeout, Dictionary`2 sqlParams) +162
   Dynamicweb.Data.Database.CreateDataReader(String sql, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout, Dictionary`2 sqlParams) +218
   Dynamicweb.Ecommerce.Frontend.UrlHandling.ShopUrlDataProvider.InitializeProductUrlDataIndex() +102
   System.Lazy`1.CreateValue() +732
   System.Lazy`1.LazyInitValue() +189
   Dynamicweb.Ecommerce.Frontend.UrlHandling.ShopUrlDataProvider.AddNodesRecursive(IList`1 entries, UrlDataNode parent, Group group, UrlDataSettings settings) +373
   Dynamicweb.Ecommerce.Frontend.UrlHandling.ShopUrlDataProvider.GetUrlDataNodes(UrlDataNode parent, UrlDataContext dataContext) +305
   Dynamicweb.Frontend.UrlHandling.UrlPageTreeHelper.BuildPageUrlTree() +1657
   Dynamicweb.Admin.GlobalAsaxHandlerProxy.StartDynamicweb(Object sender, EventArgs e) +743
   Dynamicweb.Admin.GlobalAsaxHandlerProxy.EnsureDynamicwebStarted(Object sender, EventArgs e) +112
   Dynamicweb.Admin.GlobalAsaxHandlerProxy.Application_BeginRequest(Object sender, EventArgs e) +139
   Dynamicweb.Admin.Global.Application_BeginRequest(Object sender, EventArgs e) +67
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +218
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +182
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +94

Regards / Aki


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply
This post has been marked as an answer

How many products do you have? If you have many products this could potentially happen.

You can try to empty PageUrlDatProvider column and the parameters from your Page table and restart the application.

SELECT  *  FROM [Page] WHERE [PageUrlDataProvider] <>''

Votes for this answer: 1
 
Aki Ruuskanen
Aki Ruuskanen
Reply

Alright. Thanks for the tip. I'll try that. 

Regards / Aki

 

You must be logged in to post in the forum