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.




Upgrade to 2.2.3 fails.....

web-app

I was trying to upgrade to latest verion. Current version is 2.2. The installation guide does not provide ANY specific instructions on moving from this version to 2.2.3 so I followed DB upgrading steps for the highest version, 2.1.x. After running Upgrade v2-2.sql the database had many errors that some of the data corrupted. Here is the output of the SQL script update.


(1 row(s) affected)
Msg 2705, Level 16, State 4, Line 3
Column names in each table must be unique. Column name 'affectedversions' in table 'personalfilters' is specified more than once.
Msg 2705, Level 16, State 4, Line 3
Column names in each table must be unique. Column name 'comment' in table 'users' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'active' in table 'users' is specified more than once.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(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 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'resourcemode' in table 'projects' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'componentmode' in table 'projects' is specified more than once.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'compid'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'compid'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'compid'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'assignedto'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'assignedto'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'assignedto'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'constraint'.
Msg 3701, Level 11, State 7, Line 2
Cannot drop the index 'issues.ind_compid', because it does not exist or you do not have permission.
Msg 4924, Level 16, State 1, Line 2
ALTER TABLE DROP COLUMN failed because column 'assignedto' does not exist in table 'issues'.



pauldes
· 1
pauldes
Replies (1)
helpful
0
not helpful

You do not need to run this script. Only the createprocs.sql

Suggest you restore a backup and apply the createprocs.sql script only.


Saar Cohen
· 5000
Saar Cohen