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.




3.6 Upgrade - Can only see Home Page

web-app

I just upgraded our site from 3.5.3 to 3.6. The SQL script ran fine and changed the connection string. I can successfully login to the app and can see the homepage with all of my projects. But if I click into any issues list or even just bring up the System Log it errors. Nothing is hitting the system log to help me figure it out either. Please help. Thanks Doug

v3.6.0 Build 2543

Just downloaded today

intralogix
· 1
intralogix
Replies (9)
helpful
0
not helpful

Here is my web.config as well.

Gemini NHibernate.Driver.SqlClientDriver NHibernate.Dialect.MsSql2005Dialect NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle false true 0 60 GeminiSample.dbo true ReadUncommitted false true 1, false 0, yes 'Y', no 'N' "Off" Always display detailed ASP.NET error information. "RemoteOnly" Display custom (friendly) messages only to users not running on the local Web server -->


intralogix
· 1
intralogix
helpful
0
not helpful

Turned off the CustomError message to reveal this message "Could not find stored procedure 'gemini_getlatestmessages'."


intralogix
· 1
intralogix
helpful
0
not helpful

Got a few of the stored procs from the main script but now getting this. It's like the 3.5 to 3.6 did not run completely or was incomplete.

Server Error in '/' Application.

Invalid column name 'projectname'. Invalid column name 'originatortype'. Invalid column name 'originatorreply'. Invalid column name 'originatordata'. Invalid column name 'originatorprocessed'.


intralogix
· 1
intralogix
helpful
0
not helpful

Saar.....I was able to get the system back up and running by running the "CreateViews" and "CreateProcs" to completely recreate the views not updated. Just a note if anyone else runs into problems


intralogix
· 1
intralogix
helpful
0
not helpful

Thank you for the update. Glad all is well now.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I agree, there definitely seem to be database objects missing from the upgrade script. I, too, ran it successfully but got errors until I followed the above advice to run createviews and createprocs.


nharris
· 1
nharris
helpful
0
not helpful

Not sure I follow. We always say to run these scripts when upgrading. Are you saying you had to run them twice?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

No - I hadn't appreciated the createviews and createprocs scripts had to be run in addition to the upgrade script. I assumed the latter did it all.

Hey, you expected me to RTFM??


nharris
· 1
nharris
helpful
0
not helpful

ROTFL.... Glad it's all cleared up!


Saar Cohen
· 5000
Saar Cohen