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.




Upgrade 1.8 to 2.0.5

web-app

I'm making a trial upgrade from 1.8 to the latest 2.0.5. I restored the database on my local machine and run all the upgrade files:
Upgradev1-8.sql
Upgradev1-9.sql
Upgradev1-9-1.sql
Upgradev2-0.sql
CreateProcs.sql

(in a desperate try I also run CreateTables.sql and Create_Views.sql)
My problem is that when I log on, it seems to get stuck on Default.aspx?x=1 and the table errorlog is filled with:     45411    Index was outside the bounds of the array.    "   at CounterSoft.GeminiBiz.33c10d769b8bcf93.48e77a23dc9d1a1d(String 1894643d4df24f5c)
   at CounterSoft.GeminiBiz.33c10d769b8bcf93.ConstructCustomPrincipal(IIdentity id)
   at Gemini.GeminiHttpModule.1eed083ca172ff13(Object 0a6d217695a16242, EventArgs c2e04712c11fa2d9)"        2006-06-28 09:59:38

Im using MSDE 2000 SP4 and XP SP2 and the new Gemini was installed with the installer. It seems that I'm not the only one with the problem but I really need this to work since we use Gemini A LOT...

The new web.config was just updated with the connectionstrings. I use forms to authenticate.

Any ideas?
jbn
· 1 		jbn
Wednesday, June 28, 2006, 10:10:18 AM
Replies (10)
helpful
0
not helpful

Which web.config file are you using?

If it is the old one that please use the new one...
Mark Wing
· 9108 		Mark Wing
Wednesday, June 28, 2006, 10:39:51 AM
helpful
0
not helpful

I'm using the new one. Sorry for the unclear message...
jbn
· 1 		jbn
Wednesday, June 28, 2006, 10:47:56 AM
helpful
0
not helpful

Which version of the .NET framework are you using?
Saar Cohen
· 5000 		Saar Cohen
Wednesday, June 28, 2006, 9:33:22 PM
helpful
0
not helpful

I just remembered that I probably installed 2.0 the other day, maybe that's the problem. Not at work at the moment so I can't deinstall 2.0 and test... 
jbn
· 1 		jbn
Wednesday, June 28, 2006, 10:07:32 PM
helpful
0
not helpful

No, I checked and I'm running .Net framework 1.1.4322.

Today when I tried, I logged in and immediatly got the message that my session had expired and then when I logon again it just stands there, the errorlog is filled with "Index outside the bounds of the Array"
jbn
· 1 		jbn
Thursday, June 29, 2006, 8:50:08 AM
helpful
0
not helpful

Is your database empty?
Mark Wing
· 9108 		Mark Wing
Thursday, June 29, 2006, 10:07:19 AM
helpful
0
not helpful

No, everything was restored from the old one, then I ran all the upgrade scripts. When I check the tables they seem alright.

The following tables are empty: personalfilters, personalfiltersbeforeupgrade, projectattributes, projectrepository, projectversionattributes, projectversionattributevalues, sourcecontrolissuefiles, timetracking, userissuesview, userroles

The above is probably empty because they didn't exist in previous installation which was 1.8
jbn
· 1 		jbn
Thursday, June 29, 2006, 10:16:20 AM
helpful
0
not helpful

Please check who is the owner of the gemini tables (in sql).

Also, run the follwoing stored procedure (user id is the parameter):

gemini_getuser 1

 

What do you get back?

 
Saar Cohen
· 5000 		Saar Cohen
Thursday, June 29, 2006, 7:40:58 PM
helpful
0
not helpful

userid username firstname surname pwd emailaddress created lastupdated roles
1 admin Jon Smith <BINARY> jon@smith.com 2004-11-16 10:35:23 2004-11-16 10:35:23 G!

When I check the owner in Visual Studio Server Explorer it says that it is dbo who is the owner of all tables.

My strategy is now as follows. I delete all tables in the database, restore it from the backup of the old database (1.8). Run the follwoing scripts in that order:

Upgradev1-8.sql
Upgradev1-9.sql
Upgradev1-9-1.sql
Upgradev2-0.sql
UnicodeUpgrade.sql
CreateProcs.sql
CreateViews.sql

Shall I run Create_Tables.sql too?

I'll try to do it now and see if it solves the problem.

 
jbn
· 1 		jbn
Friday, June 30, 2006, 8:32:37 AM
helpful
0
not helpful

YES!!!

that did the trick. I guess that when i made the upgrades of my database I must have made some misstake. Thank you for all your help anyway. Gemini is grrrrrrrreat.
jbn
· 1 		jbn
Friday, June 30, 2006, 8:47:39 AM