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.




SQL Error during database migration (Gemini 2.1.1 to 3.7.2)

web-app

I created an entry with all the details there : http://gemini.countersoft.com/issue/ViewIssue.aspx?ID=4167&PROJID=2

But to summurize : After executing “UPGRADE_v3-0-Step1.sql” in Gemini Issues Database

I have the following : Msg 547, Niveau 16, État 0, Ligne 307 The INSERT statement conflicted with the FOREIGN KEY constraint "geminiissuevotesuseridfk". The conflict occurred in database "GEMINI", table "dbo.geminiusers", column 'userid'.

For : DELETE FROM geminiissuevotes SET IDENTITYINSERT geminiissuevotes ON INSERT INTO geminiissuevotes (voteid, issueid, userid, created) SELECT voteid, issueid, userid, created FROM issuevotes WHERE issueid IN (SELECT issueid FROM geminiissues) SET IDENTITYINSERT gemini_issuevotes OFF

(0 ligne(s) affectée(s)) Msg 547, Niveau 16, État 0, Ligne 262 The INSERT statement conflicted with the FOREIGN KEY constraint "geminiprojectversionattributevaluesattributeidfk". The conflict occurred in database "GEMINI", table "dbo.geminiprojectversionattributes", column 'attributeid'. The statement has been terminated. SET IDENTITYINSERT geminiprojectversionattributevalues ON INSERT INTO geminiprojectversionattributevalues (attributevalueid, attributeid, projectid, versionid, attributevalue) SELECT attributevalueid, attributeid, projid, verid, attributevalue FROM projectversionattributevalues SET IDENTITYINSERT gemini_projectversionattributevalues OFF

This is a show stopper because as long as we don't fix this we won't be able to go live

Sano
· 1
Sano
Replies (1)
helpful
0
not helpful

You seem to have some votes from users that have been deleted, delete those votes.
The same applies to the project attributes values (atrribute does not exist).


Mark Wing
· 9108
Mark Wing