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.




v3.1.0: can't view home page of certain existing gemini project

web-app

I am having problem opening a home page of a Gemini project which has a lot of attachments and it's a biggest Gemini project.  I have no problem opening the other Gemini projects.

I logged in ok, browse the page ok, but when I clicked on home of the biggest project (or choose it from the Drop Down), i got this error.  I rebooted the Gemini server and still got the same problem.  Gemini is installed on D: drive and we happened to find out that C: (where OS installed) was out of space.  Don't know if this error is because of low disk space on C:.  But we did free up 5GB of space on C: and then rebooted the server, problem still persists.  We can go to view the issues inside of that Gemini project by entering the issue number and click Find Issue button.  But to go to HOME of that project, we got below error.  Checked SQL server, no event log for error nor warning.  No problem with disk space, C: has 5GB free space.

    </style><font size="1"><span>

Server Error in '/Gemini' 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) +616
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() +70
CounterSoft.Gemini.Web.Project.ProjectHome.PageLoad(Object sender, EventArgs e) +797
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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3614



================================================

System log error:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 9/27/2010 6:00:09 PM 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.SelectTab() 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) .Net SqlClient Data Provider

======================
Application Event log on Gemini server:

 
Application information:
    Application domain: /LM/w3svc/1858112242/Root/Gemini-1-129300980008389962
    Trust level: Full
    Application Virtual Path: /Gemini
    Application Path: D:\Data\CounterSoft\Gemini Project Issue Tracking\Gemini Web Application\
    Machine name:
 
Process information:
    Process ID: 5264
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
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://domain/gemini/project/Project.aspx?PROJID=14
    Request path: /gemini/project/Project.aspx
    User host address: 204.255.139.52
    User: kha
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 9
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    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.ProjectHome.SelectTab()
   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)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

kha
· 1
kha
Replies (8)
helpful
0
not helpful

What is the size of your Gemini database and what are the increments?
It might be due to data fragmentation in which case running: update statistics gemini_issues with fullscan
should help.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

[quote user="MarkWing"]What is the size of your Gemini database [/quote]
3155.19MB currently
[quote]and what are the increments?[/quote]
10% autogrowth
[quote]
It might be due to data fragmentation in which case running: update statistics gemini_issues with fullscan
should help.[/quote]
Will it slow down the Gemini performance while scanning? should i run it off business hour or it doesn't matter


kha
· 1
kha
helpful
0
not helpful

This does point to data fragmentation as the database grew in very small increments.
Running the command might slow things down, so might want to run it after business hours.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I don't know if it's related.  But now, we are no longer receiving the email notifications about issues.

Scheduler service is started and Notification has settings like this still:

Yes, Yes, Yes, Scheduler Services, <email address>, <display name>

I've tested it out in my "TEST" project on Gemini, created new issue, i don't get notification at all.


kha
· 1
kha
helpful
0
not helpful

Are there any errors in event viewer (application log) where the scheduler is installed?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Did i do it right? It only took me 4 seconds to run the command successfully:

1) Open the Gemini db, expand Tables, select dbo.Geminiissues
2) Query, run: update statistics gemini
issues with fullscan




I am testing the command with the backup of my Gemini production db on a staging server.  It doesn't tell me what went wrong, what got fixed, after running that command.  Result just shows "Command(s) completed successfully"


kha
· 1
kha
helpful
0
not helpful

The command will just re-stat your table. Check the application log for errors.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

[quote user="MarkWing"]The command will just re-stat your table. Check the application log for errors.
[/quote]

I checked Application log in Event Viewer of my SQL staging server, found no error or warning.
The last information i found in there is regarding to my db restored (when I restored the backup of production db here for testing purpose).  Nothing else after that.




Regarding to the email notification problem, I found problem with the Scheduler Service that we restarted yesterday and it failed to communicate with the client <IP of gemini server>.  I just stop and restart the Scheduler Service, I received email notification ok now.  Thanks! [:D]


kha
· 1
kha