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.




Database upgrade issues from 2.0.5 to 3.0

web-app

Trying to upgrade from version 2.0.5 to 3.0.  On step #3 of v2.0.x upgrade in the documentation, section 8.3.  When running createviews.sql it's missing several tables.  (see error message below).  Also the documentation is mentioning  INSTALLCOMMON.SQL and INSTALLPROFILE.SQL, but I didn't find those files in the ZIP file download.

 

Error messages after running CreateViews.sql

Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issuevotes'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issues'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issuetypes'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issuepriorities'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issuestatus'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issueresolutions'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
projects'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
users'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
versions'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issuerisklevels'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issueseverity'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issuepriorityschemeitems'.
Server: Msg 208, Level 16, State 1, Procedure geminiissuesview, Line 2
Invalid object name 'gemini
issueseverityschemeitems'.

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

You need to run  createviews and createprocs once only after the final upgrade script to 3.0.

InstallCommon and Profile are not needed.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I'm running the scripting as specified by 8.3 (page 9) of the documentation.  Are there other scripts that I need to run? 

In the ZIP file I see the Upgradev3-0-Step1.sql, Upgradev3-0-Step2.sql and Upgradev3-0-Step3optional.sql.  When do they need to be run? 

Thanks,

Rick...


rwilkerson
· 1
rwilkerson
helpful
0
not helpful

Nevermind...I switch from following the ugprade instructions to the migration guide and things are going more smoothly.


rwilkerson
· 1
rwilkerson
helpful
0
not helpful

You need to run upgrade to 2.1, upgrade to 2.2 and then follow the upgrade instructions to 3.0.


Saar Cohen
· 5000
Saar Cohen