Globalization pt-PT
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 |
|
Wednesday, January 13, 2010, 11:37:29 AM |