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?
I've encountered this same message, and I too am confused.
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.
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)
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.
Has anyone gotten anywhere with this? Got same on a SQL view in Pro 3.4. I'm going to open a support ticket.
I continue to get this error as well. i am wondering if i need to upgrade by database?
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
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!
@NadinaSchlik,
My issue was that I had duplicate IDs in the field I had designated as ObjectID. Hope that helps.
Thanks for the update @BrettFrahm , I'll look into this!
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.
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.
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.....
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?
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.
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.
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.
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
I had a SQL view that was using ObjectID and an Inner join so the result was creating duplicate ObjectIDs then the view can't be opened in ArcGIS Pro. I was able to fix it by changing the SQL View definition and calculating the ObjectID before registering the View with the enterprise geodatabase. from:
FL.OBJECTID,
to:
ROW_NUMBER() OVER (ORDER BY FL.OBJECTID, dbo.sdChannelResults_evw.Result_Type) AS OBJECTID,```
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
