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.

Report Fails, when date fields are the parameters


hi, I'm testing gemini platform. When I try to run a report ( Resource Hours Allocation ) and enter some date range, e.g. 12/01/11 to 12/16/11, or how the date picker return: 1 Dec,2011.

I get this error: 4 15/12/2011 16:51:03 Error Gemini Conversion failed when converting date and/or time from character string. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at NHibernate.Driver.NHybridDataReader.Read() at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

Any suggestion ? Best Regards Nicolas

· 1
Replies (1)
not helpful

What is your gloabliztion section in the web.config set to?

··· I dont know . I'm using the testing demo version, wich assume is located somewhere in the cloud ... User52723-NicolasMachadoFriday, December 16, 2011, 4:15:58 PM

Mark Wing
· 9108
Mark Wing