BUG-000121121 for ArcGIS Pro

Numéro d’ID de bogue	BUG-000121121
Envoi	March 22, 2019
Dernière modification	June 25, 2025
S’applique à	ArcGIS Pro
Version trouvée	2.3.1
Système d’exploitation	Windows OS
Version du système d’exploitation	10.0 64 Bit
Statut	Will Not Be Addressed

Informations supplémentaires

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

Solution de contournement

ArcMap

In ArcMap, go to the File tab > Add Data > Add Query Layer.
In the New Query window, connect to a database with OS Authentication user owned data.
Add a name for the QueryLayer (For example: TestQueryLayer)
Insert SQL Query in the Query box.

ArcGIS Pro

In ArcGIS Pro, go to the Map tab > Add Data > Add Query Layer.
In the New Query window, connect to database with OS Authentication user owned data.
Add a name for the QueryLayer (For example: TestQueryLayer)
Insert SQL Query in the Query box.

SQL example including table join:

select a.objectid, a.shape, a.field1, b.field2

from <server>.<database>.<OS Authentication>.<featureclass> a,

<server>.<database>.<OS Authentication>.<datatable> b,

where a.OBJECTID = b.id

and b.field2 = 'thing'

Ensure to include the ObjectID and Shape fields of the feature class. Use whatever amount of fields needed from the feature class and data tables, "field1" and "field2" are a simplified example.

OR

Migrate from OS Authentication to Database Authentication.