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.




Problem Upgrade from 2.1.1 to 3.0.3

web-app

Hello,

I have installed Gemini web version 2.1.1 and I would like to upgrade my Gemini to the latest 3.0.3 version.

I download the file "CounterSoftGeminiv303.zip", and follow the procedures in "GeminiInstallationGuide.pdf", section 8.5 "v2.1.x" insctructions. My status:

1. Execute “UPGRADEv2-2.sql” in Gemini Issues Database - Success

2. Execute “CREATEVIEWS.sql” in Gemini Issues Database - Failed

3. Execute “CREATE_PROCS.sql” in Gemini Issues Database - Success

Can you suggest what was I doing wrong? Thanks

 

mkgan
· 1
mkgan
Replies (8)
helpful
0
not helpful

Run all the upgrade scripts first.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

It is very confusing as I 'suddently' found another document 'GeminiMigrationGuide.pdf' and it mention that I should upgrade my database to 2.2 first.

Can you please confirm that is what I need to do prior to 3.0.3?

 

Thanks


mkgan
· 1
mkgan
helpful
0
not helpful

You need to upgrade the database in stages.

From 2.1.1 to 2.2 to 3.0 etc... Run only the upgrade scripts (except when upgrading to 3.0 you will need to run the create tables.script).

At the end run create_procs and views.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hey, I have updated to 3.0.3, but i have a difficulty to login to my system (web interface), it seems like a infinite loop on the browser. I have set the database setting in web.config correctly, any other hints?


mkgan
· 1
mkgan
helpful
0
not helpful

Please check that the Gemini sql user has permissions on the Gemini tables and stored procedures.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I have verified the access. No luck on that, any other idea will be much appreciated. Thanks.


mkgan
· 1
mkgan
helpful
0
not helpful

Are you running on vista?

Can you please check the gemini error log table and windows event log?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Can you see if the table geminiprojects has a field called "fieldvisibilityschemeid"

if it does not please run this SQL - it fixed my looping issue

ALTER TABLE gemini
projects ADD fieldvisibilityschemeid NUMERIC(10,0) NOT NULL CONSTRAINT geminiprojectsfieldvisibilityschemeid_def DEFAULT (0)

Thanks


Simon@MailboxPro
· 1
Simon@MailboxPro