Re: Error resolving fault for ObjectId: <ObjectId:User, USERID=0> and state (hollow)

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. <[email protected]> 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