Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SQLExpress Timeouts and favicon.icoSQLExpress Timeouts and favicon.ico
Previous
 
Next
New Post
1/2/2006 2:09 PM
 
James Webster

www.mhs87.com
Joined: 12/30/2005
Posts: 63

I've just installed DNN and started setting up my site, but I've noticed a couple of problems.  If the site is idle for a while, then a new request will usually result in a failure (random message depending on page).  If I check my server there is a SQLExpress entry indicating that it is waking up after a period of inactivity.  Right after that entry there is an error message indicating a timeout exception happened with DNN because of SQL.  Is anyone else having this issue?  Is there any way for me to to tune this to avoid this issue?

I was also looking through the protocol logs and noticed lots of 404 for favicon.ico.  I can't find it anywhere in my install directory.  Did I accidently delete it?  How do I resolve this?

Thanks,

James
 
New Post
1/2/2006 7:29 PM
 
James Webster

www.mhs87.com
Joined: 12/30/2005
Posts: 63

Just to make sure it wasn't a one off, I left the site idle again and tried a repro, same thing.

Here's the exact error from the event log:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/2/2006 4:23:41 PM
Event time (UTC): 1/3/2006 12:23:41 AM
Event ID: c077d2ebb8894675a2f05b582c52e7b0
Event sequence: 2
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1645230737/Root-1-127807213899194325
Trust level: Full
Application Virtual Path: /
Application Path: E:\inetpub\MHS87\
Machine name: TSIDC
Process information:
Process ID: 3904
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SqlException
Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Request information:
Request URL: http://www.mhs87.com/Default.aspx
Request path: /Default.aspx
User host address: 10.0.2.101
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Data.SqlDataProvider.GetPortals()
at DotNetNuke.Entities.Portals.PortalController.GetPortals()
at DotNetNuke.Common.Global.CacheMappedDirectory()
at DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E)
 
New Post
1/5/2006 10:31 PM
 
James Webster

www.mhs87.com
Joined: 12/30/2005
Posts: 63

I talked to a friend on the SQL team and it turns out the default connection timeout is 15 seconds and may not be enough time for SQLExpress to spin up a new user instance.  I've added "Connection Timeout=30;" to my connection string.  Crossing my fingers hoping this works.

BTW - for the favicon.ico issue, I did a web search and found several web tools that create one.  I created one for my site, dropped it in my root folder and that problem went away.
 
New Post
6/10/2008 10:07 PM
 
Salvatore Vigliotti


www.salsclub.com
Joined: 3/31/2008
Posts: 95

yes we are having the same time out issue. We are building and have not officially launched yet still in testing phase and are buying and testing modules to see what is going to happen.
 
New Post
6/11/2008 8:06 AM
 
Salvatore Vigliotti


www.salsclub.com
Joined: 3/31/2008
Posts: 95

Read some interesting stuff from a guy in the forum that the site cache's things. If you are loading alot of pictures or large files. It will take time for the cache to clean itself out. I think at some point something will have to be written to tell the difference between just a file upload and traffic to the site. If I am understanding the architecture of what is going on. I'm no pro but this is the only common sense answer i have found in the forum with this issue. I am sure it will only be time or the next update before it is taken care of but it is not to big of a issue for us we don't get a ton of traffic to or site.

Peace and if I am just tutting BS Someone please correct me.

Thanks
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SQLExpress Timeouts and favicon.icoSQLExpress Timeouts and favicon.ico


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out