Problem Upgrade from 2.1.1 to 3.0.3
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 |
|
Wednesday, June 25, 2008, 11:32:17 AM |
0
|
Run all the upgrade scripts first. |
||||
|
0
|
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 |
||||
|
0
|
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. |
||||
|
0
|
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? |
||||
|
0
|
Please check that the Gemini sql user has permissions on the Gemini tables and stored procedures. |
||||
|
0
|
I have verified the access. No luck on that, any other idea will be much appreciated. Thanks. |
||||
|
0
|
Are you running on vista? Can you please check the gemini error log table and windows event log? |
||||
|
0
|
Can you see if the table geminiprojects has a field called "fieldvisibilityschemeid" |
||||
|