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.




DB upgrade from 3.1 to 3.5

web-app

Hello there, i'm getting an error message on upgrading 3.1.0 to 3.5.

The actual Upgradev3-5.sql file ran no issues with that, but when i ran CreateViews.sql i get this:

Msg 207, Level 16, State 1, Procedure geminiissuesview, Line 25 Invalid column name 'originatortype'. Msg 207, Level 16, State 1, Procedure geminiissuesview, Line 26 Invalid column name 'originatordata'. Msg 207, Level 16, State 1, Procedure geminiissuesview, Line 27 Invalid column name 'originatorreply'. Msg 207, Level 16, State 1, Procedure geminiissuesview, Line 28 Invalid column name 'originatorprocessed'.

Am i missing something?
mumbles
· 1 		mumbles
Wednesday, February 10, 2010, 1:42:16 PM
Replies (2)
helpful
0
not helpful

Please run all upgrade files first (3.5 and 3.6) and only run the create_views and procs.sql at the end.
Mark Wing
· 9108 		Mark Wing
Wednesday, February 10, 2010, 1:43:28 PM
helpful
0
not helpful

Thanks, that did it. I don't know why, but i never can seem to get this sequence right. I think it's because when i look at the documentation, it makes me think i need to follow the steps for each upgrade. Step 1,2,3 etc.


mumbles
· 1 		mumbles
Wednesday, February 10, 2010, 2:02:10 PM