nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot use SQL Server External Table

rboreux

Dear all,

I have an ArcGIS Enterprise 11.3 deployed in Azure with a geodatabase installed on SQL Server (Microsoft SQL Azure (RTM) - 12.0.2000.8).

In this database, we configured a External Data Source to access external tables in another SQL Server databse.

In Miscrosoft SQL Server Management Studio, I can query those external tables. I can also query it through Excel with an ODBC connection.

In ArcGIS Pro, I can see the external tables in the catalog but when I try to add it in the content pane, I get the following error :

"Underlying DBMS error[[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Internal Query Processor Error: The query processor could not produce a query plan"

Does someone knows if it's possible to achieve what we are trying to do ?

Thank you in advance,

Best regards,

Simon

Find more posts tagged with

Accepted answers

rboreux

Dear all,

I found the reason. ArcGIS Pro needed to find a field with unique value in the external table.

Best,

Simon

All comments

rboreux

Dear all,

I found the reason. ArcGIS Pro needed to find a field with unique value in the external table.

Best,

Simon

rboreux

Hello MobiusSnake,

Thank you for your quick answser. Yes I did but I get the same error. I also tried to create a view directly from SQL Server Manager and query it in ArcGIS Pro, but I'm facing the same issue.

MobiusSnake

I'm not really familiar with External Data Sources, but have you tried adding the tables from them to Pro using a Query Layer rather than directly from Catalog?

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.