Error
The Calculate Field tool does not honor active selections and layer filters when using a SQL expression on file geodatabase data, resulting in calculations on all rows.
| Número de ID del error | BUG-000176644 |
|---|---|
| Enviado | May 21, 2025 |
| Última modificación | July 2, 2025 |
| Relacionado con | ArcGIS Pro |
| Versión encontrada | 3.5 |
| Sistema operativo | N/A |
| Versión de sistema operativo | N/A |
| Versión corregida | 3.6, 3.5.1 |
| Estado | Fixed |
Información adicional
ArcGIS Pro 3.5 and ArcGIS Server 11.5 introduced the ability to set the expression type to SQL in the Calculate Field geoprocessing tool when working with file geodatabase (.gdb) data. This patch addresses a potential data corruption bug has been identified wherein the Calculate Field Geoprocessing tool does not honor the active selection or layer filters (for example a layer generated from the base table via MakeFeatureLayer) when using a SQL expression on file geodatabase data, resulting in all rows being calculated. This patch is now available at https://support.esri.com/en-us/patches-updates/2025/arcgis-server-11-5-calculate-field-patch. This issue is addressed in ArcGIS Pro 3.6 and 3.5.1 and the ArcGIS Server 11.5 Calculate Field Patch available here: https://support.esri.com/en-us/patches-updates/2025/arcgis-server-11-5-calculate-field-patch.Solución alternativa
Do not use SQL as the expression type until this issue is addressed with a patch. Use Python, Arcade, or VBScript as the expression type.
To preserve the original values, make a copy of the input table as a backup, or use the Enable Undo option in the Geoprocessing pane.
Pasos para reproducir
ID del error: BUG-000176644
Software:
- ArcGIS Pro
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri