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 Application Error

web-app

I downloaded the latest version of Geminiv211 and tried installing but get the following errors:
    Errors executing installcommons.sql script
    Errors executing installprofile.sql script

I run the install until the end (ignoring the above sql errors), then login with a new userid.
but when I click on All Issues for some of the projects in gemini I get the following error message.

Gemini Application Error
An application error has occured - please advise the Gemini administrator within your organisation.

Then I tried executing the installCommon.sql in SQL Server Management Studio but get a error message in following place

DECLARE @command nvarchar(4000)

SET @command = 'GRANT EXECUTE ON [dbo].aspnetSetup_RestorePermissions TO ' + QUOTENAME(user)
EXEC (@command)

Any help would be appreciated.

Thanks, liu
liuxn
· 1 		liuxn
Thursday, July 19, 2007, 8:26:23 AM
Replies (6)
helpful
0
not helpful

What is the error message? What OS is it on?
Mark Wing
· 9108 		Mark Wing
Thursday, July 19, 2007, 11:11:02 AM
helpful
0
not helpful

I got a error message from SQL Server :

Cannot grant, deny, or revoke permissions to sa, dbo, information_schema, sys, or yourself.

I installed Gemini system on windowsxp sp2, the db is sqlserver2005 and framework 2.0.

 

Thanks.
liuxn
· 1 		liuxn
Friday, July 20, 2007, 7:47:08 AM
helpful
0
not helpful

You can ignore this message.


Mark Wing
· 9108 		Mark Wing
Friday, July 20, 2007, 11:34:33 AM
helpful
0
not helpful

When i click any button in gemini, it always jump to a error page as follow:
Gemini Application Error
An application error has occured - please advise the Gemini administrator within your organisation.

Therefore I thought possibly the sql error which in the installation process causes this problem.

Thanks
liuxn
· 1 		liuxn
Thursday, July 26, 2007, 3:14:07 AM
helpful
0
not helpful

set custom errors to off in the web.config file to see the error.
Mark Wing
· 9108 		Mark Wing
Thursday, July 26, 2007, 10:33:49 AM
helpful
0
not helpful

great, it works fine.

i reinsatalled the app, and add the windowos user ASPNET to sqlserver user as db_owner for GEMINI database. then add full control permission of GENIMI folder to ASPNET. As your reply I ignore the error when i execute InstallCommon.sql and InstallProfile.SQL in SQL Query. yes,Not any influence.

thank you very much.
liuxn
· 1 		liuxn
Friday, July 27, 2007, 5:33:08 AM