Bogue
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".
| Numéro d’ID de bogue | BUG-000100911 |
|---|---|
| Envoi | November 18, 2016 |
| Dernière modification | July 14, 2025 |
| S’applique à | ArcSDE/Enterprise Geodatabase |
| Version trouvée | 10.4.1 |
| 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
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.Étapes pour reproduire
ID de bogue: BUG-000100911
Logiciel:
- ArcSDE/Enterprise Geodatabase
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support