Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Affordable ASP.NET Hosting Service
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
Click here to go to dev.live.com for Windows Live developer resources
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  Database trouble with dbo.GetScheduleNextTask
Previous Previous
 
Next Next
New Post 8/7/2007 2:29 PM
User is offline Bradley Molzen
58 posts
www.vinocellar.com
10th Ranked


Database trouble with dbo.GetScheduleNextTask 

I'm experiencing extremely slow performance, completely due to the database.  I have one portal on my install.  Changing to ANY page on the portal takes forever until I start killing the dbo.GetScheduleNextTask process in SQL Server management.  Once I kill that process, the page comes right up.

I'm running DNN 4.5.1 and SQL Server 2005.

Any ideas?  What further info might you need to track this issue down? 

Thanks!

 
New Post 8/8/2007 8:32 AM
User is offline Bradley Molzen
58 posts
www.vinocellar.com
10th Ranked


Re: Database trouble with dbo.GetScheduleNextTask 

FYI - I was able to fix this issue by setting my caching defaultProvider to "BroadcastPollingCachingProvider"

This is the recommended setting for the Web Farm environment (alternative config) I am using.

Advice:  Don't think you remember all the settings for Web Farm support just because you've done it a hundred times!   :-)

 
New Post 8/25/2007 5:50 AM
User is offline J.O.
208 posts
9th Ranked


Re: Database trouble with dbo.GetScheduleNextTask 
Modified By J.O.  on 8/25/2007 8:51:02 AM)

Hi,

I am experiencing same problem. I have separte database server and separate webserver. But only 1 webserver, so not really a farm. I also see that this process is killing all performance. Do I have to switch to webfarm or is this something else? I already have the caching provider you mention...

Any help appreciated,

J.

 
New Post 9/23/2007 1:37 PM
User is offline J.O.
208 posts
9th Ranked


Re: Database trouble with dbo.GetScheduleNextTask 

Hi, I am still encountering this problem. Has anyone a solution yet?

AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: Add failed. Duplicate key value supplied.
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.ArgumentException: Add failed. Duplicate key value supplied.at Microsoft.VisualBasic.Collection.Add(Object Item, String Key, Object Before, Object After)at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.AddToScheduleInProgress(ScheduleHistoryItem objScheduleHistoryItem)at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.WorkStarted(SchedulerClient& objSchedulerClient)
Source:
Server Naam: XX

Assume that this process is started more than once...Can it be that a singleton or monitor must be used to avoid the creation of double keys? I did not study the sourcecode yet. But maybe this is the problem?

Can it be that due to the web application setup project way two "core modules" can exist? For instance, I have used the source code for development and use it as well in production. I have seen the compiler creates a dll of about 3MB of the source project. Maybe this is the problem?

 
New Post 9/23/2007 1:49 PM
User is offline Marc Huijbregts
281 posts
www.biservices.eu
9th Ranked




Re: Database trouble with dbo.GetScheduleNextTask 

Check out this post. I think the answer to your problem is provided over there.  Mitcel Sellers even made a blog entry on this matter on his own site. You can find the blog entry over here.

Good luck,

Marc


Regards,
Marc

www.biservices.eu for free nl-NL resourcepacks.
 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  Database trouble with dbo.GetScheduleNextTask
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Easily Build DNN Solutions with XMod
XMod makes it easy to build news articles, house listings, custom feedback forms, product reviews and much more - without programming
www.DNNDev.com
Software Development and Integration with DNN
HNP Solutions focuses on the pragmatic use of technology and process to meet an organization's business objectives. HNP Solutions employs seasoned Enterprise and Solution Architects, Delivery Managers and QA & Business Leads. Our capabilities range from project assessments & recommendations, design & code reviews, to full program implementations. We also work with organizations in need of senior staff augmentation purposes in the areas of Enterprise and Solution architecture.
www.hnpsolutions.com
Willhite & Sharron Realtors
Exemplary service for your Seattle Real Estate needs. It's what you deserve from your Realtor®!
www.alkihomes.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP