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...Upgrading DNN P...Upgrading DNN P...DNN 4.9.5 to 5.2.3 This operation returned because the timeout period expired.DNN 4.9.5 to 5.2.3 This operation returned because the timeout period expired.
Previous
 
Next
New Post
3/31/2010 4:28 PM
 
Matthew Sabatello


Joined: 6/17/2009
Posts: 117

Hello,

 

I am getting the following error in my Log Viewer throughout the day (between 3:30 and 3:40 20 logs, then between 6:00 and 6:20 30 logs, ect). I just upgraded from DNN 4.9.5 to DNN 5.2.3 and I was not getting this error before. I upgraded my website on my test server then moved the db and folder over to my production server to upgrade the site. Any ideas? Thanks in advance!!!

AssemblyVersion: 5.2.3
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: f95786be-698c-4cf5-a120-a692b70aa26e
InnerException: This operation returned because the timeout period expired. (Exception from HRESULT: 0x800705B4)
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Threading.ReaderWriterLock.AcquireReaderLockInternal
StackTrace:
Message: System.ApplicationException: This operation returned because the timeout period expired. (Exception from HRESULT: 0x800705B4) at System.Threading.ReaderWriterLock.AcquireReaderLockInternal(Int32 millisecondsTimeout) at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.get_ScheduleInProgress()
Source:
Server Name: TOB_WEB_PRI
 
New Post
4/1/2010 5:52 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212
it looks like a scheduler job cannot be completed because it times out. with cleanup jobs for eventlog, sitelog or schedule history this is usually caused by too many records in the database, you may need to clear the table manually by executing the proper command in Host :: SQL: TRUNCATE TABLE {databaseOwner}{objectQualifier}Eventlog TRUNCATE TABLE {databaseOwner}{objectQualifier}Sitelog TRUNCATE TABLE {databaseOwner}{objectQualifier}ScheduleHistory Besides make sure, database transaction log gets truncated during frequent backups.
Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/14/2010 2:31 PM
 
Matthew Sabatello


Joined: 6/17/2009
Posts: 117

Sebastian,

 

Thank you for your response. I am sorry it took me so long to reply. I cleared the Eventlog, ScheduleHistory, and Sitelog manually from the database and then a few days later by executing the SQL commands you gave me on the SQL page, however I am still getting a lot of these error messages in my event log. The back-up of my db went from about 1.2 gigs to a little under 600 MB after clearing these tables (my site has been up for over 5 years). The Sitelog table had almost a million rows of data in it, which is probably not helpful in this case considering I cleared the table and I am still getting timeouts. Does anyone have any other ideas?

Thanks again!
 
New Post
5/6/2010 10:46 AM
Accepted Answer 
Matthew Sabatello


Joined: 6/17/2009
Posts: 117

I ran the following SQL statements from the host - SQL page.

DELETE [XXXXX].[dbo].SearchItemWord

DELETE [XXXXX].[dbo].SearchWord

DELETE [XXXXX].[dbo].SearchItem

TRUNCATE TABLE [XXXXX].[dbo].Eventlog

TRUNCATE TABLE [XXXXX].[dbo].Sitelog

TRUNCATE TABLE [XXXXX].[dbo].ScheduleHistory

The error still occured. I have a site with A LOT of graphics on our homepage and A LOT of traffic (about 20,000 hits per day). We have  a flash player with 7 items scrolling through it, 2 other swf files, and pictures on our homepage, I changed the module caching for everything on the homepage to memory and the timeouts occur much less frequently. I believe this error is a result of a lot of graphics and data on our homepage and a lot of traffic.
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...DNN 4.9.5 to 5.2.3 This operation returned because the timeout period expired.DNN 4.9.5 to 5.2.3 This operation returned because the timeout period expired.


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