topic Re: Failed to retrieve a page of rows. The event class for this subscription is in an invalid partition. in ArcGIS Pro Questions

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

JamesS1 — Fri, 06 Sep 2024 13:09:08 GMT

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?

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

GeoDanielBishop — Mon, 09 Sep 2024 12:21:21 GMT

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

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

JamesS1 — Mon, 30 Sep 2024 12:43:34 GMT

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.

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

BlakeTerhune — Wed, 13 Nov 2024 17:05:00 GMT

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.

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

BrettFrahm — Mon, 09 Dec 2024 22:19:46 GMT

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

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

ShannonSmith5 — Tue, 10 Dec 2024 20:26:21 GMT

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

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

Mapping-1 — Mon, 16 Dec 2024 19:13:06 GMT

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

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

NadinaSchlik — Thu, 02 Jan 2025 18:31:23 GMT

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!

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

BrettFrahm — Thu, 02 Jan 2025 18:37:16 GMT

@NadinaSchlik,

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

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

NadinaSchlik — Thu, 02 Jan 2025 19:42:21 GMT

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

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

MVieng — Wed, 22 Jan 2025 23:24:03 GMT

Something that worked for me is review the data type for columns I wanted to display in my query. Turns out one of my columns was a double and not able to be read in ArcGIS Pro's query layer as a double. Used the function CAST as Varchar(100) and that seemed to do the job. There were multiple columns that needed to be converted from the original data type to Varchar(100), eg - one other column as data type of Big Int which also wasn't coming across. Hopefully this helps others in the future.

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

DavidLineberry — Thu, 30 Jan 2025 14:16:01 GMT

I encountered the same error while working in Pro. The layer triggering the error was as feature class added from a file geodatabase outside of the project geodatabase. I imported it into the project.gdb and now the table loads without error.

I hope this work around helps.

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

WAC_GIScoordinator — Tue, 22 Apr 2025 15:28:52 GMT

Not a full solution, but If the 'Load All' button is present at the bottom of the table, click it. I stopped getting the error. So Far.....

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

JohnGuilfoyle — Tue, 22 Apr 2025 16:39:34 GMT

I tried this workaround. The table closed again. This time, I deleted the point by selecting it with the rectangle and using the Delete key on the keyboard. Maybe by deleting from the table it's more stable?

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

WAC_GIScoordinator — Tue, 22 Apr 2025 17:08:47 GMT

Possibly. In my situation, I was deleting rows. After each, delete, table would close. I would save edits, reopen table and start again. Then I noticed not all rows had loaded. Once loaded, table wouldn't close after a row delete.

I'm offering up what I'm experiencing. May not be applicable in all instances, but hopefully worth a try.

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

TravisColeHC — Mon, 05 May 2025 19:58:08 GMT

I was encountering this issue when trying to copy to or create a feature layer in our SDE database. I was using Pro 3.3. I tried our server that had Pro 3.5 installed after several variations of trying to copy or create the layer on my desktop with Pro 3.3 installed and the server didn't experience the issue. I went back and updated the Pro version on my desktop to 3.5 and tried it worked as should with no error now.

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

TomasPokorny — Mon, 11 Aug 2025 10:39:28 GMT

Hi, I'm encountering the same error when trying to delete features from a versioned feature class within a dataset. I used the "Delete Features" tool without making any selection, expecting all rows to be deleted. However, that didn't happen. I didn't verify the result after running "Delete Features" and proceeded to append new data. The data appeared, but when I tried to make a selection or open the attribute table, I received the mentioned error. When I deleted all features using a selection (Select All), the feature class was truly empty, and after appending new data, the error did not occur.

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

Br1an_Peters — Mon, 18 Aug 2025 21:20:57 GMT

Any real understanding as to why this happens? I'm having a similar issue. If I add curtain views to the Map and right click attribute table... same error you posted. Only some of the views give this error, some do not! If i select some of the features in the map and show attributes of selected, the table opens and then if i Load All they get added. They all open in ArcMap no issues? Same issue with ArcGIS Pro 2.9, 3.2 and 3.3.5