topic Re: Cannot use SQL Server External Table in ArcGIS Pro Questions

Cannot use SQL Server External Table

rboreux — Tue, 11 Feb 2025 11:25:22 GMT

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

Re: Cannot use SQL Server External Table

MobiusSnake — Tue, 11 Feb 2025 13:59:35 GMT

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

Re: Cannot use SQL Server External Table

rboreux — Tue, 11 Feb 2025 14:27:58 GMT

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.

Re: Cannot use SQL Server External Table

rboreux — Tue, 11 Mar 2025 13:00:06 GMT

Dear all,

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

Best,

Simon