firefault error in a component

[Peter Adams <padams@stanford.edu>]

In one table I have a requirement that one of its FK's may be null. The
relationship pointing to the FK's class in EOModeler  is set to Optional. This
works in terms of data storage and retrieval, but when I need to display
attributes in a component I get a firefault error.

The correct rows are returned by a fetch. The firefault error occurs when the
component is displayed. This happens when an attribute from the class with the
null FK is requested for the page, even though no attribute from the class
nominally pointed at by the null FK is requested! In the error below the data
structure is based on a TestAssessment class which has an FK to TestAdmin. An
instance of the latter has a null FK to another class. The TestAdmin record with
ID = 29 does exist, it just has the null FK.

Exception occured while evaluating 'testassessment.toTestAdmin.schedStartDate',
on
                   target:<TestAssessmentListPage 0xb194f0>:
                   _fireFault:: Failed to fetch the object with gid [GID:
TestAdmin, (29)]. This likely indicates a referential
                   integrity problem with your database -- a row referenced by a
foreign key is missing from the database.

As soon as I update the TestAdmin record from null to any legitimate FK (through
SQL-Plus) the page comes up correctly. Again, no attribute from the null FK's
class are requested in the component. What am I missing here?

Thanks,

Pete

--
Peter Adams
Systems SW Developer
Stanford Univ Language Center
vc: 650-725-7909
em: padams@stanford.edu
http://www.stanford.edu