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.




Problem after re-install

web-app

I re-installed 2.2.2 over my 2.2 install and now get the following error:

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

This stored proc exists in the database and the params (database name, etc) are correct in the web.config file.

This only happens when trying to access the issues in the DB - all else seems to work fine.

Thanks for your help

Matt

 

mhopkins
· 1
mhopkins
Replies (15)
helpful
0
not helpful

Hi Matt,

There are two places in the Gemini web.config where you should specify database connections.  Please double check them BOTH.

 

 


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

I have them set in the following two areas:

  <nhibernate>
      <!-- The SQL Server dialect (Gemini supports "MsSql2005Dialect" or "MsSql2000Dialect" or "MsSql7Dialect") -->
      <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/>
      <!-- The SQL Server database connection string -->
      <add key="hibernate.connection.connectionstring" value="data source=##DBSERVER##;initial catalog=Gemini;user id=##USER##;password=##PWD##"/>
      <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
      <add key="hibernate.connection.driver
class" value="NHibernate.Driver.SqlClientDriver"/>
  </nhibernate>
  <GeminiLocalisation>
    <GeminiLocalisation defaultCulture="en-GB" languageFilePath="Language"/>
  </GeminiLocalisation>
  <connectionStrings>
    <add name="ProfilesServer" connectionString="data source=##DBSERVER##;initial catalog=Gemini-aspnetdb;user id=##USER##;password=##PWD##" providerName="System.Data.SqlClient"/>
  </connectionStrings>
 

The params with ##xx## have been changed but are using the real values.  Gemini works except for when it goes to get the issues.. it then reports the error above (previous post).

Is there something else missing?  The stored proc it is searching for is in the "Gemini-aspnetdb" database.

Thanks for your help
Matt


mhopkins
· 1
mhopkins
helpful
0
not helpful

Does the profile database exist? If so, did you run the installcommon.sql and installprofile.sql scripts?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

The profile database exists and contains the stored proc that is being reported in the error.


mhopkins
· 1
mhopkins
helpful
0
not helpful

I can add users, see the project - I just can't view/amend/create issues.


mhopkins
· 1
mhopkins
helpful
0
not helpful

Please make sure that the owner of the objects is dbo.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

yes - it is.  I said, the DB was working fine before the re-install....   the only area of the DB that the web interface does not seem to be able to access is the issues list...


mhopkins
· 1
mhopkins
helpful
0
not helpful

The error is that the web app can not "see" the profile database.

It might be that the profile connection string is wrong or the user does not have access.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

How is it that it can "see" the projects, versions, users, etc?


mhopkins
· 1
mhopkins
helpful
0
not helpful

Here's the full text of the message:

Invalid object name 'dbo.aspnet_SchemaVersions'. 28/09/2007 09:22:48 SOURCE: .Net SqlClient Data Provider TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean) STACKTRACE: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavio

Is this significant?  (TARGETSITE: Void)

Could my web.config be correupt?  Can I send it to someone?

Thanks in advance
Matt


mhopkins
· 1
mhopkins
helpful
0
not helpful

It can "see" projects etc.. because they use the Gemini database schema!

The error points to the ASP.NET profile schema, which means that you either did not set the profile connection string in the web.config file or you have not set up the profile database.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

[[sorry for the delay in responding]]

So can you provide me with a sample "profile connection string" so that I can make sure it is in the web.config file and set correctly?


mhopkins
· 1
mhopkins
helpful
0
not helpful

<add name="ProfilesServer" connectionString="data source=YOUR SERVER NAME HERE;initial catalog=DATABASE;user id=USER;password=PASSWORD" providerName="System.Data.SqlClient"/>

 


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

That connection string already existed in the web.config:

  <connectionStrings>
    <add name="ProfilesServer" connectionString="data source=DBSERVER;initial catalog=gemini-aspnetdb;user id=GEMINI;password=XXXXX" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Any other ideas?

Thanks
Matt


mhopkins
· 1
mhopkins
helpful
0
not helpful

OK - I have solved it.  This was a bit of a "doh!" moment... the new install created a separate directory with a new web.config... sorry about the trouble but I'm back online now.


mhopkins
· 1
mhopkins