Hi all, I've a articles section with 4500 articles. When I try to read the complete article, I get the next error: Server Error in '/International' Application. -------------------------------------------------------------------------------- Timeout expired.
The timeout period elapsed prior to completion of the operation or the server is not responding. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error
and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source Error: An unhandled exception was generated
during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException: Timeout expired. The timeout period elapsed prior to completion
of the operation or the server is not responding.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 System.Data.SqlClient.SqlCommand.ExecuteReader() +41 ASPNET.StarterKit.Communities.CommentUtility.GetComments(String
username, Int32 contentPageID, Int32 orderBy) +369 ASPNET.StarterKit.Communities.Comments.BindComments() +76 ASPNET.StarterKit.Communities.Comments.OnLoad(EventArgs e) +404 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.AddedControl(Control control, Int32 index) +306 System.Web.UI.ControlCollection.Add(Control child) +153 ASPNET.StarterKit.Communities.SkinnedCommunityControl.CreateChildControls() +32 System.Web.UI.Control.EnsureChildControls() +100 System.Web.UI.Control.PreRenderRecursiveInternal()
+38 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Page.ProcessRequestMain()
+1476 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 My Web.Config file is: <forms loginUrl="Users_Login.aspx" timeout="60" />
I hope some help. Thanks you all in advance.
I'm not at .net pro, but I know some tricks. Have had many unexpected spooky errors in the last year with gcn. Timeout use to come when a page takes too long to load because of some error. You say "When I try to read the complete article, I get the next error".
So I presume you are able to view a list of articles, but when you open ANY article something stucks. Have you tried to create a new article and see if that loads? What about on localhost, same thing wrong here? If not or anyway. Try to upload (overwrite)
Global.asax from the root to restart the gcn application. 4500 articles is a lot. What's the size of your database? Can you create an article in another new created community? Hope this helps :)
Hi Para, At least you know something, thanks for your help. Yes, you're right, I can see the list of articles, and when I try to open any of the articles in that community (I have four) then I get the error. The problem in the whole community, not only in the
section holding the 4500 articles, also in other sections inside this community, one of them with only two articles. But not in the other communities with only a few articles. About create new articles, or localhost. I've tried all, but not solution. About
overwrite the gobal.asax, I don't know how to do that. I presume that I must delete the file and create it again from zero. Am I right? The size of my Db is 200Mb allocated (85Mb in use) and the transaction log space is 275 allocated (125 used) Hope you can
guide me a little bit more, thanks. Tomas.
Edited by Haidar_Bilal - Please place your code within the < code > and
< /code > tag. Thank you.
Hi again, I've chacked my Global.asax file and it's too empty, it only have a line of code, there is also other Global files. The global.asax is as follows: My Global.asax.cs is:
using System; using System.Collections; using System.ComponentModel; using System.Web; using System.Web.SessionState; using ASPNET.StarterKit.Communities.Services; namespace ASPNET.StarterKit.Communities { //*********************************************************************
// // Global Class // // The Global.asax is used to setup the timer for service subscriptions. // //********************************************************************* public class Global : System.Web.HttpApplication { public Global() { InitializeComponent();
} //********************************************************************* // // CreateTimers Method // // The timer fires every 15 minutes (60000 * 15). // //********************************************************************* private void CreateTimers()
{ if (CommunityGlobals.EnableServiceTimer) { System.Timers.Timer WebServiceTimer = new System.Timers.Timer(); WebServiceTimer.Enabled = true; WebServiceTimer.Interval = (60000 * 15); WebServiceTimer.Elapsed += new System.Timers.ElapsedEventHandler(WebServiceTimer_Elapsed);
} } //********************************************************************* // // WebServiceTimer_Elapsed Method // // Every 15 minutes, check for new content from remote communities. // //*********************************************************************
protected void WebServiceTimer_Elapsed(object sender, System.Timers.ElapsedEventArgs e) { ServiceUtility.GetRemoteContent(); } //********************************************************************* // // Application_Start Method // // Create two timers for
sending emails and polling Web services. // //********************************************************************* protected void Application_Start(Object sender, EventArgs e) { CreateTimers(); } protected void Session_Start(Object sender, EventArgs e) {
} protected void Application_BeginRequest(Object sender, EventArgs e) { } protected void Application_EndRequest(Object sender, EventArgs e) { } protected void Application_AuthenticateRequest(Object sender, EventArgs e) { } protected void Application_Error(Object
sender, EventArgs e) { } protected void Session_End(Object sender, EventArgs e) { } protected void Application_End(Object sender, EventArgs e) { } #region Web Form Designer generated code /// /// Required method for Designer support - do not modify /// the
contents of this method with the code editor. /// private void InitializeComponent() { } #endregion } } Also I have a Global.asax.resx file: text/microsoft-resx 1.0.0.0 System.Resources.ResXResourceReader, System.Windows.Forms, Version=1.0.3102.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 System.Resources.ResXResourceWriter, System.Windows.Forms, Version=1.0.3102.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
I don't know what to do. I'm desperate with this problem, please some help. Tomas.
Hi again Tomas About overwrite the gobal.asax, just upload it from the local gcn to overwride the one on remote. This helped me many times when things f..... up. So try that as the first thing. Second you could try to run the local gcn again to do some tests.
Don't understand from what your'e telling if you have the same problem here with this community or you don't have an recently database here restored from the one remote? Anyway you could try and set the local gcn to connect to the remote (Web.config connection
string) and see if it's the same problem. Try also to compile/debug the local gcn. Then your'e sure it's the problem in the remote database and not some file or compilation. Last thing I could think of is trying to create a new Articles Section in the problem-community.
Maybe that will work? Last of all maybe create a new community and copy-paste from the old. But 4500 articles is a LOT. I have myself submitted sections as a Web service into other communities, and when I edit an article it becomes this communitie's "property",
and then "cut the connection" again. An idea: Maybe it is just one article of the 4500 that messes things up.
Also try and upload a freshly compiled ASPNET.StarterKit.Communities.dll, ofcause I would download the one remote to have a backup. I have learned you cannot have a backup of the dll lying in the same folder, the bin folder. The gobal.asax has not much in it
but it restarts the gcn. OK, it may be an idea to delete it remotely and refresh the community in the browser before uploading it from local.
Hi Para, I Updated the Global.asax and the ASPNET.StarterKit.Communities.dll, but nothing changes. The problem persists. In the other hand, I exported the Db to other machine and tried from there, but doesn't work for this community too. Simplifying, no matter
what SQL server I use, the problem remain as is. My server is a machine running Win 2003 server with SQL 2000 SP3, DNS, IIS 6.0 with .NET Framework 1.1 ver. 1927. The problematic community use a subdomain URL (int.mydomain.com/application). When I try to open
other articles in other communities (xxx.mydomain.com/application) it works fine, but when I try to open any article in this community (in this section or in any other article's section inside this community) doesn't work. About your last idea, the 4500 articles
consist in a Title with less than 142 characteres, a Intro Text with "Terminology & Lexicon + the Title" and a Extended text with the meaning of the Title inside HTML tags. Bellow an example:
Title: UNESCO Convention on the Means of Prohibiting and Preventing the Illicit Import, Export and Transfer of Ownership of Cultural Property of 1970 Intro Text: Terminology & Lexicon: UNESCO Convention on the Means of Prohibiting and Preventing the Illicit
Import, Export and Transfer of Ownership of Cultural Property of 1970 Extended Text:
UNESCO Convention on the Means of Prohibiting and Preventing the Illicit Import, Export and Transfer of Ownership of Cultural Property of 1970:
In 1970 the United Nations organization UNESCO took on the challenge to counter the pilfering of architectural complexes, destruction of ancient sites, and international trade in stolen cultural properties. UNESCO issued a "convention" (an international agreement
to which a number of nations are contractual parties) called the "UNESCO Convention on the Means of Prohibiting and Preventing the Illicit Import, Export and Transfer of Ownership of Cultural Property." Its concern: "the measures to be adopted to forbid and
prevent the importation and the transfer of the illicit property of cultural goods." . Also see antiquity and museum.
I don't think that the messes comes from one of the articles, I think that the problem really comes from the timeout period asigned by the Db or the .NET Framework. Probably the needed time to proccess this amount of data must be a little bit higher
than the standard (if I don't missunderstood it is 30 seconds). Now maybe you know, or someone else, how to increase the timeout period ?. About this point, notice that my server is a poor celeron 466 with only 160 MB RAM. Also note that I already added the
line in my Web.Config file but nothing happens. I hope with this information we can find a solution. Thanks. Tomas
Hi again It is a lot of articles, but they are small. I think too, that it is the thousands of articles that is hard to handle and it times out. The same thing has happened at my pretty slow SQL server at webhost4life.com from over this side of the Atlantic.
But I will still say; you MUST try running the whole thing including database on your local machine. If I do that everything is as quick as the blink of an eye - on remote I sometimes have to wait and things time out - that's MY only real problem with the
gcn now. On the remote side, if no problem on local, I would make a backup of the db. Then try and delete all articles except a few in the problem-community and see if that "solves" the problem. Then maybe divide articles by putting some or all of them into
another community and fetch them from there. Else let's hope for some of the "big shots" like Star Pilot or Redd to look by one of theese days. This forum seems quite abandoned theese months, hope people return again. BTW: How and when did the problem start?
Did it happen sudden or gradual. If it is because of too many posts it might have gotten worse and worse until suddently the "limit" was reached.
Hi Para, Thanks a lot for your cooperation in this matter. I monitorized my server and I noticed that the CPU works at 100% when I request one of the articles of the problematic community. Maybe the problem cames from my machine, and not from the amount of
data. I hope so... because this articles are a very small part of my site. I want insert up to 20.000 registries in my database between articles, books & disscuses + up to 10.000 pics, only to begin. Currently I've sent the database to my ISP to see what happens
working with several BIG machines. About your recomendation to try localhost, I tried it, but it can be tested right until I run subdomains in the IIS and I'm not sure how to do that. One thing more, when I try to operate from the machine where is hosted the
application & database (by mydomain.com, not localhost) I have the same problem. Anyway, I will wait until my ISP updated the db in their server to see what happens and I will inform you. Thanks Para, I hope too that the "big shots" came back to these forums
soon, then everything will be easier.... and pleasant. Tomas.
OH sorry, I forgot answer your last question!!! The problem came sudden when I updated the section in question. I inserted the articles from other machine in the server (both in the LAN) using a Macro and the "Articles_AddArticle.aspx" form. Everything worked
right until the amount of articles grow up to +/-2000, then this section stops showing the articles in full, but I'm allowed to add new articles, edit any one of them, delete, move, change the order... etc, only I cannot see any article in full (Read More...),
or in other words, to open the pages "http://int.mydomain.com/application/sectionName/xxxxx.aspx" Note that the problem is not only for this section, any section inside this community is having the same problem, but only in this community. The other communities
are working right (note that the other communities are not empty, only a few articles).
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; } } }
Thanks a lot.
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.
Hi again euroiranian You mean you tried to turn off the comments in Advanced. Still hoping for some discovery at localhost. Good luck :) I don't know much about SP, so that I can't help much with.
Hello! Ok, I'm no expert on these matters. In fact I might be WAAAY off. But what about adding "Connection Timeout=XX" to your connection string? I dunno much about the web.config yet, so give me some slack if I'm way off.
Heres an example of setting the command timeout. 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; //CM default is 30 seconds, increase to 300 seconds for test cmdGet.CommandTimeout=300; // Add Parameters cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID); cmdGet.Parameters.Add("@username",
username); cmdGet.Parameters.Add("@contentPageID", contentPageID); cmdGet.Parameters.Add("@orderBy", orderBy);
BTW I did a simple test with 5000 articles and get exactly the same error as you encountered.
Hi all, I changed the timeout commnad settings as suggested, but the problem still there. How if we study the db and the SPs? probably the problem comes from there, no? Someone told me about relationchips and the possibility of an error in there. Something
like a circular relationship or similars. Have someone study this point? Looking forward. Thanks again.
Hi Para, Yes I tried with Localhost, but IE can't find the page. Instead I tried by MyMACHINENAME in Local and Remote computers and the error is a little bit different.
Server Error in '/International' Application. -------------------------------------------------------------------------------- General network error. Check your network documentation. Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation. Source Error: An
unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException: General network error. Check
your network documentation.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 System.Data.SqlClient.SqlCommand.ExecuteReader() +41 ASPNET.StarterKit.Communities.CommentUtility.GetComments(String
username, Int32 contentPageID, Int32 orderBy) +369 ASPNET.StarterKit.Communities.Comments.BindComments() +76 ASPNET.StarterKit.Communities.Comments.OnLoad(EventArgs e) +411 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.AddedControl(Control control, Int32 index) +307 System.Web.UI.ControlCollection.Add(Control child) +153 ASPNET.StarterKit.Communities.SkinnedCommunityControl.CreateChildControls() +32 System.Web.UI.Control.EnsureChildControls() +100 System.Web.UI.Control.PreRenderRecursiveInternal()
+38 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Page.ProcessRequestMain()
+1489 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Hi Para, O.K. If new ideas, please tell me. Currently I'm studying the db. I think the problem comes from here, but I don't have much idea. If anyone knows or discover something I would appreciate any help. I'm really novice in all these matters. Thanks.
Hi mumfie2003, Did you work on this problem? Do you have news about? I'm really desperate. BTW I love your Random photos web-box. I will add it to my website too. Very usable for me. Thanks.
I did change "Community_CommentsGetComments" to use dbo.Community_GetContentItemByContentPageID(@communityID, @userID, @currentDate, @contentPageID) Content Seems to be a lot faster however the comments no longer display and there might be other issues.
Thanks mumfie2003, But that is not the solution for me. I need the comments fully available. If you find any solution, please tell me. I will do so. Thanks.
euroiranian I have done a preliminary mod to dbo.Community_CommentsGetComments to overcome this problem. You might wish to install it locally to see if it overcomes your problem. You can download the mod from http://www.colin-munford.me.uk/community/Programming/Downloads/Default.aspx
Please note this is a preliminary version and has not been fully tested so please report any issues you encounter.
Hi mumfie2003, First al all thanks for your effor. I donwloaded the fix, but I don't know how to install it (Remember I'm a beginner in these matters). Can you detail how to install? If I don't misunderstand, First I must create a new Function (in User Defined
Fuctions) with the first part of your code (from Ln1, Col 1 to Ln 113, Col3) and then modify the existent SP "Community_CommentsGetComments" with the rest of your code (from Ln 116, Col1 to Ln 166, Col 3). Am I right? Thanks.
Hi again, Thanks, thanks and thanks. Really helpfull your mod. I'm euphoric. I've installed your mod following my own instructions and at the moment I can see the articles in full without problem, but I noticed that moderation have the same problem (after and
before your fix). Thanks again, really I can't believe it's working. I will inform you immediately about any eventuality.
Hi Mumfie2003, I didn't heard from you for two days now and I want to know if you (or someone else) have done something about the two errors I reported (search engine and moderation). Thanks. Also I'm having some problem to install your Random photos Webbox
Mod. I've installed it following your instalation instructions, but probably I'm missing something. 1.- I created a .acsx file at \Communities\Common\WebBoxes\CM_Random Photos.ascx (copy/pasted from your Website) 2.- I created a SP with your file CM_Community_PhotoGalleryGetRandomPhotos.sql
3.- I intregrated the code of PhotoUtility.cs.txt at the end of my PhotoUtility.cs file at \Engine\Modules\PhotoGallery\Components (Note that the path you supplied is a little bit diferent). 4.- I added it between the webboxes to display (admin section). Note
that I get a blank small box on the page, but none imagen or text init. What I'm doing wrong? Thanking again your efforts. Tomas.
Hi euroiranian, I did post a beta version of fix for the "Moderate" option at http://www.colin-munford.me.uk/community/Programming/Downloads/Downloads_GetFile.aspx?id=595 I am not sure if it is possible to resolve the search issue without significant database
changes. There are several limitations of the current search method anyway http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=532330 Not sure why your random photos are not working. Did you rebuild the DLL ?
Hi Mumfie2003, Thanks again for your fixes. I will install it later and report you if needed. About Search, that was a bad new. Think how complicate can be find a page in a large site (up to 20.000 pages between 4 communities) for users (most of them inexperts
users). But what can I do? Anyway your fixes are excelent and I thank you a lot for them. If you find a solution let me know. The other issue is the Random Photos. I didn't touch the DLL. Can be there any other reason? Tomas.
Hi euroiranian, With the search problem I suggest you post a seperate message on the CSK and GCN forums as it is possible a fix is available or a SQL expert could look at the SP Community_SearchGetSearchResults to find a solution to cater for a large number
of content pages in a community/section. With the random webbox problem you need to recompile the project "CSKDotNet.csproj" using Visual Studio.net to rebuild the dll "ASPNET.StarterKit.Communities.dll". You should then be able to test it locally then deploy
the DLL etc to you server. HTH
Hi Mumfie2003, Thanks a lot for your help. I installed your fixes and, at the moment, are working right. If any issue with them, I will inform you immediately. As you suggested, I posted separate messages to both forums, CSK & GCN but not answer at the moment.
I will wait, but allow me to considerer you more than an expert in SQL. You solved a big dilemma for me and I learned a lot from your fixes. Many experts are not able to learn nothing. I really appreciate what you did for me and all of us must give you a grade
of excellent. About Random Webbox, I'm to novice to do that. I think I must forget this option at the moment. Someday...!!! Once more thank you and you have my most high grade as SQL expert. I know, I don't know nothing about SQL, but .... Thomas
The premise of this MOD is to address the poor performance of the Search feature of the CSK. This is a drop-in replacement for the Community_GetSearchResults SQL stored procedure. One additional file is required that creates a function that actually performs
the search. See ReadMe file for fine tuning. http://wbcb.com/TechTips/Downloads/2720.aspx see related performance article here: http://wbcb.com/TechTips/CSK+Articles/2717.aspx
Hi Jody, Thanks for your fix. I installed it and is working wonderfully (still in test. If any issue, I will report) With your and Mumfie's help my communities are working right and the response times are much better than before. Again thanks to all this community
and very very especially to both of you. Jody's fix source: http://wbcb.com/TechTips/Downloads/2720.aspx Mumfie fix source: http://www.colin-munford.me.uk/community/Programming/Downloads/Default.aspx Thomas. BTW I tested in GCN and Jody's fix works.
None
0 Points
67 Posts
URGENT. Timeout Expired. Error.
Sep 16, 2004 02:04 AM|euroiranian|LINK
None
0 Points
377 Posts
Re: URGENT. Timeout Expired. Error.
Sep 17, 2004 04:50 AM|para7|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 17, 2004 09:49 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 17, 2004 11:02 AM|euroiranian|LINK
Edited by Haidar_Bilal - Please place your code within the < code > and < /code > tag. Thank you.
Hi again, I've chacked my Global.asax file and it's too empty, it only have a line of code, there is also other Global files. The global.asax is as follows: My Global.asax.cs is:
using System; using System.Collections; using System.ComponentModel; using System.Web; using System.Web.SessionState; using ASPNET.StarterKit.Communities.Services; namespace ASPNET.StarterKit.Communities { //********************************************************************* // // Global Class // // The Global.asax is used to setup the timer for service subscriptions. // //********************************************************************* public class Global : System.Web.HttpApplication { public Global() { InitializeComponent(); } //********************************************************************* // // CreateTimers Method // // The timer fires every 15 minutes (60000 * 15). // //********************************************************************* private void CreateTimers() { if (CommunityGlobals.EnableServiceTimer) { System.Timers.Timer WebServiceTimer = new System.Timers.Timer(); WebServiceTimer.Enabled = true; WebServiceTimer.Interval = (60000 * 15); WebServiceTimer.Elapsed += new System.Timers.ElapsedEventHandler(WebServiceTimer_Elapsed); } } //********************************************************************* // // WebServiceTimer_Elapsed Method // // Every 15 minutes, check for new content from remote communities. // //********************************************************************* protected void WebServiceTimer_Elapsed(object sender, System.Timers.ElapsedEventArgs e) { ServiceUtility.GetRemoteContent(); } //********************************************************************* // // Application_Start Method // // Create two timers for sending emails and polling Web services. // //********************************************************************* protected void Application_Start(Object sender, EventArgs e) { CreateTimers(); } protected void Session_Start(Object sender, EventArgs e) { } protected void Application_BeginRequest(Object sender, EventArgs e) { } protected void Application_EndRequest(Object sender, EventArgs e) { } protected void Application_AuthenticateRequest(Object sender, EventArgs e) { } protected void Application_Error(Object sender, EventArgs e) { } protected void Session_End(Object sender, EventArgs e) { } protected void Application_End(Object sender, EventArgs e) { } #region Web Form Designer generated code /// /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InitializeComponent() { } #endregion } } Also I have a Global.asax.resx file: text/microsoft-resx 1.0.0.0 System.Resources.ResXResourceReader, System.Windows.Forms, Version=1.0.3102.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Resources.ResXResourceWriter, System.Windows.Forms, Version=1.0.3102.0, Culture=neutral, PublicKeyToken=b77a5c561934e089I don't know what to do. I'm desperate with this problem, please some help. Tomas.None
0 Points
377 Posts
Re: URGENT. Timeout Expired. Error.
Sep 17, 2004 11:19 AM|para7|LINK
None
0 Points
377 Posts
Re: URGENT. Timeout Expired. Error.
Sep 17, 2004 11:26 AM|para7|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 17, 2004 12:52 PM|euroiranian|LINK
Title: UNESCO Convention on the Means of Prohibiting and Preventing the Illicit Import, Export and Transfer of Ownership of Cultural Property of 1970 Intro Text: Terminology & Lexicon: UNESCO Convention on the Means of Prohibiting and Preventing the Illicit Import, Export and Transfer of Ownership of Cultural Property of 1970 Extended Text:
UNESCO Convention on the Means of Prohibiting and Preventing the Illicit Import, Export and Transfer of Ownership of Cultural Property of 1970:
In 1970 the United Nations organization UNESCO took on the challenge to counter the pilfering of architectural complexes, destruction of ancient sites, and international trade in stolen cultural properties. UNESCO issued a "convention" (an international agreement
to which a number of nations are contractual parties) called the "UNESCO Convention on the Means of Prohibiting and Preventing the Illicit Import, Export and Transfer of Ownership of Cultural Property." Its concern: "the measures to be adopted to forbid and
prevent the importation and the transfer of the illicit property of cultural goods." . Also see antiquity and museum.
I don't think that the messes comes from one of the articles, I think that the problem really comes from the timeout period asigned by the Db or the .NET Framework. Probably the needed time to proccess this amount of data must be a little bit higher than the standard (if I don't missunderstood it is 30 seconds). Now maybe you know, or someone else, how to increase the timeout period ?. About this point, notice that my server is a poor celeron 466 with only 160 MB RAM. Also note that I already added the line in my Web.Config file but nothing happens. I hope with this information we can find a solution. Thanks. TomasNone
0 Points
377 Posts
Re: URGENT. Timeout Expired. Error.
Sep 18, 2004 04:22 AM|para7|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 18, 2004 06:49 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 18, 2004 10:00 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 04:30 AM|euroiranian|LINK
None
0 Points
377 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 06:43 AM|para7|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 10:30 AM|euroiranian|LINK
None
0 Points
2 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 01:50 PM|suprjack|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 04:25 PM|euroiranian|LINK
and restarted de IIS after the changes, but nothing changed. Other idea?None
0 Points
241 Posts
Re: URGENT. Timeout Expired. Error.
Sep 19, 2004 04:56 PM|mumfie2003|LINK
http://www.colin-munford.me.uk
None
0 Points
377 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 04:37 AM|para7|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 05:10 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 05:26 AM|euroiranian|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.None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 07:42 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 11:11 AM|euroiranian|LINK
None
0 Points
377 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 11:34 AM|para7|LINK
None
0 Points
131 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 01:27 PM|twisterjosh|LINK
None
0 Points
241 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 02:25 PM|mumfie2003|LINK
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; //CM default is 30 seconds, increase to 300 seconds for test cmdGet.CommandTimeout=300; // Add Parameters cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID); cmdGet.Parameters.Add("@username", username); cmdGet.Parameters.Add("@contentPageID", contentPageID); cmdGet.Parameters.Add("@orderBy", orderBy);BTW I did a simple test with 5000 articles and get exactly the same error as you encountered.http://www.colin-munford.me.uk
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 03:10 PM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 20, 2004 03:50 PM|euroiranian|LINK
Server Error in '/International' Application. -------------------------------------------------------------------------------- General network error. Check your network documentation. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException: General network error. Check your network documentation.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723 System.Data.SqlClient.SqlCommand.ExecuteReader() +41 ASPNET.StarterKit.Communities.CommentUtility.GetComments(String username, Int32 contentPageID, Int32 orderBy) +369 ASPNET.StarterKit.Communities.Comments.BindComments() +76 ASPNET.StarterKit.Communities.Comments.OnLoad(EventArgs e) +411 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Control.AddedControl(Control control, Int32 index) +307 System.Web.UI.ControlCollection.Add(Control child) +153 ASPNET.StarterKit.Communities.SkinnedCommunityControl.CreateChildControls() +32 System.Web.UI.Control.EnsureChildControls() +100 System.Web.UI.Control.PreRenderRecursiveInternal() +38 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Page.ProcessRequestMain() +1489 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573None
0 Points
377 Posts
Re: URGENT. Timeout Expired. Error.
Sep 21, 2004 03:07 AM|para7|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 21, 2004 04:49 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 22, 2004 10:15 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 22, 2004 10:46 AM|euroiranian|LINK
None
0 Points
241 Posts
Re: URGENT. Timeout Expired. Error.
Sep 22, 2004 02:40 PM|mumfie2003|LINK
http://www.colin-munford.me.uk
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 22, 2004 03:14 PM|euroiranian|LINK
None
0 Points
241 Posts
Re: URGENT. Timeout Expired. Error.
Sep 22, 2004 07:17 PM|mumfie2003|LINK
http://www.colin-munford.me.uk
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 23, 2004 02:34 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 23, 2004 03:04 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 23, 2004 05:23 AM|euroiranian|LINK
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 24, 2004 06:17 AM|euroiranian|LINK
None
0 Points
241 Posts
Re: URGENT. Timeout Expired. Error.
Sep 24, 2004 02:26 PM|mumfie2003|LINK
http://www.colin-munford.me.uk
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 25, 2004 03:40 AM|euroiranian|LINK
None
0 Points
241 Posts
Re: URGENT. Timeout Expired. Error.
Sep 25, 2004 05:32 AM|mumfie2003|LINK
http://www.colin-munford.me.uk
None
0 Points
67 Posts
Re: URGENT. Timeout Expired. Error.
Sep 26, 2004 07:48 AM|euroiranian|LINK
Member
291 Points
944 Posts
This may fix your timeout: Search MOD
Sep 27, 2004 10:05 PM|jodywbcb|LINK
My Blogs on .Net 2.0 and Ajax
http://csk.wbcb.com
http://ArtbyJody.com
None
0 Points
67 Posts
Re: This may fix your timeout: Search MOD
Sep 29, 2004 05:39 AM|euroiranian|LINK