laptop and a wrench

漏洞

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".

上次发布: November 21, 2016 ArcSDE/Enterprise Geodatabase
漏洞 ID 编号 BUG-000100911
已提交November 18, 2016
上次修改时间July 14, 2025
适用范围ArcSDE/Enterprise Geodatabase
找到的版本10.4.1
状态Will Not Be Addressed

附加信息

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.

解决办法

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.

重现步骤

漏洞 ID: BUG-000100911

软件:

  • ArcSDE/Enterprise Geodatabase

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项