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 error accessing one Project

admin

Getting a timeout error whilst accessing one of our projects - all others work fine. We can open items without error using the "items" link, but if I go to the projects page and select this one particular project I get a timeout error, and the following in the server application log (server and user name changed):-

Log Name: Application Source: ASP.NET 2.0.50727.0 Date: 26/09/2011 10:13:10 Event ID: 1309 Task Category: Web Event Level: Warning Keywords: Classic User: N/A Computer: xxxxx.mgm.local Description: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 26/09/2011 10:13:10 Event time (UTC): 26/09/2011 09:13:10 Event ID: b9e399404f4946edb90ca10a4196544c Event sequence: 18652 Event occurrence: 5 Event detail code: 0

Application information: Application domain: /LM/W3SVC/1/ROOT/Gemini-1-129614993876562500 Trust level: Full Application Virtual Path: /Gemini Application Path: C:\Program Files (x86)\Countersoft\Countersoft Gemini\Gemini Web Application\ Machine name: xxxxx

Process information: Process ID: 1840 Process name: w3wp.exe Account name: IIS APPPOOL\DefaultAppPool

Exception information: Exception type: SqlException Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Request information: Request URL: http://mgmservicedesk/Gemini/project/Project.aspx?PROJID=47 Request path: /Gemini/project/Project.aspx User host address: 2002:8001:3c32::8001:3c32 User: mgm\martin.gibbs Is authenticated: True Authentication Type: Forms Thread account name: IIS APPPOOL\DefaultAppPool

Thread information: Thread ID: 13 Thread account name: IIS APPPOOL\DefaultAppPool Is impersonating: False Stack trace: 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.Controls.ProjectSummaryTab.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.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

Event Xml: 1309 3 3 0x80000000000000 7581543 Application xxxxx.mgm.local 3005 An unhandled exception has occurred. 26/09/2011 10:13:10 26/09/2011 09:13:10 b9e399404f4946edb90ca10a4196544c 18652 5 0 /LM/W3SVC/1/ROOT/Gemini-1-129614993876562500 Full /Gemini C:\Program Files (x86)\Countersoft\Countersoft Gemini\Gemini Web Application\ xxxxx 1840 w3wp.exe IIS APPPOOL\DefaultAppPool SqlException Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. http://mgmservicedesk/Gemini/project/Project.aspx?PROJID=47 /Gemini/project/Project.aspx 2002:8001:3c32::8001:3c32 mgm\joe.bloggs True Forms IIS APPPOOL\DefaultAppPool 13 IIS APPPOOL\DefaultAppPool False 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.Controls.ProjectSummaryTab.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.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

User52195
· 1
User52195
Replies (2)
helpful
0
not helpful

It might be due to data fragmentation. What is your database size and increments? Try running the following SQL to solve the issue:

update statistics gemini_issues with fullscan

Mark Wing
· 9108
Mark Wing
helpful
0
not helpful
ANSWER

Thank you

"update statistics gemini_issues with fullscan"

seems to have fixed it.


User52195
· 1
User52195