Ok, am able to reproduce this in my dev environment. Here are the steps:
Create record in app (via ORM)
Manually update record in SQL (Change the PersonID in the Stuff table for the record)
Restart ColdFusion
Load app and run criteria query
ERROR OCCURS
OrmReload()
ERROR RESOLVED
Restart ColdFusion
ERROR OCCURS
and on and on
So it appears that ORMReload() is fixing the issue, as I experienced on my production site. However, I’m thoroughly confused about what’s happening with the CF restarts. I’m not privy to when our CF instances are restarted on production, so I’m not entirely sure this is the root of the issue. However, being able to reproduce the issue consistently on dev has given a glimmer of hope to my weary soul.
Thanks for the suggestions guys. I guess what I’m confused about is why the cache evictions would be needed after a CF restart. Wouldn’t the cache be re-established in that scenario?