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.




More DB Upgrade Woes 2.02 to 3.51

migration

Similar to mbischoff, I'm getting some interestingerrors on the final step of upgrading my database to 3.51.

Again, it's on the Upgradev3-0-Step1.sql step.
I ran (in order)

  1. Upgradev2-1.sql
  2. Upgradev2-2.sql
  3. CreateTables.sql
  4. CreateViews.sql
  5. CreateProcs.sql
  6. Upgradev3-0-Step1.sql
And got the following error:
Msg 547, Level 16, State 0, Line 251
The INSERT statement conflicted with the FOREIGN KEY constraint "geminiprojectversionattributesvaluesversionidfk". The conflict occurred in database "geminidevl", table "dbo.geminiversions", column 'versionid'.
The statement has been terminated.

and I'll be honest, I'm not quite sure what to do to fix this before we proceed.

Any advice gratefully accepted!
johnparker
· 1 		johnparker
Wednesday, July 8, 2009, 9:23:29 AM
Replies (2)
helpful
0
not helpful

It seems like you have a project version attribute value for a non-existing version in the projectversionattributesvalues table.

remove the row where the version id is not in the versions table.
Mark Wing
· 9108 		Mark Wing
Wednesday, July 8, 2009, 9:57:01 AM
helpful
0
not helpful

Cheers for that! Removed the offending rows and it looks good to go!
johnparker
· 1 		johnparker
Thursday, July 9, 2009, 6:04:23 AM