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.




Consistent error on "All projects issue reporting" link on main page

web-app

Hello,

We have been using Gemini in our small company for about two months, and it seems almost perfect for us. But today we have found a problem: after inserting several projects and issues, I try to access the screen "All projects issue reporting" (the link on the main page), and the system show me an error message:Gemini Application Error. An application error has occured - please advise the Gemini administrator within your organisation. View error log, If we clickon the link , we can see a error log page with the information: Error Message Stack Trace Additional Info. Dated Line 11: Incorrect syntax near ')'. at CounterSoft.GeminiBiz.7cdfe764c33c38b0.da6413aa03e2d6fb(FilterEN b0f684c47236959a, Boolean d837775771246a3f) at Gemini.XP_Issues.BindGrid()   03/04/2007 17:15:01   Could you please help us to find where the problem is?   Thank you very much in advance,   Josep.
jmasallera
· 1 		jmasallera
Tuesday, April 3, 2007, 5:36:02 PM
Replies (5)
helpful
0
not helpful

Any ideas what has chamged to cause this error?

Are you using 2.0.5?
Saar Cohen
· 5000 		Saar Cohen
Tuesday, April 3, 2007, 11:23:34 PM
helpful
0
not helpful

Yes I'm using 2.0.5, and I have no ideas about the error.
jmasallera
· 1 		jmasallera
Wednesday, April 4, 2007, 1:13:29 PM
helpful
0
not helpful

How many projects have you got?
Saar Cohen
· 5000 		Saar Cohen
Wednesday, April 4, 2007, 10:42:05 PM
helpful
0
not helpful

I'm getting this same error with 299 projects on v 2.0.5.
chuck.boyer
· 1 		chuck.boyer
Wednesday, October 29, 2008, 6:43:33 PM
helpful
0
not helpful

fixed the problem by changing the gemini_getxpfilterdissues

@projectIds varchar(1000) to varchar(4000)
@keywords nvarchar(1000) to nvarchar(4000)

declare @sql nvarchar(4000) to nvarchar(max) - we are using SQL 2005
chuck.boyer
· 1 		chuck.boyer
Wednesday, October 29, 2008, 6:46:37 PM