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.




Updating from 2.0.X to 3.0.4

web-app

Hi everyone, I'm trying to update our existing Gemini installation to 3.0.4.

However, when I run the Upgradev3-0-Step1.sql step it kicks the following error when trying to do the actual inserts for all the old issues in the issues table:

Msg 547, Level 16, State 0, Line 260
The INSERT statement conflicted with the FOREIGN KEY constraint "geminiissuesissuetypeidfk". The conflict occurred in database "Gemini", table "dbo.gemini_issuetypes", column 'typeid'.

Can anyone give me an idea of what I need to do to fix this so that it runs correctly?

Thanks,


Rene
rheroux
· 1 		rheroux
Tuesday, September 9, 2008, 4:07:10 PM
Replies (1)
helpful
0
not helpful

Seems like you have issues with type id that do not exist in the type table. You will have to update or exclude these issues.
Mark Wing
· 9108 		Mark Wing
Tuesday, September 9, 2008, 4:08:55 PM