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.




2.2.6 upgrade issue (from 2.1.1)

web-app

Platform: Server 2003 x64
Database: SQL Server 2000

Current installed version: 2.1.1
Upgrade to: 2.2.6

Performed manual installation
-Backup existing v2.1.1 Gemini Web Application
-Replace existing v2.1.1 Gemini Web Application with v2.2.6
-Update database connection string in web.config
-Database scripts applied: Upgradev2-2.sql, CreateViews.sql, CreateProcs.sql

Login seems to be fine.  When clicking Home on any of the three projects I get the following error:

Invalid column name 'compid'. Invalid column name 'compid'. Invalid column name 'assignedto'. Invalid column name 'assignedto'. Invalid column name 'assignedto'. Invalid column name 'assignedto'. Invalid column name 'assignedto'.

SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.DataSet xbb74a08c6f5f6fb7(Int32, Boolean) STACKTRACE: at CounterSoft.Gemini.DataProvider.xd40904422a043a04.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, Boolean x4cb3f3053733aac1) at CounterSoft.Gemini.Business.xa37334733da24461.xbb74a08c6f5f6fb7(Int32 xa8708020b9a21a3a, Boolean x4cb3f3053733aac1) at CounterSoft.Gemini.Project.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 CounterSoft.Gemini.Business.BasePage.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

The compid and assignedto columns seem to have been deleted when applying Upgradev2-2.sql script.

Also, when clicking on Create Issue the following error is reported:

Cannot find table 6.

SOURCE: System.Data TARGETSITE: System.Data.DataTable getItem(Int32) STACKTRACE: at System.Data.DataTableCollection.getItem(Int32 index) at CounterSoft.Gemini.CreateIssue.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 CounterSoft.Gemini.Business.BasePage.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Any ideas?

tim77
· 1
tim77
Replies (7)
helpful
0
not helpful

One thing im always doing is running the SP's on the master database - definitely run the scripts against the right database?


Simon@MailboxPro
· 1
Simon@MailboxPro
helpful
0
not helpful

It seems like you are still running the old version of the web app.

Can you check (top left of the screen)?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

That is what we thought as well Mark.  However, the top left of screen shows 2.2.6.


tim77
· 1
tim77
helpful
0
not helpful

Good thinking OblivionSY, that has burned me on more than one time.  However, I was careful to select the Gemini database before applying the scripts.


tim77
· 1
tim77
helpful
0
not helpful

Check the owner of the database objects, it might be that you have 2 sets of objects.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

As careful as I was, it looks like I did not point to the right DB.  User error.

Thanks for you prompt support gentileman...


tim77
· 1
tim77
helpful
0
not helpful

No worries, glad it's sorted


Simon@MailboxPro
· 1
Simon@MailboxPro