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 Installing 2.1

web-app

After upgrading 2.0.5 to 2.1 using the EXE, when I navigate to the Website I get the following error:

Server Error in '/' Application.

Could not find stored procedure 'geminigetuserid'.

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: Could not find stored procedure 'gemini
getuserid'.

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: Could not find stored procedure 'geminigetuserid'.]
   Gemini.Default.2d89ab686c6ce5fb(String 01977eb99b48e8da) +738
   Gemini.Default.PageLoad(Object sender, EventArgs e) +448
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +731

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

TekkGuy
· 1
TekkGuy
Replies (19)
helpful
0
not helpful

It seems like website upgrade did not work. Did you specify a different name for website?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I uninstalled, restored to my 2.0.5 settings and then re-installed 2.1, this time using a blank as the Virtual Directory name....  It looked like it installed properly now but....now I get this:

Server Error in '/' Application.

Login failed for user 'GEMINI\ASPNET'.

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: Login failed for user 'GEMINI\ASPNET'.

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): Login failed for user 'GEMINI\ASPNET'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   CounterSoft.Gemini.Commons.GeminiHelper.LogEx(Exception ex, String strOtherInfo) +119

[ADOException: cannot open connection] CounterSoft.Gemini.DataProvider.BaseProvider.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +465 CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14 CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) +89 CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() +1669 CounterSoft.Gemini.Business.DatabaseApplicationSettings..ctor() +48 CounterSoft.Gemini.Business.Initialiser..cctor() +20

[TypeInitializationException: The type initializer for 'Initialiser' threw an exception.] CounterSoft.Gemini.Business.DatabaseApplicationSettings.get_GetInstance() +14 CounterSoft.Gemini.Business.ApplicationSettingsFactory.GetAppSettings() +5 CounterSoft.Gemini.Business.ApplicationSettings..cctor() +5

[TypeInitializationException: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.] CounterSoft.Gemini.Business.ApplicationSettings.getShowUserRegistrationLink() +0 CounterSoft.Gemini.Default.PageLoad(Object sender, EventArgs e) +255 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210


TekkGuy
· 1
TekkGuy
helpful
0
not helpful

Ben,

Silly question, but is your new web.config configured with the correct database connection strings?  Remember, that from 2.1 there are two places where you need to update connection strings.


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

I didn't make any changes to the connection string.  I was under the impression that the Auto-Installer was supposed to take care of all of that? 


TekkGuy
· 1
TekkGuy
helpful
0
not helpful

Yes, it should have done.

Did it not amend the web.config file?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I see 3 Places in the WebConfig... 

<add key="hibernate.connection.connectionstring" value="data source=Gemini;initial catalog=Gemini;TrustedConnection=true"/>

<add name="ProfilesServer" connectionString="data source=Gemini;initial catalog=GEMINIASPNETDB;TrustedConnection=true" providerName="System.Data.SqlClient"/>

<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=sa" cookieless="false" timeout="60"/>

The 1st looks fine, the second is strange because there is no GEMINI_ASPNETDB database in my SQL Server, and the third I am not sure what it should be pointing at.


TekkGuy
· 1
TekkGuy
helpful
0
not helpful

Ok, the problem is that you are using trusted connection, but ASP.NET does not have access to the database.

Add ASP.NET as a trusted user to SQL or are you using identity impresonate = true?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Oooo I can't win.  LOL  I added the Local ASP.NET Username to the list of Logins on the SQL Server.  Now I get a different error...

Server Error in '/' Application.

SELECT permission denied on object 'geminiappsettings', database 'Gemini', owner 'dbo'.

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: SELECT permission denied on object 'geminiappsettings', database 'Gemini', owner 'dbo'.

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): SELECT permission denied on object 'geminiappsettings', database 'Gemini', owner 'dbo'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857370
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734982
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
   System.Data.SqlClient.SqlDataReader.get_MetaData() +62
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +9
   NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) +112
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) +271
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +280
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +83
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +62

[ADOException: could not execute query[SQL: SELECT this.settingid as settingid340, this.settingname as settingn2340, this.settingcategory as settingc3340, this.settingvalue as settingv4340, this.settingdesc as settingd5340, this.tstamp as tstamp340 FROM geminiappsettings this_ WHERE this_.settingname = ?]] CounterSoft.Gemini.DataProvider.BaseProvider.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +465 CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14 CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) +89 CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() +1669 CounterSoft.Gemini.Business.DatabaseApplicationSettings..ctor() +48 CounterSoft.Gemini.Business.Initialiser..cctor() +20

[TypeInitializationException: The type initializer for 'Initialiser' threw an exception.] CounterSoft.Gemini.Business.DatabaseApplicationSettings.get_GetInstance() +14 CounterSoft.Gemini.Business.ApplicationSettingsFactory.GetAppSettings() +5 CounterSoft.Gemini.Business.ApplicationSettings..cctor() +5

[TypeInitializationException: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.] CounterSoft.Gemini.Business.ApplicationSettings.getShowUserRegistrationLink() +0 CounterSoft.Gemini.Default.PageLoad(Object sender, EventArgs e) +255 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210


TekkGuy
· 1
TekkGuy
helpful
0
not helpful

That is because the SQL user (ASP.NET) does not have permission on the database.

The easiest thing to do is to give it db_owner permission.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Nope that is not the case.  I already set ASP.NET to have db-owner permissions.


TekkGuy
· 1
TekkGuy
helpful
0
not helpful

Are you sure it has db_owner on the Gemini database?

The error states the it does not have permissions.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Try rebooting the web app.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

By rebooting you mean Stopping and then Starting the Website through IIS?  If so, I already tried that.


TekkGuy
· 1
TekkGuy
helpful
0
not helpful

I mean restart the application pool that Gemini uses or save the web.config file.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Ok, I restarted the IIS Server, and now it seems to be working....but now I have a Licensing problem...

 

Who do I contact to get my License fixed?


TekkGuy
· 1
TekkGuy
helpful
0
not helpful

Ok, I restarted IIS Server and now all seems to be working....so far.

I am now having an issue with my License, who do I contact to get my License fixed?

---------------

Oops, excuse the double post, I didn't realize it went to a page 2.  :-)  Tried to delete this post...wouldn't let me.


TekkGuy
· 1
TekkGuy
helpful
0
not helpful

What is the issue with the license?

Please send details to support@countersoft.com including the license key.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I am getting the same error. What was the resolution to this?


patrick24601
· 1
patrick24601
helpful
0
not helpful

What errors do you get?


Mark Wing
· 9108
Mark Wing