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 3.1beta: Index was outside the bounds of the array.

web-app

I clicked on one of the components and it leads me to this error:

Server Error in '/Gemini' Application.
--------------------------------------------------------------------------------

Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:


[IndexOutOfRangeException: Index was outside the bounds of the array.]
   CounterSoft.Gemini.Web.Controls.IssuesFilterUC.BindNestedComponents(DataTable data) +620
   CounterSoft.Gemini.Web.Controls.IssuesFilterUC.Page_Load(Object sender, EventArgs e) +12795
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

kha
· 1
kha
Replies (19)
helpful
0
not helpful

same error when I clicked on: All Issues, Resources name on the Resources List, Unassigned, All links under Issue by Types (Status, Priority, etc.)


kha
· 1
kha
helpful
0
not helpful

Fixed!


Harvey Kandola
· 212
Harvey Kandola
helpful
0
not helpful

where is the fix? next build?


kha
· 1
kha
helpful
0
not helpful

Yes, it will be fixed in the next build / release.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

We're using 3.1.0 (build 2179) which I believe is not a beta and still have this issue.


abcdigital
· 1
abcdigital
helpful
0
not helpful

Did you run the create_procs.sql script in your database?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

This is a 3.0.4 upgraded database. Ran only:

Upgrade_v3-1.sql

Something else I need to do?


abcdigital
· 1
abcdigital
helpful
0
not helpful

Yes, run createprocs.sql and createviews.sql


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Great! Works! Thanks!


abcdigital
· 1
abcdigital
helpful
0
not helpful

My current db is 3.0.4, i ran:

createtables.sql
create
views.sql
createprocs.sql
upgrade
v3-1.sql
and got this error:

(1 row(s) affected)

(1 row(s) affected)
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'parentcomponentid' in table 'geminicomponents' is specified more than once.
Msg 3726, Level 16, State 1, Line 5
Could not drop object 'gemini
projectlabels' because it is referenced by a FOREIGN KEY constraint.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'geminiprojectlabels' in the database.
Msg 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'projectlabelid' in table 'gemini
projects' is specified more than once.
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'apikey' in table 'gemini_users' is specified more than once.


kha
· 1
kha
helpful
0
not helpful

You should not run create tables.sql if your DB is 3.0.x.

You will have to restore and run upgrade 3.1 followed by views and procs.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thanks, I will try that with my staging which is currently 3.0.4

------------------------------------------------------------------------------
If i have db 2.0.3, what are the scripts i should run and in what order ?

createtables
create
views
createprocs
upgrade
v3.0-step1
upgradev3.0-step2
upgrade
v3-1

Is that the right order?  I just ask in case because later on I will need to move the gemini production (2.0.3) database to the new sql server and upgrade it to latest gemini version (3.1)


kha
· 1
kha
helpful
0
not helpful

You need to uprade to 2.2 first then create tables and upgrade 3.0 step 1 and step 2 followed by 3.1

Only at then end run create views and procs.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

can we move components around with gemini 3.1?


kha
· 1
kha
helpful
0
not helpful

No, but you can bulk move issues.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I seem can bulk move the issues to different component of different project (not to different component of the same project).  Is that how it work?

Do you plan to have component move feature in the next version of gemini?


kha
· 1
kha
helpful
0
not helpful

Feel free to add it to our list: http://gemini.countersoft.com

 


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I followed your steps until upgradev3.1.sql script (all the scripts before that ran fine), i ran it and got this error:

Msg 4902, Level 16, State 1, Line 5
Cannot find the object "gemini
components" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "geminiprojects" because it does not exist or you do not have permissions.
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'apikey' in table 'gemini
users' is specified more than once.


kha
· 1
kha
helpful
0
not helpful

From which version are you upgrading?

Also, make sure you run the procedures under the same user as Gemini.


Saar Cohen
· 5000
Saar Cohen