BUG-000121121 for ArcGIS Pro

Bug ID Number	BUG-000121121
Submitted	March 22, 2019
Last Modified	June 25, 2025
Applies to	ArcGIS Pro
Version found	2.3.1
Operating System	Windows OS
Operating System Version	10.0 64 Bit
Status	Will Not Be Addressed

Additional Information

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.

Workaround

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.