I am getting the following exception: Caused by: org.apache.cayenne.FaultFailureException: [v.3.0-SNAPSHOT Aug 26 2011 14:27:54] Error resolving fault for ObjectId: <ObjectId:User, USERID=0> and state (hollow). Possible cause - matching row is missing from the database. at org.apache.cayenne.BaseContext.prepareForAccess(BaseContext.java:171) at org.apache.cayenne.CayenneDataObject.readProperty(CayenneDataObject.java:219)
I researched and saw that the following JIRA had been created to address this issue. What happened in my case is I attempted to delete a record from a table that had foreign key constraints. So within SSMS, it gave me the error, but the data I attempted to delete remained in the table. However, after that, every time I attempt to access the table using Cayenne, I get the above exception. I tried everything, including Restoring my Sql Server database from a backup, but I still get the error. What is really strange is the error happens when I use an Expression and a SelectQuery. If I use raw sql to access the table in question with a SQLTemplate, there is no error! Here is a JIRA that talks about the exact same issue, but there was no replyhttps://issues.apache.org/jira/browse/CAY-2096 Please advise as to what the issue might be. Thank you Vince Smith
