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.




database update 3.0.3 -> 3.0.4

web-app

Hi.

We updated our gemini application from 3.0.3 to 3.0.4.
Is there any sql script which we should run to update the database?

Best regards
Adam
AdamWhite
· 1 		AdamWhite
Tuesday, July 29, 2008, 10:45:51 AM
Replies (8)
helpful
0
not helpful

Yes, you will need to run createviews.sql and createprocs.sql
Mark Wing
· 9108 		Mark Wing
Tuesday, July 29, 2008, 11:03:43 AM
helpful
0
not helpful

Oh, yes. Thanks for all.
AdamWhite
· 1 		AdamWhite
Tuesday, July 29, 2008, 11:21:16 AM
helpful
0
not helpful

any trouble?
mulmad
· 1 		mulmad
Monday, August 4, 2008, 2:16:55 PM
helpful
0
not helpful

I did not have any trouble running the scripts, however I am currently experiencing an error with Gemini whenever it attemps to load most any of the pages.  In the error log, I get:

Invalid column name 'viewtype'. Invalid column name 'viewtype'.

SOURCE: .Net SqlClient Data Provider TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean) STACKTRACE: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Bool

Aside from running the database scrips, I archived my previous web files and have the updated package in as the current app, as directed in the documentation.
mrIT79
· 1 		mrIT79
Thursday, August 7, 2008, 11:13:42 PM
helpful
0
not helpful

This error should only come up if you did not upgrade your database from 3.0.0.

Run the 3.0.1 upgrade script.
Saar Cohen
· 5000 		Saar Cohen
Friday, August 8, 2008, 12:00:18 AM
helpful
0
not helpful

That did the trick.  I did not read in the upgrade instructions that I needed to patch from 3.0.0 to 3.0.1 before upgrading to 3.0.4.  To help keep this happening to someone else, could the 3.0.1 patch just be included in the database script for views in 3.0.4?
mrIT79
· 1 		mrIT79
Friday, August 8, 2008, 3:28:12 PM
helpful
0
not helpful

Unfortunately no as database upgrades are not comulative. So we can't add the field twice.
Saar Cohen
· 5000 		Saar Cohen
Friday, August 8, 2008, 7:40:26 PM
helpful
0
not helpful

I've upgraded sucessfully from Gemini 3.0.3 (Build 1998) to Gemini 3.0.4 (Build 2026)

1. backed up Gemini web application files
2. backed up Gemini database
3. copied over all web application files
4. ran CreateViews.sql and CreateProcs.sql
5. changed the connection string settings in the web.config
mulmad
· 1 		mulmad
Thursday, August 14, 2008, 12:33:19 AM