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.




Migratration from 2.2.6 to 3.1.1 -- foreign key constraint

web-app

Following the migration steps as illustrated in the migration guide on page 5 - I received the following server error after executing the UpgradeV3-0-Step1.sql.

Server: Msg 547, Level 16, State 1, Line 406
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'gemini
timetrackingprojectidfk'. The conflict occurred in database 'devGemini', table 'geminiprojects', column 'projectid'.
The statement has been terminated.

Do I need to work around this constraint as highlighted in other solution posts related to foreigh key constraints - or do am I experiencing something unique.

Thank you...

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

Yes, seems like you have logged time for a project that does not exists anymore.


Mark Wing
· 9108
Mark Wing