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.




v3.5.3: Error when switch to different project using "Select project" drop down box

web-app

I am working on a Gemini 3.5.3 staging setup.  The db is the copy of Gemini 3.1.0.  The Web application is on a brand new server, and fresh installed from gemini zip file.

I unzipped the downloaded gemini file, copy the content of Gemini Web Application folder to c:\program files\countersoft\Gemini Web Application folder

The db is on different sql server, i ran the three scripts:  createtable, createviews, create_procs (in that order).

Now, every time I swith to different project using the "Select Project" drop down box, it gives me this error:

Gemini Application Error

An application error has occured - please advise the Gemini administrator within your organization.

Error Log:
Invalid column name 'savedfromreports'. Invalid column name 'reportedbyuserid'. Invalid column name 'initialstartdate'. Invalid column name 'finalstartdate'. Invalid column name 'initialduedate'. Invalid column name 'finalduedate'. Invalid column name 'savedfromreports'.

 

kha
· 1
kha
Replies (2)
helpful
0
not helpful

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 'gemini
versions' 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 'gemini
personalfilters' 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 'gemini
personalfilters' 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 'gemini
personalfilters' 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
'gemini
personalfiltersreportedbyuserdef' 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 'gemini
issuetimetype' 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 'ind
geminiissuesparentissueid' already exists on table 'gemini_issues'.


 


kha
· 1
kha
helpful
0
not helpful

Seems like you have ran the script twice.

Please restore and run 3.5 upgrade followed by create views and procs.


Saar Cohen
· 5000
Saar Cohen