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.