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.




Invalid object name 'geminiappsettings'

web-app

Hi, folks,

I'm doing a manual upgrade from 2.0.5 to 2.1.1, and I'm getting the error "Invalid object name 'geminiappsettings'."  I ran the upgrade scripts supplied in the zip file, and the user specified in the web.config has dbo rights to the database.  I have recycled the resource pool and restarted the Web site. What else might I try?  (The same issue occurs when upgrading to 2.2.)

I'm running IIS 6.0, connecting to a SQL 2000 SP4 database.

Thanks,

Tom


Here's the full stack dump:

Server Error in '/' Application.

Invalid object name 'geminiappsettings'.

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: Invalid object name 'geminiappsettings'.

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): Invalid object name 'geminiappsettings'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.getMetaData() +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) +903
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) +469
CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14
CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) +89
CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() +1565
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.Page
Load(Object sender, EventArgs e) +285
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.832; ASP.NET Version:2.0.50727.832

tomaddox
· 1
tomaddox
Replies (10)
helpful
0
not helpful

Couple of questions:

1. Does the table "GeminiAppSettings" actually exist?

2. Can you select data from this table using the SAME SWQL login credentials as specified in the web.config?

3. Please double-check that you are pointing towards the correct database.


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

1) I don't know if it existed; I had to roll back the upgrade.  I ran the upgrade scripts from the zip file, and they ran without error, so I assume they would have created the table.

2) It should certainly be possible; the account has dbo privileges, and I verified connectivity with those credentials.  I'll double-check when I get the chance, though.

3) Yes.

Thanks,

Tom


tomaddox
· 1
tomaddox
helpful
0
not helpful

Hi Tom,

When you get a chance, "select count(*) from geminiappsettings" and let me know how many rows you have.


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

Sorry, I haven't had time to work on this for a while.  The number of rows is 52.

Thanks,

Tom


tomaddox
· 1
tomaddox
helpful
0
not helpful

Apparently, I cannot select data using the same SQL credentials as specified in web.config.  This is very strange, insofar as those credentials should have dbo rights to the db.  What should I look for to correct this problem?


tomaddox
· 1
tomaddox
helpful
0
not helpful

You need to give the user dbo permissions on the database. You can do so by using Enterprise Manager, go to the security section of the SQL server


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

As I mentioned before, the user appears to have dbo permissions.  Is there anything else I should look for?


tomaddox
· 1
tomaddox
helpful
0
not helpful

Are you sure?

" Apparently, I cannot select data using the same SQL credentials as specified in web.config"

Please do double-check.


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

I've had one of our DBAs verify that the account has dbo access, and he says it does.  The other point that's worth noting is that this is the same account currently used to access the database from our 2.0.5 installation, so something is clearly breaking during the upgrade process.


tomaddox
· 1
tomaddox
helpful
0
not helpful

This is an SQL issue. You have 2 options:

  1. Create a new user for Gemini to use.
  2. Ask your DBA why the current user can not access the database (as you suggested).


Saar Cohen
· 5000
Saar Cohen