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.




Error when lauching the following reports in Gemini 4.2.1 :

reporting

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
User70047
Replies (10)
helpful
0
not helpful

Please check that your SQL user is set to the same language as used in the web.config file.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

My SQL server profile is set to French ; and the web.config contains the following line:

    <globalization culture="fr-FR" uiCulture="fr-FR" requestEncoding="utf-8" responseEncoding="utf-8"/>

User70047
· 1
User70047
helpful
0
not helpful

Try setting the SQL user to English.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

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)


User70047
· 1
User70047
helpful
0
not helpful

What is the date that you have selected?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

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


User70047
· 1
User70047
helpful
0
not helpful

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)


User70047
· 1
User70047
helpful
0
not helpful

You will have to set the web.config to en-GB


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

With en-GB instead of fr-FR it works. What border effects could we have with the en-GB config ?


User70047
· 1
User70047
helpful
0
not helpful

Dates display will be in UK format (dd/mm/yyyy)


Mark Wing
· 9108
Mark Wing