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.




Update from 1.9.1. to 2.0.5

web-app

The Gemini manual (v 2.0.3) states that in order to update the database from 1.9.1 to 2.0.5, the following scripts have to be run:

Example 2: if you currently running v1.9.1, then you should run the following
scripts in the order specified: Upgradev1-9-1.sql  Upgradev2-0.sql.

When I run Upgradev1-9-1.sql, I get the following errors in Query Analyzer:

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.
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.

Am I correct, that I only have to run Upgradv2-0.sql to update from 1.9.1?

Thanks and best regards,
Martin
mbischoff
· 1 		mbischoff
Friday, June 30, 2006, 5:34:53 PM
Replies (3)
helpful
0
not helpful

Yes, please do not forget to run the create_procs.sql script at the end.
Saar Cohen
· 5000 		Saar Cohen
Friday, June 30, 2006, 11:58:43 PM
helpful
0
not helpful

Thanks for the confirmation.

After the update, I found out that one of my applications which is using the gemini web service no longer works. Is there any documentation about the changes made to the web service?

Must I expect more breaking changes to the web service for future releases, or should the web service interface be stable (or at least backwards-compatible)?

Best regards,
Martin
mbischoff
· 1 		mbischoff
Sunday, July 2, 2006, 10:46:00 PM
helpful
0
not helpful

There are no major changes to the web service its location and name were changed.
Mark Wing
· 9108 		Mark Wing
Monday, July 3, 2006, 10:17:22 AM