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.




Error while upgrading Gemini database from 3.0.4 to 3.5.3

web-app

I get this error when running the script CREATEPROCS.sql (Step 3). What's wrong? Should I ignore it?


Msg 207, Level 16, State 1, Procedure gemini
getprojectsummaryfutureversions, Line 24
Invalid column name 'startdate'.
Msg 207, Level 16, State 1, Procedure geminigetprojectsummaryfutureversions, Line 24
Invalid column name 'releasedate'.
Cannot add rows to sys.sql
dependencies for the stored procedure because it depends on the missing table 'geminigetprojectsummaryfutureversions'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 207, Level 16, State 1, Procedure gemini
deleteissuetimetype, Line 8
Invalid column name 'timetypeid'.

stepand76
· 504
stepand76
Replies (4)
helpful
0
not helpful

Did you run the upgrade 3.1 and 3.5 scripts before running this one?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I run these scripts as described in documentation (Chapter 8.2).

Step
Action
1
Execute “UPGRADEv3-1.sql” in Gemini Issues Database
2
Execute “CREATE
VIEWS.sql” in Gemini Issues Database
3
Execute “CREATE_PROCS.sql” in Gemini Issues Database

There is nothing about 3.5 scripts. What is the right sequence?


stepand76
· 504
stepand76
helpful
0
not helpful

Ok, the document is a bit misleading. You need to run 3.1, 3.5 , views and procs.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thanks. Now it works for me.


stepand76
· 504
stepand76