Upgrade to 2.2.3 fails.....
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 |
|
Thursday, October 18, 2007, 5:39:37 PM |