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.




Find Issue - Button does not work.

web-app

Hello,

Here are the details about our environment:

Gemini Version Number - Gemini 3.5.4 (Build 2435) SQL Server - 2005 Standard Operating System - Windows Server 2003 Enterprise SP2

Problem - When I type in a number to find in the find issue box and then click on find issue I get the below error.

Investigation - This is happening for all users. I've logged onto the SQL server that holds the Gemini database and I can use the Gemini SQL user to access that database. Users can perform other tasks in Gemini as per normal so it must be interacting with the database, it's just that Find Issue feature does not work.

I've run Gemini from the server and the Find Issue button does work there, just not for client PC's.

Any help would be appreciated :)

Kind regards,

Chris

Error below.

Server Error in '/Gemini' Application.

Cannot open database "Gemini" requested by the login. The login failed. Login failed for user 'Gemini'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "Gemini" requested by the login. The login failed. Login failed for user 'Gemini'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Cannot open database "Gemini" requested by the login. The login failed. Login failed for user 'Gemini'.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117 System.Data.SqlClient.SqlConnection.Open() +122 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +77 CounterSoft.Gemini.DataProvider.x8df70fe33cbb127e.xa1aeea62238aba99(ExceptionEN xb4d7989cd9e7077d) +264

[ADOException: cannot open connection] NHibernate.Impl.SessionFactoryImpl.OpenConnection() +95 NHibernate.AdoNet.ConnectionManager.GetConnection() +50 NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd) +56 NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +27 NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +239 NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +203 NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +70 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +174 NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +18 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +81 NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +332 NHibernate.Impl.CriteriaImpl.List(IList results) +41 NHibernate.Impl.CriteriaImpl.List() +35 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, ISession x45b53be31e53d68b, Object[] xdbd7e0681bb13f72) +84 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +61 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +16 CounterSoft.Gemini.DataProvider.x99c4b1798e19cb2e.x1a95834709519378(String x2335cd6458013014) +77 CounterSoft.Gemini.Business.ApplicationSettings.GetGeminiConfiguration() +96 CounterSoft.Gemini.Business.ApplicationSettings.getConfig() +81 CounterSoft.Gemini.Presenter.GeminiHttpModule.ApplicationAuthenticateRequest(Object source, EventArgs e) +77 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75


Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618

ChrisRNZ
· 1
ChrisRNZ
Replies (4)
helpful
0
not helpful

What is the URL in the browser's address bar when this error occurs?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Hello,

Thank you for your response. The URL shown when the error message is displayed is the following:

http://localhost/Gemini/issue/ViewIssue.aspx?id=6779&PROJID=4

I'm not sure why the URL should be pointing at localhost, typically the URL is something like the following:

http://bizprocserv/Gemini/Main.aspx

The first time you search for an issue when it brings up this error it takes about 15 seconds to do so. Pressing the back button on the browser, entering in a different number into the Find Issues box and clicking the button again brings the error page up almost immediately.

Kind regards,

Chris


ChrisRNZ
· 1
ChrisRNZ
helpful
0
not helpful

Please check your full Gemini url setting (Administration -> General).
If it is correct set "Enfore url" to yes.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hello,

Thanks for your reply. This fixed the issue :) !

I'll update our internal documentation to reflect that change. Again, very much appreciate your reply.

Kind regards,

Chris


ChrisRNZ
· 1
ChrisRNZ