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 Support アプリのダウンロード

このトピックについてさらに調べる

ArcGIS エキスパートのサポートを受ける

テクニカル サポートへのお問い合わせ

Esri Support アプリのダウンロード

ダウンロード オプションに移動