Error on a query expression when using the query builder on a joined data using OS authentication schema.

Zusätzliche Informationen

Workaround

ArcMap

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

ArcGIS Pro

1. In ArcGIS Pro, go to the Map tab > Add Data > Add Query Layer.
2. In the New Query window, connect to database with OS Authentication user owned data.
3. Add a name for the QueryLayer (For example: TestQueryLayer)
4. 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.

Schritte zur Reproduzierung