PROBLEM

Error getting list of Object IDs returned when opening the attribute table of joined data

Last Published: April 26, 2020

Description

When opening the attribute table of a feature class joined to another feature class or table, the following error message is returned.

Error:   
Error getting list of Object IDs

Cause

There are two possible causes:

  • The spatial index of the feature class being joined to is corrupt.
  • The tables participating in the join do not have primary keys defined.

Solution or Workaround

There are two possible solutions.
  • If the data is in a shapefile, use the ShapeFile Repairer to build a new spatial index. This script can be found in the Related Information section below.
Note:
For the ShapeFile Repairer utility to work correctly, ensure the language setting of the computer matches the language used to create the shapefile.
  1. Using ArcCatalog, right-click the layer and select Properties.
  2. Select the Indexes tab.
  3. Delete the spatial index and create a new one.
  • Using the native software of the tables (Microsoft Access, Microsoft Excel, ArcInfo), verify that the Primary Key is defined. If not, add one.

Article ID:000007087

Software:
  • ArcMap 9 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic