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.




Error while upgrading from 2.02 --> 3.5.3

migration

I have executed the scripts "Upgradev2-1-sql", "Upgradev2-2.sql", "CreateTables.sql", "CreateViews.sql", "CreateProcs.sql" but when I run the script "Upgradev3-0-step1.sql I get the following error.

"Server: Msg 2627, Level 14, State 1, Line 69
Violation of PRIMARY KEY constraint 'geminiissuetypestypeidpk'. Cannot insert duplicate key in object 'geminiissuetypes'.
The statement has been terminated.
Server: Msg 515, Level 16, State 2, Line 76
Cannot insert the value NULL into column 'seq', table 'Gemini.dbo.geminiissuetypes'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Server: Msg 515, Level 16, State 2, Line 77
Cannot insert the value NULL into column 'seq', table 'Gemini.dbo.gemini
issuetypes'; column does not allow nulls. INSERT fails.
The statement has been terminated."

What do I do?

Brgs

RF

MPS
· 1
MPS
Replies (2)
helpful
0
not helpful

Please check your old issue types table, it looks like you have some duplicates in there.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Yes, it did the trick.

Thanks

RF


MPS
· 1
MPS