Erro
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 do Erro | BUG-000100911 |
|---|---|
| Enviado | November 18, 2016 |
| Última Modificação | July 14, 2025 |
| Aplica-se à | ArcSDE/Enterprise Geodatabase |
| Versão encontrada | 10.4.1 |
| Status | Will Not Be Addressed |
Informações Adicionais
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.Solução Provisória
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.Etapas para Reproduzir
ID do Erro: BUG-000100911
Software:
- ArcSDE/Enterprise Geodatabase
Seja notificado quando o status de um erro mudar
Descubra mais sobre este tema
Procurar por informações relacionadas
Encontre treinamento relacionado a este tópico
Explore idéias e forneça comentários
Obtenha ajuda de especialistas do ArcGIS
Baixe o Aplicativo de Suporte da Esri