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.




Gemini Upgrade from v1.9.1 to v2.0.3

web-app

Hi all,

referring to user manual I am upgrading Geminiv1.9.1 to v2.0.3. As mentioned, I executed Upgrade_v1-9-1 script on Gemini database and I got following error:

Server: Msg 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'projarchived' in table 'projects' is specified more than once.
Server: Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'lookupsortfield' in table 'customfielddefs' is specified more than once.

Can anyone suggest why this is so and what should I do? Thanks in advance...

Manisha
Manisha
· 1 		Manisha
Thursday, May 11, 2006, 10:24:54 AM
Replies (3)
helpful
0
not helpful

You are already on 1.9.1, so you do not need to run that script!
Mark Wing
· 9108 		Mark Wing
Thursday, May 11, 2006, 10:41:08 AM
helpful
0
not helpful

Thanks.

I executed 'Upgradev2-0' script directly and it was successful.

When I moved to next step and executed 'CreateProcs.sql' I got following message.

"Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'gemini_projreposdeletenode'. The stored procedure will still be created."

any clues on this? Thanks in advance.

Manisha

 

 

 
Manisha
· 1 		Manisha
Thursday, May 11, 2006, 11:08:45 AM
helpful
0
not helpful

You can safely ignore this warning message.
Mark Wing
· 9108 		Mark Wing
Thursday, May 11, 2006, 11:30:49 AM