topic Re: What does "Failed to retrieve a page of rows" imply? in ArcGIS Pro Questions

What does "Failed to retrieve a page of rows" imply?

ThomasColson — Thu, 16 Aug 2018 14:52:40 GMT

552 points in a SDE 10.6.1/SQL 2014 Feature class, published as a 10.5.1 non-federated feature service, sorted, when I scroll, I get this error, which doesn't explain a lot. Any insight? I happen to have two maps, two catalog views, and two attribute tables open in the same project, one set for the "new" SDE, one pointing to the "Old", I'm knee deep in a migration project, and I'm stubbornly doing the entire thing in Pro. After the error appears, the attribute table "crashes". Arc Map handily scrolls the table, both from SDE and Feature Service source. Changing the caching settings in Pro doesn't help. Interestingly, when I bring the SDE table into Pro, I can scroll down, albeit much more slowly, but the table doesn't crash. If I sort on an attribute that is not driven by a domain, the error doesn't occur, only when I sort an attribute controlled by a domain then scroll.Was wondering if anyone else has this issue, or it's a known one?

Re: What does "Failed to retrieve a page of rows" imply?

JonathanFarmer_oldaccount — Thu, 16 Aug 2018 18:53:51 GMT

Hey Tom,

This is a known issue. But can you confirm that this is your workflow?

Add Hosted Feature Layer to a map in Pro
Open the attribute table and sort the table based on a field which has a domain
Scroll down through the table with your mouse, you should see the error

Here is the bug information: BUG-000106410: Sorting a hosted feature layer on a Domain field and..

If your workflow is different, it would be good to know. We'd want to get a new case created in Support and investigate that. Could be we'd need to update this bug or create a new one. But I think this is the bug you are running into.

Jonathan

Re: What does "Failed to retrieve a page of rows" imply?

ThomasColson — Thu, 16 Aug 2018 18:58:05 GMT

Yes, that is exactly it! You just saved TS from the agony of a another call from me.....

Re: What does "Failed to retrieve a page of rows" imply?

JonathanFarmer_oldaccount — Thu, 16 Aug 2018 19:01:06 GMT

Happy to help!

Re: What does "Failed to retrieve a page of rows" imply?

DongxingMa — Thu, 20 Sep 2018 22:00:08 GMT

The problem I get is similar, but it occurs when opening the feature class's attribute table, the table cannot even be loaded.

Re: What does "Failed to retrieve a page of rows" imply?

JonathanFarmer_oldaccount — Thu, 20 Sep 2018 22:45:54 GMT

Hi Dongxing,

If you can't open the attribute table at all, then your issue should be separate from this bug. This is something that Tech Support should look into further for you. It could be something on our side or it may be something specific with your install. But they can help troubleshoot that with you.

Jonathan

Re: What does "Failed to retrieve a page of rows" imply?

DongxingMa — Thu, 20 Sep 2018 23:24:43 GMT

Thank you for your quick reply! Should I submit a help ticket for my problem or just wait for a ESRI support to contact me?

Re: What does "Failed to retrieve a page of rows" imply?

JonathanFarmer_oldaccount — Thu, 20 Sep 2018 23:27:09 GMT

Hi Dongxing,

You'll need to create a new case with Tech Support and then we can assist.

Jonathan

Re: What does "Failed to retrieve a page of rows" imply?

DongxingMa — Thu, 20 Sep 2018 23:29:56 GMT

Ok, I will do that. Thanks, Jonathan!

Re: What does "Failed to retrieve a page of rows" imply?

BenVan_Kesteren1 — Tue, 11 Dec 2018 00:21:11 GMT

Hey,

Jonathan Farmer It seems we have a very similar bug within our organisations setup, I had created another thread with my workflows over here...

Cheers

Re: What does "Failed to retrieve a page of rows" imply?

MontyBell — Thu, 24 Jan 2019 06:05:01 GMT

We are also encountering similar behavior: a "Failed to retrieve a page of rows" error message appears while scrolling through the attribute table, after sorting on a text field. However, our field does not have an associated domain.