Hi Para, My ISP updated the DB in their SQL server and nothing changes, the problem remains... You can check it out in: http://int.artshoo.com/International/Lexicon/10152.aspx Please some help, I'm desperate.
Hi again euroiranian First you don't need to be able to run subdomains to run a certain community on localhost. Just go to ispAdmin, choose the problem community and set a * in both Community Domain and Community Subdomain. I think if you try it on localhost
you'll know a lot more. Second I navigated some in your community. I found it slow to very slow in general. Does the CPU work at a high percentage in general then maybe that server has to many customers or is outdated. For sure it seemed not really well. My
gcn (look at 7d.dk or tni.tni.dk for example) is pretty slow at times, but this is heavy. It timed out pretty soon with an article. My pages have loaded if it were hanging for a longer time than that. Third try to submit a post with reference to this post
in the Community Starter Kit forum. http://asp.net/Forums/ShowForum.aspx?tabindex=1&ForumID=88 I think you know it's basically the same architecture, same articles section. So maybe just call it a cs version of the Community Starter Kit. BTW i can see redd
has been there friday ;)
Hi para, Thanks for your recommendations. Currently we are doing some changes in the db, but immediately after I will try with localhost as proposed. About the navigation speed, I noticed ity too, but I don't know the reason. Maybe because we recently updated
the db and restarted the IIS? I have took a look on you websites and both are working really soon compared by mines. Regarding to post submission to CSK forum, I already did it. Nobody alive in there, post: http://asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=693808
submitted on: 09-16-2004 02:05 AM but still 0 replies. Anyway, I will submit other now. Maybe this time I've better luck...
From the error message you are receiving I think you should check the machine.config file. Check both the 'httpRuntime' and 'processModel' sections of the file. Both sections are responsible for configuring ASP.NET process model setting on an IIS web server.
You maybe exceeding your executionTimeout or Timeout settings. This file in usually installed in the framework\version#\config directory (i.e. C:\WINNT\Microsoft.NET\Framework\v1.1.4322\CONFIG) and is well noted.
The error seems to relate to loading the Comments although I have not tested with a very large number of articles. Here are some things that you could try. Manually test the sp "Community_CommentsGetComments" using query analyser or similar and specify the
same parameters to see if the same error occurs. Increase the timeout in CommentUtility.GetComments to see if that resolves the problem e.g. cmdGet.CommandTimeout = 60 HTH
To see if there are problems with comments or other related parts, you can maybe just try to turn comments and everything unneccesary things off in Advanced for the articles section.
Hi everybody, Maybe Mumfie2003 has found the problem, I don't know. Here is the result of several SP I analyzed, one of them "Community_CommentsGetComments" as suggested. For "Community_CommentsGetComments" 0 rows returned EXECUTION TIME: 0:03:36 (REALLY A
LOT) Messages: (0 row(s) affected) Stored Procedure: artshoo.dbo.Community_CommentsGetComments Return Code = 0 For "Community_CommentsGetComment": 0 rows returned Execution time: 0:00:01 Messages: (1 row(s) affected) (1 row(s) affected) (0 row(s) affected)
Stored Procedure: artshoo.dbo.Community_CommentsGetComment Return Code = 0 For "Community_ArticlesGetArticle": 1 row returned Execution time:0:00:00 Messages: (1 row(s) affected) (1 row(s) affected) (1 row(s) affected) Stored Procedure: artshoo.dbo.Community_ArticlesGetArticle
Return Code = 0 O.K. If I'm correct, the problem came from the Sp "Community_CommentsGetComments", now how to resolve this problem? The "community_Coments" table has only a few rows (178), but I hope it will grow up a lot after few months. Anyway, I don't
think the problem comes from the size of the table or the No. of rows (Am I right?) then, what is the real problem and how to give it a solution? Also, I think this is not important, but…: None of the current rows in that table are related with this community,
there are related to pages in other communities (working without problems all of them), but the column “Comment_Text” have some complex scripts (texts) in some of the rows. I'm feeling that we are pretty near with the help of you all. Thanks.
Hi mumfie2003, Can you be more explicit about how and where can I increase the timeout? I have a CommentUtiliy CS file in C:\...\...\CSKDotNet\Engine\Framework\Comments\Components It reads as follows:
namespace ASPNET.StarterKit.Communities {
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
//*********************************************************************
//
// CommentUtility Class
//
// Contains static utility methods used by the Comments module.
//
//*********************************************************************
public class CommentUtility {
//*********************************************************************
//
// AddComment Method
//
// Adds a new comment to the database.
//
//*********************************************************************
public static int AddComment
(
int contentPageID,
ModerationStatus moderationStatus,
string username,
string title,
string body
) {
SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
SqlCommand cmdAdd = new SqlCommand("Community_CommentsAddComment", conPortal);
cmdAdd.CommandType = CommandType.StoredProcedure;
// Add Parameters
cmdAdd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmdAdd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmdAdd.Parameters.Add("@contentPageID", contentPageID);
cmdAdd.Parameters.Add("@moderationStatus", moderationStatus);
cmdAdd.Parameters.Add("@username", username);
cmdAdd.Parameters.Add("@title", title);
cmdAdd.Parameters.Add("@metaDescription", ContentPageUtility.CalculateMetaDescription(body));
cmdAdd.Parameters.Add("@metaKeys", ContentPageUtility.CalculateMetaKeys(body));
cmdAdd.Parameters.Add("@body", SqlDbType.NText);
cmdAdd.Parameters[ "@body" ].Value = body;
conPortal.Open();
cmdAdd.ExecuteNonQuery();
int result = (int)cmdAdd.Parameters["@RETURN_VALUE"].Value;
conPortal.Close();
return result;
}
//*********************************************************************
//
// GetComment Method
//
// Gets a particular comment from the database.
//
//*********************************************************************
public static ContentInfo GetComment(string username, int contentPageID) {
CommentInfo comment = null;
SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
SqlCommand cmdGet = new SqlCommand("Community_CommentsGetComment", conPortal);
cmdGet.CommandType = CommandType.StoredProcedure;
// Add Parameters
cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmdGet.Parameters.Add("@username", username);
cmdGet.Parameters.Add("@contentPageID", contentPageID);
// Get Comment from DB
conPortal.Open();
SqlDataReader dr = cmdGet.ExecuteReader();
if (dr.Read())
comment = new CommentInfo(dr);
conPortal.Close();
return (ContentInfo)comment;
}
//*********************************************************************
//
// GetComments Method
//
// Retrieves a list of comments from the database.
//
//*********************************************************************
public static CommentCollection GetComments(string username, int contentPageID, int orderBy) {
SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
SqlCommand cmdGet = new SqlCommand("Community_CommentsGetComments", conPortal);
cmdGet.CommandType = CommandType.StoredProcedure;
// Add Parameters
cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmdGet.Parameters.Add("@username", username);
cmdGet.Parameters.Add("@contentPageID", contentPageID);
cmdGet.Parameters.Add("@orderBy", orderBy);
CommentCollection colComments = new CommentCollection();
conPortal.Open();
SqlDataReader dr = cmdGet.ExecuteReader();
while (dr.Read())
colComments.Add(new CommentInfo(dr));
conPortal.Close();
return colComments;
}
}
}
Hi all again, I analyzed the same SP pointing to other communities, but I was sorprised about execution time because the differences. Examples: Community 1: Execution Time: 0:00:02 Rows 20 Community 2: Execution Time: 0:00:24 Rows 0 Problematic Community: Execution
Time: 0:03:36 (first analysis) Execution Time: 0:02:08 (second analysis) Execution Time: 0:01:35 (third analysis) Is this normal? Thanks.
euroiranian
Member
375 Points
75 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 08:30 AM|LINK
para7
Participant
1925 Points
385 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 10:43 AM|LINK
euroiranian
Member
375 Points
75 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 02:30 PM|LINK
suprjack
Member
10 Points
2 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 05:50 PM|LINK
euroiranian
Member
375 Points
75 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 08:25 PM|LINK
<httpRuntime executionTimeout="9000" maxRequestLength="4096" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="100" enableVersionHeader="true" /> <processModel enable="true" timeout="Infinite" idleTimeout="Infinite" shutdownTimeout="Infinite" requestLimit="Infinite" requestQueueLimit="5000" restartQueueLimit="10" memoryLimit="60" webGarden="false" cpuMask="0xffffffff" userName="machine" password="AutoGenerate" logLevel="Errors" clientConnectedCheck="0:00:05" comAuthenticationLevel="Connect" comImpersonationLevel="Impersonate" responseDeadlockInterval="00:03:00" maxWorkerThreads="20" maxIoThreads="20" />and restarted de IIS after the changes, but nothing changed. Other idea?mumfie2003
Participant
1198 Points
242 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 08:56 PM|LINK
http://www.colin-munford.me.uk
para7
Participant
1925 Points
385 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 08:37 AM|LINK
euroiranian
Member
375 Points
75 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 09:10 AM|LINK
euroiranian
Member
375 Points
75 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 09:26 AM|LINK
namespace ASPNET.StarterKit.Communities { using System; using System.Data; using System.Data.SqlClient; using System.Collections; //********************************************************************* // // CommentUtility Class // // Contains static utility methods used by the Comments module. // //********************************************************************* public class CommentUtility { //********************************************************************* // // AddComment Method // // Adds a new comment to the database. // //********************************************************************* public static int AddComment ( int contentPageID, ModerationStatus moderationStatus, string username, string title, string body ) { SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString); SqlCommand cmdAdd = new SqlCommand("Community_CommentsAddComment", conPortal); cmdAdd.CommandType = CommandType.StoredProcedure; // Add Parameters cmdAdd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue; cmdAdd.Parameters.Add("@communityID", CommunityGlobals.CommunityID); cmdAdd.Parameters.Add("@contentPageID", contentPageID); cmdAdd.Parameters.Add("@moderationStatus", moderationStatus); cmdAdd.Parameters.Add("@username", username); cmdAdd.Parameters.Add("@title", title); cmdAdd.Parameters.Add("@metaDescription", ContentPageUtility.CalculateMetaDescription(body)); cmdAdd.Parameters.Add("@metaKeys", ContentPageUtility.CalculateMetaKeys(body)); cmdAdd.Parameters.Add("@body", SqlDbType.NText); cmdAdd.Parameters[ "@body" ].Value = body; conPortal.Open(); cmdAdd.ExecuteNonQuery(); int result = (int)cmdAdd.Parameters["@RETURN_VALUE"].Value; conPortal.Close(); return result; } //********************************************************************* // // GetComment Method // // Gets a particular comment from the database. // //********************************************************************* public static ContentInfo GetComment(string username, int contentPageID) { CommentInfo comment = null; SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString); SqlCommand cmdGet = new SqlCommand("Community_CommentsGetComment", conPortal); cmdGet.CommandType = CommandType.StoredProcedure; // Add Parameters cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID); cmdGet.Parameters.Add("@username", username); cmdGet.Parameters.Add("@contentPageID", contentPageID); // Get Comment from DB conPortal.Open(); SqlDataReader dr = cmdGet.ExecuteReader(); if (dr.Read()) comment = new CommentInfo(dr); conPortal.Close(); return (ContentInfo)comment; } //********************************************************************* // // GetComments Method // // Retrieves a list of comments from the database. // //********************************************************************* public static CommentCollection GetComments(string username, int contentPageID, int orderBy) { SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString); SqlCommand cmdGet = new SqlCommand("Community_CommentsGetComments", conPortal); cmdGet.CommandType = CommandType.StoredProcedure; // Add Parameters cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID); cmdGet.Parameters.Add("@username", username); cmdGet.Parameters.Add("@contentPageID", contentPageID); cmdGet.Parameters.Add("@orderBy", orderBy); CommentCollection colComments = new CommentCollection(); conPortal.Open(); SqlDataReader dr = cmdGet.ExecuteReader(); while (dr.Read()) colComments.Add(new CommentInfo(dr)); conPortal.Close(); return colComments; } } }Thanks a lot.euroiranian
Member
375 Points
75 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 11:42 AM|LINK