Hi Vince, My memory is really rusty on Cayenne 3.0 (and looks like you even have a pre-GA version there).
> tried everything, including Restoring my Sql Server database from a backup, > but I still get the error. Does it happen after the Cayenne app restart? (Not suggesting that restart is the solution, just trying to understand the symptoms). Andrus > On Apr 28, 2020, at 11:54 PM, Vince S. <vinc...@outlook.com> wrote: > > 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
