BUG-000123738 for ArcGIS Pro

Número de ID do Erro	BUG-000123738
Enviado	July 16, 2019
Última Modificação	September 19, 2024
Aplica-se à	ArcGIS Pro
Versão encontrada	2.4
Sistema Operacional	Windows OS
Versão do Sistema Operacional	10.0 64 Bit
Status	Known Limit

Informações Adicionais

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

Solução Provisória

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