Problem: Unable to display ArcSDE 9.1 feature classes created by GP functions in later ArcGIS versions
Using ArcGIS 9.2 or later versions to perform geoprocessing functions on ArcSDE 9.1, such as loading data, may result in problems displaying, panning, and/or zooming the data. The most common error messages displayed in ArcMap and ArcCatalog are:
"One or more layers failed to draw: <feature class name>: layer is in load-only mode, operation not allowed [<feature class name>]"
"One or more layers failed to draw: <feature class name>: Spatial index does not exist"
"Error: the selected object failed to draw: <featureclass name>: spatial index does not exist"
"Error: layer is in load-only mode, operation not allowed [<feature class name>]".
This is by design and expected behavior. As of ArcGIS 9.2, Spatial index calculations are handled differently than at 9.1. As such, the spatial index is not automatically calculated when ArcGIS 9.2 or a later version is used to create data in an ArcSDE version that is lower than ArcSDE 9.2.
Solution or Workaround
It is recommended that ArcGIS and ArcSDE version levels are used for geoprocessing operations that create data.
Use the following steps to add a spatial index for data that was created in a lower ArcSDE version:
- In ArcCatalog, right-click the feature class and select Properties.
- Select the Indexes tab.
- Click the Recalculate button to calculate default spatial index value(s), or use the Edit button to add your own spatial index value(s).