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, 2016ArcSDE/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.