I am using the REST API and SOQL to query an Org's CaseComment records, but I'm getting the "invalid cross reference id" error. Most of my search online shows this error occurring during inserts or updates, not queries. We are also able to run this query without any problems against other Orgs. The query looks like:
SELECT Id,ParentId,IsPublished,CommentBody,CreatedById,CreatedDate,SystemModstamp, LastModifiedDate,LastModifiedById,IsDeleted,CreatorFullPhotoUrl, CreatorSmallPhotoUrl,CreatorName FROM CaseComment LIMIT 10000
What are the reasons this could happen during a SOQL query and what can be done to find the root cause?