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 when upgrading from 2.2.6 to 3.5.4

migration

I ran:

CreateTables.sql

CreateViews.sql

CreateProcs.sql

Each completes without error.  When running

Upgradev3-0-Step1.sql

I get the error

Msg 208, Level 16, State 1, Line 36

Invalid object name 'errorlog'.

 

Looks to me like the tables were not created during the first script, but create_tables says "script completed successfully"

 

Suggestions? (All scripts run as sa)
TCooper
· 1 		TCooper
Sunday, November 1, 2009, 9:26:39 PM
Replies (3)
helpful
0
not helpful

errorlog is part of the old 2.2.6 tables. It might be that it is under a different owner.

Can you please check that?
Mark Wing
· 9108 		Mark Wing
Monday, November 2, 2009, 9:02:54 AM
helpful
0
not helpful

I'm a total dope.  I repeatedly forgot to select the Gemini DB before hitting "execute" in Sql Server Management Studio. 

 

If the schema updates are applied to the wrong DB, you get wrong results.

 

Fixed now....

 

Thanks
TCooper
· 1 		TCooper
Tuesday, November 3, 2009, 2:57:29 PM
helpful
0
not helpful

Thanks for the update. It was Monday after all....
Mark Wing
· 9108 		Mark Wing
Tuesday, November 3, 2009, 3:34:05 PM