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.




error in repository after upgrade from 2.0.1 to 2.0.3

web-app

I just upgrade to 2.0.3, and all seems fine, except that i get this error when accessing the repository for the projects:

Parameter count does not match Parameter Value count.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Parameter count does not match Parameter Value count.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: 

[ArgumentException: Parameter count does not match Parameter Value count.]
   Microsoft.ApplicationBlocks.Data.547b3e3aafbf5c76.a253048c8909184a(SqlParameter[] 454012810ec94a8e, Object[] 1965c0a20ee8cf48) +288
   Microsoft.ApplicationBlocks.Data.547b3e3aafbf5c76.7c2fee8897be57c9(String a879b125487e7c99, String 123f50d131164f33, Object[] 1965c0a20ee8cf48) +54
   CounterSoft.GeminiBiz.eb9103e5da53398c.4e41e183df9f75ae(Int32 39aa6b45a7928cb9) +286
   Gemini.ProjRepos.FillTree() +325
   Gemini.ProjRepos.Page_Load(Object sender, EventArgs e) +741
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   Gemini.BasePage.OnLoad(EventArgs e) +4
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

 

Is there something i overlooked? I ran the Create_Procs.sql upgrade script, and copied all files to the server.....?

cheers,

Erik
erikvb
· 1 		erikvb
Friday, March 31, 2006, 11:18:04 AM
Replies (8)
helpful
0
not helpful

We're running into the same issue. Does it occour for also for projects created before the upgrade, or (as in our case) only for projects created after the upgrade to 2.0.3?

See here:

http://community.countersoft.com/forums/thread/640.aspx
deniz
· 1 		deniz
Friday, March 31, 2006, 5:17:14 PM
helpful
0
not helpful

We can not seem to replicate this issue. Did you run create view and procs after the upgrade?
Saar Cohen
· 5000 		Saar Cohen
Friday, March 31, 2006, 9:14:41 PM
helpful
0
not helpful

I tracked down the source of this error: I ran the upgrade script as SA, which resulted in the procedures to be created with DBO as owner. Apparently, i installed the earlier version being logged on as the user which has only dbo access to the gemini db, and all objects in the db are owned by that user (is that something the MSI installer does?)

I deleted all newly created objects, and ran the upgrade script again as my gemini user, and this time everything went fine. I now have full access to the repository as well ;)

Cheers,

Erik
erikvb
· 1 		erikvb
Monday, April 3, 2006, 11:01:23 AM
helpful
0
not helpful

Just want to provide the way how we solved this issue:

We checked table: projectrepository and recognized, that for every new project we create, there is no entry written to this table. Therefore I added the missing details for the new Gemini Project to that table. After that we did not get anymore the Server Application Error.

This is not a 100% fix, but at least we can use the Repository again.

Interesting it would be, why nothing is written anymore to this table when we create a new project.

 
deniz
· 1 		deniz
Monday, May 15, 2006, 2:07:31 PM
helpful
0
not helpful

I have upgrade from 2.0.3 to 2.0.4, and I am having this problem.  I have run CREATEPROCS.SQL a number of times as the gemini user (owner of the database) and I always get the following error (regardless of whether or not I delete all the existing SPs):

"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."

I then see the afformentioned repository error.
sirwally
· 1 		sirwally
Tuesday, May 23, 2006, 10:52:18 AM
helpful
0
not helpful

Ooh..SQL recursion.  That explains the error when running CREATE_PROCS.SQL.

I checked the projectrepository table and the data is still there.  I may end up having to go back to a backup from yesterday to fix this, but I'd rather not...
sirwally
· 1 		sirwally
Tuesday, May 23, 2006, 11:00:35 AM
helpful
0
not helpful

Problem solved, although seemingly by magic.  I restored from my 2.0.3 backup, repointed the app at the restored database and the repository worked again..  I reran CREATE_PROCS.SQL against the restored database, and it continued to work.  I then repointed the app back at the original database and everything is now working.  I don't understand why.  Could it be some sort of caching issue?
sirwally
· 1 		sirwally
Tuesday, May 23, 2006, 11:28:27 AM
helpful
0
not helpful

It might be that the app did not refresh and did after you saved the web.config file.
Saar Cohen
· 5000 		Saar Cohen
Tuesday, May 23, 2006, 10:39:46 PM