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.




Upgrade 3.0.4 -> 3.1.1

web-app

I'm getting this error when upgrading.

Msg 2714, Level 16, State 3, Procedure geminigetlut1, Line 40

There is already an object named 'geminigetlut1' in the database.

Msg 2714, Level 16, State 3, Procedure geminigetissueupdatedata, Line 44

There is already an object named 'geminigetissueupdatedata' in the database.

The steps I run are these in the following order:
Upgradev3-1.sql
CreateViews.sql
Create_Procs.sql

All scripts are run with the gemini user.
Drud
· 1 		Drud
Tuesday, January 27, 2009, 9:02:10 AM
Replies (3)
helpful
0
not helpful

Do you get these when running the create_procs.sql script?

Are these the only errors?
Mark Wing
· 9108 		Mark Wing
Tuesday, January 27, 2009, 9:38:11 AM
helpful
0
not helpful

Yes. It was the only errors I got running the Createprocs.sql script.

When I run the Createprocs.sql again. It completes succesfully. However a lot of the functionality is not working.

Roadmap.

SqlException (0x80131904): Invalid object name 'geminicomponents'.]
   CounterSoft.Gemini.DataProvider.xd40904422a043a04.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) +617
   CounterSoft.Gemini.Business.xa37334733da24461.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, UserEN xfd92dbe2fa4bcb5a) +18
   CounterSoft.Gemini.Presenter.ProjectPresenter.GetProjectSummary(Int32 projectID, UserEN user) +11
   CounterSoft.Gemini.Web.Project.ProjectHome.SelectTab() +61
   CounterSoft.Gemini.Web.Project.ProjectHome.PageLoad(Object sender, EventArgs e) +1071
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Adding a comment to an issue

[SqlException (0x80131904): Invalid object name 'geminicomponents'.]
   CounterSoft.Gemini.DataProvider.xc0186e148e957052.x73840d091b43c7c6(Int32 xa8708020b9a21a3a) +343
   CounterSoft.Gemini.Business.x95da312ae9372c2e.x73840d091b43c7c6(Int32 xa8708020b9a21a3a, String xe11d46446868b783) +22
   CounterSoft.Gemini.IssueComment.PageLoad(Object sender, EventArgs e) +1428
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
Drud
· 1 		Drud
Tuesday, January 27, 2009, 9:41:40 AM
helpful
0
not helpful

Resolved the issue. Some objects was created with the wrong schema owner. Changing the schema solved my problems.
Drud
· 1 		Drud
Tuesday, January 27, 2009, 10:18:47 AM