I have been able to add a table using sql server in ArcMap Desktop for some time, I am now trying to read the table within an ArcGIS Pro v2.2.3 Map, but I keep getting the error Failed to retrieve a page of rows and I am unsure why this is happening. The layer adds to the map fine (seems to display all 20,000+ polygons), its just when I try to view the Attribute Table that this error appears.
Note it is able to load the column headers in the background, so I am assuming it is a data issue.
The table I am trying to add is a view from a Civica Authority DB (MSSQL 2014 12.0.5207.0), so its not spatially enabled at all.
Has anyone been able to overcome this issue before? Or even know a way for me to troubleshoot the cause?
Solved! Go to Solution.
I'm glad that worked for you with the Query Layer. Had you ever tried to add the same view to ArcMap? If so, did ArcMap ask you to identify the field that would be used as the unique id?
Also what is the field type (e.g. text, numeric - specific type, guid) that you are choosing to be the unique id field when bringing in the Oracle View as a Query Layer to Pro?
I had the same problem in PRO 2.5.2. Creating a query layer worked despite it looking at the same data via the query. My OID is autogenerated unique numeric value.
If you go to the properties of the data layer it appears that ArcGIS Pro by default is choosing the first non-nullable text field as the unique identifier. As my OID is autogenerated it ignores this until I go to properties and edit query layer and chose "OID".
OID is created in SQL using ROW_NUMBER() OVER( order by blah blah blah) +1000000
What a terrible assumption for the programmers to make. OID is my first field in the table and is unique. Why not this?
I make sure that the coordinate fields used to create the spatial view are not null and that there are no spaces in the field names. Geometry is created using GEOMETRY::Point
Seems that query layer with this version is the only way to go.