laptop and a wrench

Error

ArcGIS Pro is stuck when joining the feature class from a file geodatabase to a table with a million records when the index on the join field on the table side exists, and the index is missing on the same field on the feature class side.

Última publicación: April 14, 2023 ArcGIS Pro
Número de ID del error BUG-000156768
EnviadoMarch 20, 2023
Última modificaciónFebruary 5, 2025
Relacionado conArcGIS Pro
Versión encontrada2.9.3
Sistema operativoWindows OS
Versión de sistema operativo10.0 64 Bit
Versión corregida3.5
EstadoWill Not Be Addressed

Información adicional

The provided workaround is the correct workflow. We already show a performance warning when trying to join unindexed fields. We considered showing a separate warning message or auto-indexing in these cases, but there will also be performance problems with these solutions. The recommendation from the development team is to use the workaround provided.

Solución alternativa

There are 3 options on how to avoid this problem:

  • Create an index on the joined feature class field before the join is added.
  • Drop the index from the table field before the join is added.
  • Keep the 'Index Join Field' checked when a join is being added.

Pasos para reproducir

ID del error: BUG-000156768

Software:

  • ArcGIS Pro

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga