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.




Timeouts bringing up "summary" page for biggest project

admin
web-app

When bringing up our biggest project we are getting timeouts. Other project are working just fine.

[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.] CounterSoft.Gemini.DataProvider.xd40904422a043a04.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) +536 CounterSoft.Gemini.Business.xa37334733da24461.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) +18 CounterSoft.Gemini.Presenter.ProjectPresenter.GetProjectSummary(Int32 projectID, UserEN user) +11 CounterSoft.Gemini.Web.Project.Controls.ProjectSummaryTab.Page_Load(Object sender, EventArgs e) +119 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

This project has 20,000 of our 28,000 issues.

User53167
· 1
User53167
Replies (2)
helpful
0
not helpful
ANSWER

Does it only happen on the summary page for that project or the items as well? What is your database size and increments?

Try running: update statistics gemini_issues with fullscan


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

updating statistics fixed the issue.


User53167
· 1
User53167