Error when lauching the following reports in Gemini 4.2.1 :
Error when lauching the following reports in Gemini 4.2.1 :
Resource Activity / Resource Hours allocation / activity trend / component activity ... all reports with date or date range input except time tracking report which works fine.
here is the log :
La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors limite de date et d'heure. à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) à System.Data.SqlClient.SqlDataReader.HasMoreRows() à System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) à System.Data.SqlClient.SqlDataReader.Read() à NHibernate.Driver.NHybridDataReader.Read() à NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) à NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) à NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
User70047
· 1 |
|
Monday, November 12, 2012, 4:39:26 PM |
0
|
Please check that your SQL user is set to the same language as used in the web.config file. |
||||
|
0
|
My SQL server profile is set to French ; and the web.config contains the following line:
|
||||
|
0
|
Try setting the SQL user to English. |
||||
|
0
|
SQL user is now set to english. The result is the error message is now in English : The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) à System.Data.SqlClient.SqlDataReader.HasMoreRows() à System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) à System.Data.SqlClient.SqlDataReader.Read() à NHibernate.Driver.NHybridDataReader.Read() à NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) à NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) à NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) |
||||
|
0
|
What is the date that you have selected? |
||||
|
0
|
I have selected the "11 Nov,2012" with the calendar. I also tried with 11/12/2012 directly in the textbox , the result is the same |
||||
|
0
|
Here are new elements : I capture the SQL trace ; as you can see there is a problem with the date cast ==> there is a doit after the month that cause the error. SET DATEFIRST 1 SELECT SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, CAST('08-nov.-2012' AS DATETIME)) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW0, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -1, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW1, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -2, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW2, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -3, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW3, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -4, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW4, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -5, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW5, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -6, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW6, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -7, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW7, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -8, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW8, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -9, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW9, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -10, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW10, SUM(CASE WHEN DATEPART(WEEK, i.created)=DATEPART(WEEK, DATEADD(WEEK, -11, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.created) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS CreatedW11, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, CAST('08-nov.-2012' AS DATETIME)) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW0, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -1, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW1, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -2, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW2, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -3, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW3, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -4, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW4, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -5, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW5, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -6, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW6, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -7, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW7, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -8, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW8, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -9, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW9, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -10, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW10, SUM(CASE WHEN DATEPART(WEEK, i.closeddate)=DATEPART(WEEK, DATEADD(WEEK, -11, CAST('08-nov.-2012' AS DATETIME))) AND YEAR(i.closeddate) = YEAR(CAST('08-nov.-2012' AS DATETIME)) THEN 1 ELSE 0 END) AS ClosedW11 FROM geminiissues i INNER JOIN geminiissuecomponents ic ON i.issueid = ic.issueid INNER JOIN geminicomponents c ON c.componentid = ic.componentid INNER JOIN geminiissuestatus s ON s.statusid = i.issuestatusid WHERE (i.created>=DATEADD(WEEK, -11, CAST('08-nov.-2012' AS DATETIME)) OR i.closeddate>=DATEADD(WEEK, -11, CAST('08-nov.-2012' AS DATETIME))) AND ((i.visibilitymembertype=2 and 82 in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = i.visibility)) or (i.visibilitymembertype=3 and 82 in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = i.visibility))) AND i.projectid in (18) |
||||
|
0
|
You will have to set the web.config to en-GB |
||||
|
0
|
With en-GB instead of fr-FR it works. What border effects could we have with the en-GB config ? |
||||
|
0
|
Dates display will be in UK format (dd/mm/yyyy) |
||||
|