laptop and a wrench

Error

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

Última publicación: April 25, 2019 ArcGIS Pro
Número de ID del error BUG-000121121
EnviadoMarch 22, 2019
Última modificaciónJune 25, 2025
Relacionado conArcGIS Pro
Versión encontrada2.3.1
Sistema operativoWindows OS
Versión de sistema operativo10.0 64 Bit
EstadoWill Not Be Addressed

Información adicional

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.

Solución alternativa

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.

Pasos para reproducir

ID del error: BUG-000121121

Software:

  • ArcGIS Pro

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga