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.




SQL Error when upgrading from 2.2.6 to 3.0.3

web-app

I have the following error on my Gemini Web Site whe I try to start

Environment

IIS 6

SQL 2000

DB Named gemini with User gemini as master of the DB,

 

Error On the Web

 

Server Error in '/Gemini' Application.

Invalid object name 'geminiapplicationsettings'.

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 'gemini
applicationsettings'.

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 'geminiapplicationsettings'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
   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) +1005
   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) +32
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) +182
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +175
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +56
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +30

[ADOException: could not execute query [ SELECT this.settingid as settingid300, this.settingname as settingn2300, this.settingcategory as settingc3300, this.settingvalue as settingv4300, this.settingdesc as settingd5300, this.tstamp as tstamp300 FROM geminiapplicationsettings this WHERE this.settingname = ? ] Positional parameters: 0 EnableHTMLPosts [SQL: SELECT this.settingid as settingid300, this.settingname as settingn2300, this.settingcategory as settingc3300, this.settingvalue as settingv4300, this.settingdesc as settingd5300, this.tstamp as tstamp300_ FROM geminiapplicationsettings this WHERE this.settingname = ?]] NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +110 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) +78 NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results) +324 NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria) +42 NHibernate.Impl.CriteriaImpl.List() +12 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, ISession x45b53be31e53d68b, Object[] xdbd7e0681bb13f72) +55 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +53 CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14 CounterSoft.Gemini.DataProvider.x99c4b1798e19cb2e.x1a95834709519378(String x2335cd6458013014) +89 CounterSoft.Gemini.Business.ApplicationSettings.GetGeminiConfiguration() +3362 CounterSoft.Gemini.Business.ApplicationSettings.getConfig() +74 CounterSoft.Gemini.Presenter.GeminiHttpModule.Application_AuthenticateRequest(Object source, EventArgs e) +370 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

odalence
· 1
odalence
Replies (5)
helpful
0
not helpful

Did you follow the upgrade guide and run the upgrade scripts?

Seems like you either not done so or done so under another user.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I follow the upgrading guide exactly as it said, and the execution of the script are successfully and i execute those with the correct user i create on sql server


odalence
· 1
odalence
helpful
0
not helpful

Is that the same user that the web.config is using?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I use the same user for upgrading, and now i was running again the upgrade script and have the following error

<SQLError Package="CounterSoftGeminiv301SampleDatabase"><Error>There is already an object named 'geminigetissuereportersforallprojects' in the database.</Error><Assembly>CounterSoftGeminiv301SampleDatabase</Assembly><Package>Package1.resx</Package><Batch>Batch642</Batch><SQL>
CREATE PROCEDURE gemini
getissuereportersforallprojects
as
begin

SELECT b.projectid,a.firstname+N' '+a.surname AS fullname
FROM geminiusers a join geminiissues b on a.userid=b.reportedby
GROUP BY b.projectid,a.firstname+N' '+a.surname
ORDER BY fullname

end
 
</SQL></SQLError>


odalence
· 1
odalence
helpful
0
not helpful

This is not the upgrade, this will create a new database. Use the scripts provided in the upgrade directory.


Mark Wing
· 9108
Mark Wing