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.




Fresh install Gemini 3.7 with 3.1 db?

web-app

I am planning to use the 3.1 database and install the Gemini 3.7 web application on a brand new server.
Is that possible? I have data in the 3.1 database that I don't want to lose and want to carry it over to the 3.7 system.

I am using the 3.1 database and gemini 3.1 web.  This configuration is still in use and just want to migrate one project on 3.1 to new system that I mentioned above.

If it's possible, can you please tell me the steps? Or if there is better approach to accomplish this?

Thanks!

kha
· 1
kha
Replies (3)
helpful
0
not helpful

Simply backup the database, restore it as a new database for 3.7, upgrade it to 3.7 and point 3.7 to it.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I followed the steps in the document, first step to run the "upgradev3-5.sql", after running the script, it gave me this error:

Msg 4701, Level 16, State 1, Line 10
Cannot find the object "gemini
install" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 5
Invalid object name 'geminiapplicationsettings'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'gemini
applicationsettings'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'geminiapplicationsettings'.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'gemini
mailboxprocessorprojectidfk' references invalid table 'geminiprojects'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4902, Level 16, State 1, Line 5
Cannot find the object "gemini
versions" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "geminiversions" because it does not exist or you do not have permissions.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'gemini
versionmilestoneversionidfk' references invalid table 'geminiversions'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4902, Level 16, State 1, Line 5
Cannot find the object "gemini
personalfilters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "geminipersonalfilters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "gemini
personalfilters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "geminipersonalfilters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "gemini
personalfilters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "geminipersonalfilters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "gemini
personalfilters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 5
Cannot find the object "geminitimetracking" because it does not exist or you do not have permissions.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 1767, Level 16, State 0, Line 2
Foreign key 'gemini
reportsvisibilityprojectidfk' references invalid table 'geminiprojects'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'gemini
projects'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'geminiprojects'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'gemini
projects'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'geminiprojects'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'gemini
projects'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'geminiprojects'.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'gemini
savedreportsprojectidfk' references invalid table 'geminiprojects'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "gemini
issues" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'gemini_projectresources'.


kha
· 1
kha
helpful
0
not helpful

Seems like the owner of the database objects (tables etc..) is not the one you logged on as.
Please check the owenr of the tables.


Saar Cohen
· 5000
Saar Cohen