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 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 gemini_issues i
INNER JOIN gemini_issueresources r ON r.issueid = i.issueid AND r.userid = 2
INNER JOIN gemini_issuestatus 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 gemini_timetracking 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 gemini_globalgroupmembership gg where gg.globalgroupid = i.visibility)) or (i.visibilitymembertype=3 and 2 in (select pg.userid from gemini_projectgroupmembership 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 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 gemini_issues i
INNER JOIN gemini_issueresources r ON r.issueid = i.issueid AND r.userid = 2
INNER JOIN gemini_issuestatus 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 gemini_timetracking 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 gemini_globalgroupmembership gg where gg.globalgroupid = i.visibility)) or (i.visibilitymembertype=3 and 2 in (select pg.userid from gemini_projectgroupmembership 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