New Posts New Posts RSS Feed: Circular Relationship Error
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Circular Relationship Error

 Post Reply Post Reply
Author
jipock View Drop Down
Newbie
Newbie
Avatar

Joined: 08-Dec-2010
Location: Cherry Hill, NJ
Posts: 39
Post Options Post Options   Quote jipock Quote  Post ReplyReply Direct Link To This Post Topic: Circular Relationship Error
    Posted: 04-Jan-2011 at 6:43am
Good Morning, all. Happy New Year..
 
I am building a DevForce Silverlight app and am getting the following error upon save:
 
"The Changes to the database were committed successfully, but an error occurred while updating the object context. The object might be in an inconsistent state. Inner Exception: A circular relationship path has been detected while enforcing a referential integrity constraints. Referential Integrity cannot be enforced on cicular relationships"
 
I'm trying to track this issue down. Please note: this application before using DevForce (using stored procedures) was working fine with no referential integrity errors.
 
The only thing I can see which *might* be an issue is the part of the Record table.
 
A Record contains information about a "trouble ticket" (think 'help desk'). The Record has associated tables like a RecordService (which holds a list of all the Services provided with an instance of the Trouble Ticket).
 
A person gets a Service provided at a specific Location. The Services and Location combination is stored in a ServiceLocation table.
 
I have the person taking the record pick an entry from the ServiceLocation table, but I record the Record Service with an entry to the Record, Service, and Location (as opposed to a ServiceLocation).
 
Code:

recordservice.Active = true;

recordservice.Record = _record;

recordservice.Service = SelectedServiceLocation.Service;

recordservice.Location = SelectedServiceLocation.Location;

Any hints as to how / where to troubleshoot and (more importantly) how to correct this? A search of the Wiki doesn't yield anything about Circular References.
Back to Top
jipock View Drop Down
Newbie
Newbie
Avatar

Joined: 08-Dec-2010
Location: Cherry Hill, NJ
Posts: 39
Post Options Post Options   Quote jipock Quote  Post ReplyReply Direct Link To This Post Posted: 04-Jan-2011 at 7:34am
PEBCAK problem. This has been resolved...
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down