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.




Time-out error

web-app

When attempting to access a project with many issues (thousands), I get this error message:

body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

Server Error in '/' 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 (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) +559
   CounterSoft.Gemini.Business.xa37334733da24461.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) +18
   CounterSoft.Gemini.Presenter.ProjectPresenter.GetProjectSummary(Int32 projectID, UserEN user) +11
   CounterSoft.Gemini.Web.Project.ProjectHome.SelectTab() +43
   CounterSoft.Gemini.Web.Project.ProjectHome.Page_Load(Object sender, EventArgs e) +1124
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

It started happening after I played around with the Field Visibility Schemes. These have all been deleted again and the error still comes up.

I have tried a session logging on the SQL server and have tried to manually execute all the SQL statements I logged, and they all perform without a problem on in Management Studio Express on the server (no time-out).

Can anyone see from the trace-back where the problem is, and perhaps how to fix it?
HeartWare
· 1 		HeartWare
Wednesday, September 10, 2008, 3:15:07 PM
Replies (2)
helpful
0
not helpful

Is it possible to send us a zipped backup of your database?

Try adding the following to the nhibernate section of the web.config file:

<add key="hibernate.command_timeout" value="0"/>


Mark Wing
· 9108 		Mark Wing
Wednesday, September 10, 2008, 3:43:56 PM
helpful
0
not helpful

No change. Still times out after apprx. 32 seconds (so the time-out is probably 30 seconds).

We are also having a lot of other problems with the database (issues that are visible by one user but not another and we can't figure out why).

The database was updated from a v1.x via v2.x till the newest (v3.0.4). My guess is that it is either the security settings that wasn't upgraded properly, or that we haven't understood how they work and influence the display. I'll let you know of a couple of specific issues that one person can see, but another one can't (and vice versa).

I'll send you a PM to arrange a ZIP'ed version.
HeartWare
· 1 		HeartWare
Wednesday, September 10, 2008, 4:14:02 PM