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 when accessing a project's repository.

web-app

 Other projects in the same install don't have this issue:

Server Error in '/' Application.

This constraint cannot be enabled as not all values have corresponding parent values.

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: This constraint cannot be enabled as not all values have corresponding parent values.

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: This constraint cannot be enabled as not all values have corresponding parent values.]
   System.Data.DataRelationCollection.Add(DataRelation relation) +145
   System.Data.DataRelationCollection.Add(DataColumn parentColumn, DataColumn childColumn) +45
   CounterSoft.GeminiBiz.eb9103e5da53398c.4e41e183df9f75ae(Int32 39aa6b45a7928cb9) +200
   Gemini.ProjRepos.FillTree() +325
   Gemini.ProjRepos.Page_Load(Object sender, EventArgs e) +740
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   Gemini.BasePage.OnLoad(EventArgs e) +5
   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

MSloan
· 1 		MSloan
Wednesday, July 5, 2006, 8:38:25 PM
Replies (9)
helpful
0
not helpful

Is this a "fresh" install or an upgrade?
Saar Cohen
· 5000 		Saar Cohen
Thursday, July 6, 2006, 12:02:42 AM
helpful
0
not helpful

An upgrade from 2.0.1 to 2.0.2 and now 2.0.3
MSloan
· 1 		MSloan
Thursday, July 6, 2006, 11:22:02 PM
helpful
0
not helpful

It seems like the repository table has got incorrect references for that project.

Did you have files in it?
Saar Cohen
· 5000 		Saar Cohen
Friday, July 7, 2006, 12:38:03 AM
helpful
0
not helpful

There are files in the repository that we'd like to salvage if possible, but if not, it won't be an irretrivable tragedy...
MSloan
· 1 		MSloan
Saturday, July 8, 2006, 1:38:11 AM
helpful
0
not helpful

We can try and salvage the files. Try and run this SQL command:

SELECT     * FROM    projectrepository WHERE   projid = THE PROJECT ID (ie 2)

What do you get back?

 

If you just want to cleanup the repository for this project, simply issue a delete statment on this table for that project id.
Saar Cohen
· 5000 		Saar Cohen
Saturday, July 8, 2006, 11:27:26 AM
helpful
0
not helpful

That statement shows 24 objects (some are folders?)

We just want to fix the issue - and if deleteing the files will fix the issue, we're willing to do that.  It's not a general clean up. 

How would I retrieve those files?  I attempted to save one and it wanted to save as a CSV file.  I can execute a SELECT statement, but that's about the extent of my SQL knoweledge.

 
MSloan
· 1 		MSloan
Monday, July 10, 2006, 7:21:34 PM
helpful
0
not helpful

We can try and fix this issue if you like. Just send us the output of the statment to priority@countersoft.com

If you just want to delete the repository for this project execute:

delete from projectrepository where projid = YOUR PROJECT ID
Mark Wing
· 9108 		Mark Wing
Tuesday, July 11, 2006, 10:32:23 AM
helpful
0
not helpful

Thanks for sending the data to us.

The issue is that you have a parentless folder. Not sure how did it happen but if you run the follwoing sql: select * from projectrepository where parentnodeid not in (select nodeid from projectrepository )

You will get the node that is in error. To fix this you can simply update the parent of this node to be the main folder (values are according to the data you have sent):

update projectrepository set parentnodeid = 98 where nodeid=297

 

Hope this help,

Saar.
Saar Cohen
· 5000 		Saar Cohen
Tuesday, July 11, 2006, 10:50:56 PM
helpful
0
not helpful

When I ran the first query, I did not recieve any results.

However, when using the second, that solved the issue - I can now get in, and see all the files.

Thanks.
MSloan
· 1 		MSloan
Tuesday, July 11, 2006, 11:37:50 PM