BUG-000121121 for ArcGIS Pro

不具合 ID 番号	BUG-000121121
送信されました	March 22, 2019
最終更新日	June 25, 2025
適用対象	ArcGIS Pro
見つかったバージョン	2.3.1
オペレーティングシステム	Windows OS
オペレーティングシステムのバージョン	10.0 64 Bit
ステータス	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.

対処法

ArcMap

In ArcMap, go to the File tab > Add Data > Add Query Layer.
In the New Query window, connect to a database with OS Authentication user owned data.
Add a name for the QueryLayer (For example: TestQueryLayer)
Insert SQL Query in the Query box.

ArcGIS Pro

In ArcGIS Pro, go to the Map tab > Add Data > Add Query Layer.
In the New Query window, connect to database with OS Authentication user owned data.
Add a name for the QueryLayer (For example: TestQueryLayer)
Insert SQL Query in the Query box.

SQL example including table join:

select a.objectid, a.shape, a.field1, b.field2

from <server>.<database>.<OS Authentication>.<featureclass> a,

<server>.<database>.<OS Authentication>.<datatable> b,

where a.OBJECTID = b.id

and b.field2 = 'thing'

Ensure to include the ObjectID and Shape fields of the feature class. Use whatever amount of fields needed from the feature class and data tables, "field1" and "field2" are a simplified example.

OR

Migrate from OS Authentication to Database Authentication.