Home Home
  login

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.




Database upgrade failed - table already exists

database

We have just upgraded to v5.1.5. Our database guy sent me this message:

I have upgraded Gemini to version 5.1.5. However, the database upgrade failed with table already exists. So, the database upgrade may not have been required in the first place.

As far as I can see, all our entries are the same as before the upgrade.

But, if the database upgrade failed, does that mean that we are missing valuable database upgrades?

If so, what action should we take now?
OldGrantonian
· 200 		OldGrantonian
Thursday, January 24, 2013, 11:24:50 AM
Replies (3)
helpful
0
not helpful

From which version did you upgrade and which script gave errors? Send us the errors.
Mark Wing
· 9108 		Mark Wing
Thursday, January 24, 2013, 11:47:23 AM
helpful
0
not helpful

We upgraded from 5.1.1 to 5.1.5

The error message was:

There is already an object named 'geminiissuecomponents' in the database.CountersoftGeminiv51DatabasePackage1.resxBatch11CREATE TABLE [dbo].[geminiissuecomponents] ( [issuecomponentid] [numeric] (10, 0) NOT NULL IDENTITY(1, 1), [issueid] [numeric] (10, 0) NOT NULL, [componentid] [numeric] (10, 0) NOT NULL, [created] [datetime] NOT NULL CONSTRAINT [geminiissuecomponentscreated_def] DEFAULT (getutcdate()), [tstamp] [timestamp] NOT NULL )

So, to repeat my original question, is our database OK? :)
OldGrantonian
· 200 		OldGrantonian
Friday, January 25, 2013, 1:17:07 PM
helpful
0
not helpful

Ok, seems like you have run the installer which will not do. The database should be ok. Gemini will upgrade the database automatically when you start the site.
Mark Wing
· 9108 		Mark Wing
Friday, January 25, 2013, 1:19:30 PM