CounterSoft User Forums
Welcome to CounterSoft User Forums Sign in | Join | Help
Home Forums
CounterSoft User Forums » Gemini Core » Gemini » Invalid object name 'geminiappsettings'

Invalid object name 'geminiappsettings'

Last post 10-15-2007, 9:16 PM by SaarCohen. 10 replies.
Sort Posts:

  •  08-21-2007, 7:15 PM

    Invalid object name 'geminiappsettings'

    Reply Quote
    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.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) +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 settingid34_0_, this_.settingname as settingn2_34_0_, this_.settingcategory as settingc3_34_0_, this_.settingvalue as settingv4_34_0_, this_.settingdesc as settingd5_34_0_, this_.tstamp as tstamp34_0_ 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.get_ShowUserRegistrationLink() +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

  •  08-22-2007, 9:30 AM

    Re: Invalid object name 'geminiappsettings'

    Reply Quote

    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
    CounterSoft™

  •  08-22-2007, 5:36 PM

    Re: Invalid object name 'geminiappsettings'

    Reply Quote
    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

  •  08-23-2007, 10:17 AM

    Re: Invalid object name 'geminiappsettings'

    Reply Quote

    Hi Tom,

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

    Harvey Kandola
    CounterSoft™

  •  10-13-2007, 9:34 PM

    Re: Invalid object name 'geminiappsettings'

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

    Thanks,

    Tom

  •  10-13-2007, 9:45 PM

    Re: Invalid object name 'geminiappsettings'

    Reply Quote
    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?

  •  10-13-2007, 9:50 PM

    Re: Invalid object name 'geminiappsettings'

    Reply Quote
    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

  •  10-13-2007, 10:00 PM

    Re: Invalid object name 'geminiappsettings'

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

  •  10-15-2007, 3:39 PM

    Re: Invalid object name 'geminiappsettings'

    Reply Quote
    Are you sure?

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

    Please do double-check.
    Harvey Kandola
    CounterSoft™

  •  10-15-2007, 6:51 PM

    Re: Invalid object name 'geminiappsettings'

    Reply Quote
    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.

  •  10-15-2007, 9:16 PM

    Re: Invalid object name 'geminiappsettings'

    Reply Quote

    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).
View as RSS news feed in XML
(c) 2009 CounterSoft Limited