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.




Gemini Install: 4.0 to 5.2 Missing Database Objects

install
database

The database installation scripts are failing on the upgrade_v4-1.sql script due to the following errors:

Msg 1767, Level 16, State 0, Line 3

Foreign key 'geminiadmappingsglobalgroupsfk' references invalid table 'geminiglobalgroups'.

Msg 1750, Level 16, State 0, Line 3

Could not create constraint. See previous errors.

It appears that the referenced table is missing from our 4.0 installation for whatever reason. I need to know how to correct the problem so that I can complete the upgrade.

Thank you.
User77411
· 1 		User77411
Monday, November 5, 2012, 1:45:01 PM
Replies (2)
helpful
0
not helpful

It seems like you are running the scripts in the wrong database / schema. Can you please check that?
Mark Wing
· 9108 		Mark Wing
Monday, November 5, 2012, 3:18:03 PM
helpful
0
not helpful

That was the issue. The database account that I was using was defaulting to a different schema. Thank you for the quick response.
User77411
· 1 		User77411
Monday, November 5, 2012, 7:45:53 PM