Bug
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".
| Bug-ID-Nummer | BUG-000100911 |
|---|---|
| Eingereicht | November 18, 2016 |
| Zuletzt geändert | July 14, 2025 |
| Gilt für | ArcSDE/Enterprise Geodatabase |
| Gefunden in Version | 10.4.1 |
| Status | Will Not Be Addressed |
Zusätzliche Informationen
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
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.Schritte zur Reproduzierung
Bug-ID: BUG-000100911
Software:
- ArcSDE/Enterprise Geodatabase
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen