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.




Problem after upgrade to version 3.6

migration

Hello, i'm having a problem after migrate to version 3.6. After login, i get the following error. I have emailed it to support, but no response.

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: Error de conversión al convertir una cadena de caracteres a datetime.

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): Error de conversión al convertir una cadena de caracteres a datetime.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392 System.Data.SqlClient.SqlDataReader.HasMoreRows() +157 System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +197 System.Data.SqlClient.SqlDataReader.Read() +9 NHibernate.Driver.NHybridDataReader.Read() +14 NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +704 NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +70 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +102

[ADOException: could not execute query [ SELECT 2 as UserID, COUNT(DISTINCT i.issueid) AS OpenIssues, SUM(CASE WHEN i.duedate BETWEEN '25 January 2010' AND '1 February 2010' THEN 1 ELSE 0 END) AS IssuesDueThisWeek, SUM(CASE WHEN i.duedate < GETDATE() THEN 1 ELSE 0 END) AS IssuesOverdue, CAST(SUM(t.TotalHours) AS INT) AS TotalLoggedHours, CAST(SUM(t.TotalMinutes) AS INT) AS TotalLoggedMinutes, CAST(SUM(i.estimatehours) AS INT) AS TotalEstimatedHours, CAST(SUM(i.estimateminutes) AS INT) AS TotalEstimatedMinutes FROM geminiissues i INNER JOIN geminiissueresources r ON r.issueid = i.issueid AND r.userid = 2 INNER JOIN geminiissuestatus s ON s.statusid = i.issuestatusid AND s.isfinal = 0 INNER JOIN (SELECT tt.issueid, SUM(tt.hours) AS TotalHours, SUM(tt.minutes) AS TotalMinutes FROM geminitimetracking tt WHERE tt.userid = 2 GROUP BY tt.issueid) t ON t.issueid = i.issueid WHERE ((i.visibilitymembertype=2 and 2 in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = i.visibility)) or (i.visibilitymembertype=3 and 2 in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = i.visibility))) ] [SQL: SELECT 2 as UserID, COUNT(DISTINCT i.issueid) AS OpenIssues, SUM(CASE WHEN i.duedate BETWEEN '25 January 2010' AND '1 February 2010' THEN 1 ELSE 0 END) AS IssuesDueThisWeek, SUM(CASE WHEN i.duedate < GETDATE() THEN 1 ELSE 0 END) AS IssuesOverdue, CAST(SUM(t.TotalHours) AS INT) AS TotalLoggedHours, CAST(SUM(t.TotalMinutes) AS INT) AS TotalLoggedMinutes, CAST(SUM(i.estimatehours) AS INT) AS TotalEstimatedHours, CAST(SUM(i.estimateminutes) AS INT) AS TotalEstimatedMinutes FROM geminiissues i INNER JOIN geminiissueresources r ON r.issueid = i.issueid AND r.userid = 2 INNER JOIN geminiissuestatus s ON s.statusid = i.issuestatusid AND s.isfinal = 0 INNER JOIN (SELECT tt.issueid, SUM(tt.hours) AS TotalHours, SUM(tt.minutes) AS TotalMinutes FROM geminitimetracking tt WHERE tt.userid = 2 GROUP BY tt.issueid) t ON t.issueid = i.issueid WHERE ((i.visibilitymembertype=2 and 2 in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = i.visibility)) or (i.visibilitymembertype=3 and 2 in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = i.visibility)))]] NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +196 NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +18 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +79 NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) +18 NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) +184 NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) +182 NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) +185 NHibernate.Impl.SqlQueryImpl.List() +158 CounterSoft.Gemini.DataProvider.xcaaeca374ab161a3.x9737b3b33c3b6390(UserEN xfd92dbe2fa4bcb5a, DateTime x29b9a7c7dc239631, DateTime xf31ab6c893aae0e0) +225 CounterSoft.Gemini.Business.Users.GetUserSummary(UserEN user, DateTime start, DateTime end) +49 CounterSoft.Gemini.Business.Users.GetUserSummary(UserEN user) +170 CounterSoft.Gemini.Controls.UserWelcome.Page_Load(Object sender, EventArgs e) +92 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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

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

cointec
· 1
cointec
Replies (1)
helpful
0
not helpful

Please upgrade to 3.6.2.


Mark Wing
· 9108
Mark Wing