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 1.8.2 to 2.03 issue

web-app

I downloaded the latest version of Geminiv203 and tried the upgrade.

I have a question thouhg

I rand the db upgrades that were in the \Geminiv203\Deploy\Step1SQLDatabase\Upgrades folder in the following order:

1.9.sql then 1.9.1.sql then 2.0.sql   this went fine no error.

now after that's done I ran the store procedure that was in the following folder Geminiv203\Deploy\Step1SQLDatabase\Createprocs.sql but when I ran that one I got the following messages:

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'geminideleteprojectattributes'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'geminiunmarkclosingcomment'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'geminiprojreposdeletenode'. The stored procedure will still be created.

Did I miss an extra step or what did I do wrong?

Do I still need to run the other contents in Gemini203\Deploy\Step1SQLDatabase

createtable.sql and createviews.sql?

I followed the steps that were mentioned in other posts in regards to upgrading the db but nothing was mentioned about the store procedures but he manual says to run it.

 

Thanks in advance.

Garifo

 
garifo
· 1 		garifo
Wednesday, March 8, 2006, 5:18:27 PM
Replies (3)
helpful
0
not helpful

After upgrading i'm now testing the application...but when I click on Home for some of the projects in gemini I get the following error message.

Gemini Application Error

An application error has occured - please advise the Gemini administrator within your organisation.

The Error log shows: Input string was not in a correct format.

at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at ASP.Projectaspx.DataBindcontrol8(Object sender, EventArgs e) at System.Web.UI.Control.OnDataBinding(EventArgs e) at System.Web.UI.Control.DataBind() at System.Web.UI.Control.DataBind() at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.Repeater.DataBind() at Gemini.Project.Page_Load(Object sender, EventArgs e)

 

And is not for all my projects.  In addition if I click on Roadman then I'm able to see the main project page and work from there.  But when clickin on "Home" I always get the error message.

This is an example- of the project name but is nothing differnt than the other project names I have.

Private Office Website (POW) or Pro - CMA (CMA)

 

Thanks in advance.

Garifo
garifo
· 1 		garifo
Wednesday, March 8, 2006, 6:23:14 PM
helpful
0
not helpful

Did you run Create_Views.sql?  If not, please do so.
Harvey Kandola
· 212 		Harvey Kandola
Wednesday, March 8, 2006, 9:38:52 PM
helpful
0
not helpful

Thank you very much...that fixed the problem. 


garifo
· 1 		garifo
Wednesday, March 8, 2006, 10:03:48 PM