BUG-000123738 for ArcGIS Pro

不具合 ID 番号	BUG-000123738
送信されました	July 16, 2019
最終更新日	September 19, 2024
適用対象	ArcGIS Pro
見つかったバージョン	2.4
オペレーティングシステム	Windows OS
オペレーティングシステムのバージョン	10.0 64 Bit
ステータス	Known Limit

参考情報

This is related to BUG-000125149 and a known limitation. This issue is related to the use of a text field to create a temporary ObjectID field. All tables must have something that uniquely identifies each record. If there is no unique integer column, ArcGIS can generate one on the fly from one or more input columns. However, most queries return an ObjectID that links their results back to the map or table being viewed in ArcGIS. Queries that are passed down to the DBMS have no way of returning the ArcGIS-generated ObjectID. While the query returns accurate results, they cannot be correctly linked back to data in the map. A solution is to add the table as a query layer based on a query that generates an integer ObjectID field by using a windowing function: select isnull(CAST(ROW_NUMBER() OVER(ORDER BY blm_org_cd asc) AS INT),0) AS OBJECTID, blm_org_cd, long_desc, dist_short_nm from dbo.lu_blm_org_cd

対処法

Place and register the table inside the geodatabase. Creating the table in the geodatabase but not registering it results in the failure of the Select by Attributes tool.
Use ArcMap 10.5.1. if working with a non-geodatabase