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.




Bug - Selecting date picker in Time throws exception

web-app

Next to My Work is a Time link - click on it, select a day and an exception is thrown - note this is as soon as you enter this page and only applies to the current day. Select another day then back to current and it's fine

Server Error in '/Gemini' Application.

        <h2> <i>SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.</i> </h2></span>

        <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

        <b> Description: </b>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.

        <b> Exception Details: </b>System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.<br><br>

        <b>Source Error:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code>

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.

              </td>
           </tr>
        </tbody></table>

        <br>

        <b>Stack Trace:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code></code><pre>[SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.]<br>   CounterSoft.Gemini.DataProvider.x27805b9842074039.GetUserTimeData(Int32 userID, Nullable`1 projectid, DateTime startDate, DateTime endDate) +933<br>   CounterSoft.Gemini.Business.xef04d86ea23a18a5.GetUserTimeData(Int32 userID, Nullable`1 projectid, DateTime startDate, DateTime endDate) +100<br>   CounterSoft.Gemini.Web.User.TimeView.BindData() +312<br>   CounterSoft.Gemini.Web.User.TimeView.radCalendar_SelectionChanged(Object sender, SelectedDatesEventArgs e) +28<br>   Telerik.Web.UI.RadCalendar.OnSelectionChanged() +102<br>   Telerik.Web.UI.RadCalendar.RaisePostBackEvent(String eventArgument) +734<br>   Telerik.Web.UI.RadCalendar.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7<br>   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11<br>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +177<br>   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746<br></pre></td></tr></tbody></table></font><br>
SimonASE
· 1
SimonASE
Replies (3)
helpful
0
not helpful

Which version of Gemini are you running?

We have tried recreating this without success.

Are you saying: My Time -> Click on time entry icon -> enter time?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi,

Build 1955 - steps to reproduce:

1/ Click on 'Time' next to 'My Work'
2/ If today is 15th May, click on 15 in the left hand calendar
3/ Exception is thrown

We can reproduce this consistently.

Regards

Simon


SimonASE
· 1
SimonASE
helpful
0
not helpful

Got it, thanks! Will be fixed for 3.0.1.


Saar Cohen
· 5000
Saar Cohen