DevForce Community Forum : ConstraintException problem http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : ConstraintException problem Wed, 10 Jun 2026 12:53:02 -700 Mon, 19 Oct 2009 14:07:32 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1524 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ ConstraintException problem : I didn't want to make it... http://www.ideablade.com/forum/forum_posts.asp?TID=1524&PID=5654#5654 Author: kjohnson
Subject: 1524
Posted: 19-Oct-2009 at 2:07pm

I didn't want to make it sound like I'm taking a problem lightly.  Since I know that objects are saved to the DB with a positive permanent id I wanted to try and make sure that it wouldn't happen again.  I had been working on adding a new feature to our project when the ConstraintException started happening.  After I removed the modified code from being executed the exception continued to occur, which is what I originally posted about.  I have since done testing while adding the modified code back in to try and prevent the problem occurring again.  So far I have not seen it happen a second time.

I don't think that a missing relationship in the Object Mapper could be the cause, but I will look into that and implementing DB constraints to try and prevent this happening again.
]]> Mon, 19 Oct 2009 14:07:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1524&PID=5654#5654 ConstraintException problem : Be careful! My concern is that... http://www.ideablade.com/forum/forum_posts.asp?TID=1524&PID=5652#5652 Author: davidklitzke
Subject: 1524
Posted: 19-Oct-2009 at 1:34pm

Be careful!   My concern is that you may be fixing the symptom and have not addressed the root cause.
 
Very rarely do we see reports of entities being saved to the database with negative parmanent ids.  This can be a very serious problem, and the problem can propagate and go worse over time.  One way that this could happen would be if you had a grandparent-parent-child relationship and failed to include all 3 relationships in the Object Mapper.  In any case, I would strongly recommend that you try to prevent this error from occurring during the save (perhaps with a DB constraint).
]]> Mon, 19 Oct 2009 13:34:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1524&PID=5652#5652 ConstraintException problem : After doing some more investigating... http://www.ideablade.com/forum/forum_posts.asp?TID=1524&PID=5647#5647 Author: kjohnson
Subject: 1524
Posted: 19-Oct-2009 at 7:13am

After doing some more investigating I believe I have found the cause.  Somehow an object of the type 'ReceiptDetail' was saved to the database with an Id of '-3'.  Correcting this should correct the problem.]]> Mon, 19 Oct 2009 07:13:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1524&PID=5647#5647 ConstraintException problem : I've started getting a ConstraintException... http://www.ideablade.com/forum/forum_posts.asp?TID=1524&PID=5646#5646 Author: kjohnson
Subject: 1524
Posted: 19-Oct-2009 at 6:26am

I've started getting a ConstraintException periodically when when I create a new object through the persistence manager.  The problem started this past Friday, usually on one of the first objects my program creates the Model hits the exception with a message of "Column 'Id' is constrained to be unique.  Value '-3' is already present."  the exception is thrown on the statement 'aReceiptDetail.AddToManager();" and the only time the column 'Id' is touched is at "pPersMgr.GenerateId(aReceiptDetail, ReceiptDetail.IdEntityColumn);".  The way that this object is generated has not changed significantly is several weeks, and the NumericIdGenerator has not changed since last year, but for some reason it occasionally assigns an in-use tempid to a newly created object.  Any ideas on what could be causing this?]]> Mon, 19 Oct 2009 06:26:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1524&PID=5646#5646