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

Steps to get this error:

1. import existing 2.0.1 database from hosting subscription

2. run your 2.2.0 installer to install gemini on local xp machine

3. install into new virtual directory Gemini

4. uncheck create new database in install

5. no option to upgrade 2.0.1 ??? Don't know what to do here. I have tried upgrade existing 2.1.x both checked and unchecked. There is nothing in the pdf for this..

6. edit web.config: <customErrors mode="Off" defaultRedirect="Error.aspx"/>

7.  add  ASPNET to database users since this is IIS5

8. site gives Invalid object name 'geminiappsettings'. error. The database did not upgrade for some reason. How to upgrade an existing 2.0.1 database to 2.2?





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

In the pdf:

"See the Upgrading Existing Gemini Databases section."

Goes to a blank section?

These are the errors I get when running Upgrade_v2-1.sql on a working 2.0.1 database.

Msg 4701, Level 16, State 1, Line 8
Cannot find the object "geminiinstall" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 3
Cannot find the object "issues" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 3
Cannot find the object "projectresource" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "issuestatetransitionlut" because it does not exist or you do not have permissions.



PaulS
· 1
PaulS
helpful
0
not helpful

Which document is that? See http://www.countersoft.com/Downloads/Installing%20Gemini.pdf

Please make sure that you run the scripts using the correct user name and database name.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Sorry I was running against 'master' by mistake. The scripts ran without error when run on the correct db.
SSMS ui is unclear sometimes.



PaulS
· 1
PaulS
helpful
0
not helpful

This link is on page 20 and goes to a blank section. I finally found the section on page 25.


PaulS
· 1
PaulS