Products

Solutions

Resources

Partners

Community

Blog

About

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...Performance and...Performance and...getting 503 errorgetting 503 error
Previous
 
Next
New Post
12/12/2012 1:23 AM
 

Service Unavailable


HTTP Error 503. The service is unavailable.

I am getting 503 error in every 30 mins time. I have to ask from hosting people to restart the application pool. They said this application scripts needs to optimize. But I am just using DNN 6.

Why is this happening? Please any body can advise to fix this? Hosting people are saying that this is not a server issue and it is the application issue.

Please let me know what should I do?


 
New Post
12/12/2012 3:15 AM
 
please check size of the database and top tables. Most likely some cleanup jobs fail.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
12/12/2012 3:27 AM
 
Hello Sebastian,

Could you please advise me how to check and clean db without affecting to the content?

Thanks!
 
New Post
12/12/2012 3:56 AM
 
clear the eventlog, if there are more than 1000 items:
TRUNCATE TABLE {databaseOwner}{objectQualifier}Eventlog
clear schedule history, if there are more than a few hundred items:
TRUNCATE TABLE {databaseOwner}{objectQualifier}ScheduleHistory
Clear search tables and re-index (http://www.deutschnetnuke.de/tabid/13...)

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
12/21/2012 11:35 AM
 

Hello, I did make the step by step everything you guys write here but the app pool was down again. Already created a store proceed to clean the tables every 30 minutes to try to solve the problem, I put a post here with the error, but i get no help, nor even from the Arvixe or DNN.

Service Unavailable - Arvixe - DotNetNuke v.6.2.4 Community Edition

My post: http://www.dotnetnuke.com/Resources/Forums/forumid/198/postid/475466/scope/posts.aspx#475466

Store Procedure

USE [BD]
GO
/****** Object:  StoredProcedure [dbo].[sp_cleanSearch]    Script Date: 21-12-2012 16:28:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_cleanSearch]
AS
truncate table SearchItemWordPosition;
DELETE SearchItemWord;
DELETE SearchWord;
DELETE SearchItem;

Many thanks in advance.

HS


 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...getting 503 errorgetting 503 error


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