Error
The Select by Attributes tool fails on a joined query layer when using an OS authenticated user that is not a member of the sysadmin role, and returns the following error message, "An Invalid SQL Statement Was Used".
| Número de ID del error | BUG-000100911 |
|---|---|
| Enviado | November 18, 2016 |
| Última modificación | July 14, 2025 |
| Relacionado con | ArcSDE/Enterprise Geodatabase |
| Versión encontrada | 10.4.1 |
| Estado | Will 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
Option 1: This behavior is not reproducible when using a database user that is associated with a Windows login in SQL Server. The workflow is successful and a Select by Attributes can be done on the query layer.Option 2: This is not reproducible using a database authenticated user. When using a database authenticated user, this workflow is successful and a Select by Attributes can be done on the query layer.Option 3: This is not reproducible when using an OS Authenticated user that is a member of the sysadmin role. This workflow is successful and a Select by Attributes can be done on the query layer.Pasos para reproducir
ID del error: BUG-000100911
Software:
- ArcSDE/Enterprise Geodatabase
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri