0

I am attempting to add a query layer to ArcGIS Pro 2.1.2 via SQL Server. The table consists of Ticket_ID, Latitude, Longitude. The query layer works if I only add the top 1000 rows. However, when I attempt to add all 79,592 rows, I keep returning the error: Failed to load data. Error: Failed to retrieve a page of rows.

Does ArcGIS Pro have a limit on query layer rows?

Improve this question
4
  • 4
    Is the TicketID field unique? Note that a Query Layer has a geometry column, so you're attempting a Query Table. I regularly work with 10m-40m row tables, so no there isn't a limit. Commented Nov 29, 2018 at 12:24
  • No, the TicketID field has duplicate values. Is this what is causing it to fail? Commented Nov 29, 2018 at 12:29
  • The duplicate ticketID values were the issue. Thank you. Commented Nov 29, 2018 at 12:37
  • Are your parameters defined appropriately? pro.arcgis.com/en/pro-app/help/data/query-layers/… Commented Dec 15, 2019 at 19:04

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.