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.




Globalization pt-PT

web-app

In web.config of 3.6, in previous versions worked fine, if we change to:

globalization culture="pt-PT" uiCulture="pt-PT" requestEncoding="utf-8" responseEncoding="utf-8"

we get the error:

Conversion failed when converting datetime from character string. Descrição: Excepção não processada ao executar o pedido Web actual. Consulte o rastreio da pilha para obter mais informações sobre o erro e o respectivo ponto de origem no código.

Detalhes da excepção: System.Data.SqlClient.SqlException: Conversion failed when converting datetime from character string.

Erro de origem:

Foi gerada uma excepção não processada durante a execução do pedido Web actual. As informações relativas à origem e localização da excepção poderão ser identificadas através da utilização do rastreio da pilha de excepções abaixo.

Rastreio da pilha:

[SqlException (0x80131904): Conversion failed when converting datetime from character string.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1951450 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849003 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2394 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 52 as UserID, COUNT(DISTINCT i.issueid) AS OpenIssues, SUM(CASE WHEN i.duedate BETWEEN '10 Janeiro 2010' AND '17 Janeiro 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 = 52 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 = 52 GROUP BY tt.issueid) t ON t.issueid = i.issueid WHERE ((i.visibilitymembertype=2 and 52 in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = i.visibility)) or (i.visibilitymembertype=3 and 52 in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = i.visibility))) ] [SQL: SELECT 52 as UserID, COUNT(DISTINCT i.issueid) AS OpenIssues, SUM(CASE WHEN i.duedate BETWEEN '10 Janeiro 2010' AND '17 Janeiro 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 = 52 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 = 52 GROUP BY tt.issueid) t ON t.issueid = i.issueid WHERE ((i.visibilitymembertype=2 and 52 in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = i.visibility)) or (i.visibilitymembertype=3 and 52 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

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

This is another bug that was found in 3.6 and is fixed in 3.6.1: http://gemini.countersoft.com/Default.aspx?p=2&i=3447

The workaround is to set your SQL server user (the one that Gemini uses in the web.config) language to PT as well.


Saar Cohen
· 5000
Saar Cohen