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.




[SqlException (0x80131904): Invalid object name 'dbo.aspnet_SchemaVersions'.]

web-app

I'm installing from database for v2.0.5. I've installed manuall as the automatic install was failing.

I am getting the following error.

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 'dbo.aspnetSchemaVersions'.

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 'dbo.aspnet
SchemaVersions'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857354
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734966
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
   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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
   System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +367
   System.Web.Profile.SqlProfileProvider.CheckSchemaVersion(SqlConnection connection) +65
   System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +766
   System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) +428
   System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +410
   System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) +117
   System.Configuration.SettingsBase.getItem(String propertyName) +89
   System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36
   System.Web.Profile.ProfileBase.get
Item(String propertyName) +68
   System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) +4
   CounterSoft.Gemini.Business.Profile.getMaxIssuesPerPage() +62
   CounterSoft.Gemini.IssuesWeb.Page
Load(Object sender, EventArgs e) +8510
   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
   CounterSoft.Gemini.Business.BasePage.OnLoad(EventArgs e) +4
   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

Could you please point me in some direction. This is a test installation so I am installing on my pc and against a dev database. I created a new database geminiaspnetdb, and ran the installcommon.sql and installprofile.sql files against them.

I also ran Upgradev2-1.sql, CreateViews.sql, CreateProcs.sql against the v2.0.5 database. But the queries in gemini seem to be fine.

Thanks

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

Please make sure you have set the profile connection string to the new database you have created (gemini_aspnetdb).


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

indeed. I should have read

http://community.countersoft.com/forums/thread/4012.aspx

More carefully.

Thanks


incred
· 1
incred
helpful
0
not helpful

Hi,

I have a similar problem, after automatic upgrade from 2.05 to 2.1.1

and manual web.config merge. I can lauch gemini but when I try to display a liste of issues I got error message [Procédure stockée 'dbo.aspnetCheckSchemaVersion' introuvable] "the stored procedure dbo.aspnetChekShemaVersion can not be found"

during automatic installation I've followed instructions in Gemini.pdf page 18 [If you wish to use an existing ASPNETDB database, then please specify the name of the database and de-select the "Run Scripts" option.] I'd like to use the same database but in my gemini database there is no stored procedure named 'aspnet_CheckSchemaVersion'.

I can't find such stored procedure in any sql file installed in C:\Program Files\CounterSoft\Gemini Project Issue Tracking\Database

Thanks for Help and sorry for my english "accent" [;)]


Triv
· 1
Triv
helpful
0
not helpful

Run the InstallCommon.sql and InstallProfile.sql scripts that can be found under the database directory.

Also, make sure you have set the profile connection string in the web.config file.


Mark Wing
· 9108
Mark Wing