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.




Upgrading from 2.2.6 to 3.7.2

migration

I'm currently working in a devel environment to test the Gemini v.2.2.6 to 3.7.2 migration. I followed the Gemini installation guide without any errors (other than 2 alerts that the risk level ID was invalid).

When I log in and try and click on any existing project I get an application error.

The log states:

Procedure or function geminigetprojectsummary has too many arguments specified. at CounterSoft.Gemini.DataProvider.xd40904422a043a04.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Business.xa37334733da24461.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Presenter.ProjectPresenter.GetProjectSummary(Int32 projectID, UserEN user) at CounterSoft.Gemini.Web.Project.ProjectHome.PageLoad(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Windows 2008 R2 Std Server and SQL 2008 Express fully patched.

MStenz
· 1
MStenz
Replies (6)
helpful
0
not helpful

Did you run the createprocs and createviews SQL scripts?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Ran (in this order):

CreateTables.sql CreateViews.sql CreateProcs.sql Upgradev3-0-Step1.sql


MStenz
· 1
MStenz
helpful
0
not helpful

Can it be that you have run these in a different user context?
So now the stored procedure is there twice, once under one schema and once under a new one?
Please check in SQL management studio the owner / schema of the new Gemini objects.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I think that is it - ran the scripts as 'sa' and schema was set to dbo so there were dupes, dbo and Gemini schema.

I ran the procedures/views as the Gemini user and looks like everything is working so far.

Is this general practice then? Unless I missed it, I didn't see anything in the documentation to run as the Gemini user.


MStenz
· 1
MStenz
helpful
0
not helpful
ANSWER

This is up to the person who setup your database. We don't force the Gemini schema to dbo as some users like to have it in their own schema (as you had).


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

OK, makes sense. I took this over so I wasn't a part of the initial setup.

Thanks!


MStenz
· 1
MStenz