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.




Create SQL Errors during install

web-app

I have tried installing Gemini but get the following errors:
    Errors executing createtables.sql script
    Errors executing createviews.sql script
    Errors executing createprocs.sql script
    Errors executing createsampledata.sql script
    Errors executing installcommons.sql script
    Errors executing installprofile.sql script

These are just message boxes, there is no additional detail (such as a log file) and no additional information that my indicate what the error is.

When I look at the database, it appears that additional tables specific to Gemini have been created.

From the program menu, the only option is uninstall, I cannot execute Gemini at all.

Not a very good first time experience with the software.

Any help would be appreciated.

Thanks, Kenn
Minear
· 1 		Minear
Monday, May 14, 2007, 6:02:32 PM
Replies (10)
helpful
0
not helpful

Please make sure that you have entered the server name for the SQL server and not "local" or "localhost".

If that still fails, then you can do a manual install by running the scripts from the Database directory, which by default is: c:\Program Files\CounterSoft\Gemini Project Issue Tracking\Database

The web app should be installed and the virtual directory should have been created.
Mark Wing
· 9108 		Mark Wing
Monday, May 14, 2007, 6:07:10 PM
helpful
0
not helpful

Thank you for your reply...

I don't think that the sql scripts are the problem... even if I run them; how do I create an executable?

The only object installed is the unistaller...

Thanks, Kenn
Minear
· 1 		Minear
Tuesday, May 15, 2007, 12:11:27 AM
helpful
0
not helpful

Did you run the install until the end (ignoring the sql errors)?

If so, then the installer should have created the folders as described earlier.

You can also download the zip from our site and do the manual install.
Saar Cohen
· 5000 		Saar Cohen
Tuesday, May 15, 2007, 12:42:33 AM
helpful
0
not helpful

I did run until the end.  My problem is not so much with the sql scripts (I can run those seperately if needed)... but that I don't have an executable program  after the install (other than uninstall).  If you could help me install a program that will run Gemini I would certainly appreciate it. 

Thanks, Kenn
Minear
· 1 		Minear
Tuesday, May 15, 2007, 4:18:08 AM
helpful
0
not helpful

By the way, I did use server/instance when installing.  I originally started using SQL Server 2000, but when I first encountered this problem, I downloaded SQL Server 2005 Express Edition.
Minear
· 1 		Minear
Tuesday, May 15, 2007, 5:14:32 AM
helpful
0
not helpful

Do you have IIS installed on the machine?
Mark Wing
· 9108 		Mark Wing
Tuesday, May 15, 2007, 10:09:43 AM
helpful
0
not helpful

Yes, I have IIS5 running.  Trying the desktop app, but am unable to login using admin/admin (invalid login).  I did rerun the sql scripts sucessfully.  Thanks for any help.

Kenn
Minear
· 1 		Minear
Wednesday, May 16, 2007, 4:38:50 AM
helpful
0
not helpful

The desktop app works with the web app. So you have got to get the web app up and running before you can use the desktop app.

Suggest you download the zip and do a manual install of the web app: http://www.countersoft.com/Downloads/CounterSoftGeminiv211.zip
Mark Wing
· 9108 		Mark Wing
Wednesday, May 16, 2007, 10:09:29 AM
helpful
0
not helpful

Thanks,

IIS is a new environment for me, I am mainly desktop and mainframe.

I finally did get the web app to work, by:

1.  Ran the SQL scripts against the database seperately (still don't know why I got the errors during the install).
2.  Changing messages to RemoteOnly (so I could see the actual errors).
3.  Errors indicated unable to logon with userid <machine name>/ASPNET.
4.  Created login ASPNET and granted access to Gemini database.
5.  Still got login error.
6.  Changed Web Config to use Windows Security.

It now works (at least through the web session).

I've tried the desktop app and I still get an invalid logon message, whether I use admin/admin or Windows Security to logon.

Thank you so much for your patience.  Now I can have some fun exploring the product to see how useful it will be to our organization.

Thanks, Kenn
Minear
· 1 		Minear
Thursday, May 17, 2007, 3:27:47 AM
helpful
0
not helpful

Thanks for the update.

Please check that you have Microsoft WSE 3.0 for the desktop app to work.
Mark Wing
· 9108 		Mark Wing
Thursday, May 17, 2007, 10:34:57 AM