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.




error on many pages (view Issue, add Issue, etc...)

web-app

i have done the install correctly

the error report says: [ADOException: could not execute query
[ SELECT this.ItemID as ItemID330, this.UserID as UserID330, this.ProjectID as ProjectID330, this.IssueAttribute as IssueAtt4330, this.CustomFieldID as CustomFi5330, this.DisplayOrder as DisplayO6330, this.tstamp as tstamp330 FROM userissuesview this_ WHERE this.UserID = ? and this.ProjectID = ? ORDER BY this.DisplayOrder asc ]
Positional parameters:   0 1
  0 3

i check, there is no userissuesview   in views in SQL gemini databse

i check in manual scrpits, there is no such view in CreateViews.sql

so???
yohm31
· 1 		yohm31
Thursday, January 31, 2008, 5:57:55 PM
Replies (5)
helpful
0
not helpful

Did you do a manual install ? Is this an upgrade?

It seems that your database does not contain certain tables.

Userissuesview is a table is it in the database? Check the owner of the Gemini objects.
Saar Cohen
· 5000 		Saar Cohen
Thursday, January 31, 2008, 7:23:46 PM
helpful
0
not helpful

yes, the table Userissuesview   actually exists

no, this is not an update

the error cam from the SQL script that use Pascal Casing, while in the databse all columns are named in lowercase

so the error is:


Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'UserID'.
Invalid column name 'ProjectID'.
Invalid column name 'ItemID'.
Invalid column name 'UserID'.
Invalid column name 'ProjectID'.
Invalid column name 'IssueAttribute'.
Invalid column name 'CustomFieldID'.
Invalid column name 'DisplayOrder'.
Invalid column name 'DisplayOrder'.

beceause of the case of the column name.

so where is the error, from the SQL scripts that creates the column in lowercase , or from your .Net code  (NHibernate is doing O/R mapping for you) that use Pascal Case instead of lower case....?

 

btw, I use SQL srv 2005, dev edition,  collation is FRCSAS
yohm31
· 1 		yohm31
Monday, February 4, 2008, 12:34:52 PM
helpful
0
not helpful

ok, i've changed the collation of my db  to  LATINCIAI

and now it works!

 

but you should indicate it in your installation manual

and i guess it's better if you review your code for problem with case between sql scripts and .Net code.

cheers

Guillaume.

 
yohm31
· 1 		yohm31
Monday, February 4, 2008, 1:09:41 PM
helpful
0
not helpful

http://www.countersoft.com/Downloads/Installing%20Gemini.pdf section 4 (page 7)
Mark Wing
· 9108 		Mark Wing
Monday, February 4, 2008, 2:01:24 PM
helpful
0
not helpful

;)

RTFM... correct?

 

sorry.
yohm31
· 1 		yohm31
Thursday, February 7, 2008, 4:58:30 PM