Failed to retrieve a page of rows. The event class for this subscription is in an invalid partition.

[JamesS1]

Received the following when trying to view the attributes of a view in ArcGIS Pro. Other similar views work fine. No idea what this error means. Any thoughts?

[GeoDanielBishop]

I've encountered this same message, and I too am confused.

[JamesS1]

As a follow-up, after publishing and adding to a web amp, it appears the data is returned just fine (in the pop-ups). Seems like this error is specific to an ArcGIS Pro display issue.

[BlakeTerhune]

I also got this error in ArcGIS Pro 3.3.1 when trying to load all 139,396 rows in the attribute table of a feature class in a 10.8.1 enterprise geodatabase running on Oracle 19c.

Failed to retrieve a page of rows.

The event class for this subscription is in an invalid partition (0x8004020F)

After clicking OK on the error, the attribute table closes. Trying again yields the same result.

[BrettFrahm]

Has anyone gotten anywhere with this? Got same on a SQL view in Pro 3.4. I'm going to open a support ticket.

[ShannonSmith5]

I continue to get this error as well. i am wondering if i need to upgrade by database?

[Mapping-1]

If you export the feature class you're having this problem with as a .SHP, import it into a MyAssetMap project and export it out again as a .SHP ArcGIS will allow you to open the data table in if you import the new .SHP file you created by exporting

[NadinaSchlik]

Hi everybody, 

I'm getting the same error trying to open a view. Any updates on this? Could anyone find a workaround? 
@BrettFrahm did you open a support ticket? 

Thank you!

[BrettFrahm]

@NadinaSchlik,

My issue was that I had duplicate IDs in the field I had designated as ObjectID. Hope that helps.

[NadinaSchlik]

Thanks for the update @BrettFrahm , I'll look into this!