Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Timeout expired when accessing project summary page

web-app

Hi,

We started getting errors today when accessing the project summary page for some of our larger projects.  The error below appears in the system log when this happens.  It's happening for two of our projects (out of 52).  I think these two are some of our larger projects, but I'm not absolutely sure of that.  Is there a way I can get more diagnostic information to troubleshoot what is timing out exactly and resolve this?  Has anyone else run into this?

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at CounterSoft.Gemini.DataProvider.xd40904422a043a04.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Business.xa37334733da24461.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Presenter.ProjectPresenter.GetProjectSummary(Int32 projectID, UserEN user) at CounterSoft.Gemini.Web.Project.ProjectHome.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

pierre.boudreau
· 1
pierre.boudreau
Replies (4)
helpful
0
not helpful

Also, for one of the two projects that are getting this error, it doesn't happen every time.  I have been able to successfully view the project summary page for one of them a few times out of many tries so it seems like it is just on the edge of going over the timeout limit.


pierre.boudreau
· 1
pierre.boudreau
helpful
1
not helpful
ANSWER

What is the size of your database and what are the inrement settings?

It might be that the data is fragmented, try running the fullowing SQL:

update statistics gemini_issues with fullscan


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thanks, that's exactly what I needed.


lthompson
· 1
lthompson
helpful
0
not helpful

Please make sure that your database increment settings are not set too low (eg 10%).


Saar Cohen
· 5000
Saar Cohen