In the last few days we came accross with some strange behaviour of DNN. We have more than 80 portals, the biggest one has around 1500 pages. Suddenly we've started receiving "Timeout expired" errror while trying to add new page (tab) in Page Management section. The problem occurs just on portal - the one with around 1500 pages  (which is not set as parent).

We've searched previously placed threads, but haven't found any useful information.

 System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out at System.Data.SqlClient.SqlConnection. (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) 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 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, String sql, Object[] args) at DotNetNuke.Data.DataProvider.GetAllTabsModules(Int32 portalId, Boolean allTabs) at DotNetNuke.Entities.Modules.ModuleController.GetAllTabsModules(Int32 portalID, Boolean allTabs) at DotNetNuke.Entities.Tabs.TabController.AddAllTabsModules(TabInfo tab) at DotNetNuke.Entities.Tabs.TabController.AddTabInternal(TabInfo tab, Int32 afterTabId, Int32 beforeTabId, Boolean includeAllTabsModules, Boolean startWorkflow) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo tab, Boolean includeAllTabsModules) at DesktopModules.Admin.Tabs.View.CreateTabFromParent(TabInfo objRoot, String tabName, Int32 parentId) at DesktopModules.Admin.Tabs.View.OnCreatePagesClick(Object sender, EventArgs e) ClientConnectionId:0b2105fe-04d4-42ae-a8b8-c01aa6eab9f7 Error Number:-2,State:0,Class:11

Thank you for your time and help

 

 

 

 

Thank you for your prompt response. Is DNN Community version even capable of handling portals with huge amount of pages? We've already tried your TurboScripts but with no success.

Obviously there is an error with DNN core (Page Management section, no 3rd party modules involved). What about rebuidling indexes on the Tabs related tables? Actually any information where to look to solve this issue would be very welcome.