I think i know why i got the problem.
I did not run the Upgradev3-5.
What should I do to fix this problem (other than restored the db)? Tried to run the Upgradev3-5 script, then createview, follow by createprocs. However, I still have the same problem. Actually when I ran the Upgradev3-5, I got the follow error:
(1 row(s) affected)
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'startdate' in table 'geminiversions' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'releasedate' in table 'geminiversions' is specified more than once.
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'reportedbyuserid' in table 'geminipersonalfilters' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'initialstartdate' in table 'geminipersonalfilters' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'finalstartdate' in table 'geminipersonalfilters' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'initialduedate' in table 'geminipersonalfilters' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'finalduedate' in table 'geminipersonalfilters' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'savedfromreports' in table 'geminipersonalfilters' is specified more than once.
Msg 3728, Level 16, State 1, Line 1
'geminipersonalfiltersreportedbyuserdef' is not a constraint.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.
Msg 3726, Level 16, State 1, Line 5
Could not drop object 'geminiissuetimetype' because it is referenced by a FOREIGN KEY constraint.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'geminiissuetimetype' in the database.
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'timetypeid' in table 'geminitimetracking' is specified more than once.
(0 row(s) affected)
Msg 1913, Level 16, State 1, Line 3
The operation failed because an index or statistics with name 'indgeminiissuesparentissueid' already exists on table 'gemini_issues'.