Will Morgenweck wrote
Frozen DNN wrote
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I don't know why but I am getting them a lot lately. Not on just one website but all of them. Few of them don't even have any traffic. I use them to test stuff and get these time outs when I am trying to clear the event viewe log, upload a module. What'sn going on? Can anyone please enlight me?
Thanks for your time..
|
Sounds like you need to do some database maintenance. Here is a quick way to clear the event log when you can't do it through the UI
TRUNCATE TABLE {databaseOwner}{objectQualifier}EventLog
Your SiteLog may have also reached a size where the scheduler is not able to clear it out. If that's the case, then you need to delete some rows by using a delete statement. You may want to delete everything older than 30-days. You could also just run the statement above but replace EventLog with SiteLog.
I would also check and see how much space you have available in your transaction log.
Actually, I am doing that but I still get them. They are getting ridiculous! Can't even go from one page to another. I am using th CSS tune up module and other sql querries such as you mentioned but no change.
Here is the latest:
[SqlException (0x80131904): 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) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
System.Data.SqlClient.SqlCommand.ExecuteReader() +84
System.Data.SqlClient.SqlCommand.DeriveParameters() +2842
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
DotNetNuke.Data.SqlDataProvider.GetTabModules(Int32 TabId) +87
DotNetNuke.Entities.Modules.ModuleController.GetTabModules(Int32 TabId) +141
DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +3704
DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +82
DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +3303
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64