SQL Error during database migration (Gemini 2.1.1 to 3.7.2)
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 |
|
Friday, September 24, 2010, 10:18:00 AM |