NIM004656 for No Product Found

Bug ID Number	NIM004656
Submitted	October 5, 2006
Last Modified	June 5, 2024
Applies to	No Product Found
Version found	9.2
Version Fixed	N/A
Status	Fixed

Description

A feature class stored in an ArcSDE geodatabase is placed in load-only I/O mode and the spatial index is dropped when one of the following operations is performed:

▪ The spatial index is deleted from within the Indexes tab of the Feature Class Properties dialog box in ArcCatalog.

or

▪ The sdelayer -o load_only_io command is run against the feature class.

If a seperate connection is made to the geodatabase from ArcCatalog after the feature class has been placed in load-only I/O mode, the Indexes tab of the Feature Class Properties dialog box shows the feature class still has a spatial index even though the spatial index was dropped.

Cause

This is a known issue. It has been fixed in ArcGIS 9.3.1 Service Pack 1 and 10.

Workaround

To be sure a feature class is in load-only I/O mode and that the spatial index has been deleted, run the sdelayer -o describe_long command.

From a command prompt, execute sdelayer with the describe_long operation.

The following example requests a description of a feature class named streets:

Code:
sdelayer -o describe_long -O dbo -l streets,shape -i sde_prod -s beaufort -D prod

This returns a list of properties describing the feature class. Check the values for the Spatial Index property 'exist' and the property 'I/O Mode'; the values should be 'No' and 'LOAD' respectively.

The properties returned for the streets feature class are as follows:

Layer    Administration Utility
-----------------------------------------------------
Layer Description ....: <None>
Database              : PROD
Table Owner ..........: DBO
Table Name ...........: STREETS
Spatial Column .......: SHAPE
Layer Id .............: 241
SRID .................: 53
Minimum Shape Id .....: 1
Offset ...............:
  falsex: -119670466.771485
  falsey:  -95612605.493381
System Units .........:   31999999.970198
Z Offset..............:          0.000000
Z Units ..............:          1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .:          0.000256
Spatial Index ........:
  parameter:    SPIDX_GRID,GRID0=1200,FULL
  exist:        No
  array form:   1200,0,0
Layer Envelope .......:
  minx:   1837251.62494,        miny:    763253.12502
  maxx:   1856706.00013,        maxy:    776741.56253
Entities .............: nslc+
Layer Type ...........: SDE
Creation Date ........: 11/20/06 08:50:51
I/O Mode .............: LOAD
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: PROJCS["NAD_1983_StatePlane_Ohio_South_FIPS_3402_Feet",G
EOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980
",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.017453292519
9433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0
],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER[
"Standard_Parallel_1",38.73333333333333],PARAMETER["Standard_Parallel_2",40.0333
3333333333],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Foot_US",0.30480060960121
92]]

Note:
For more information on using the sdelayer command, consult the ArcSDE administration command reference.

Steps to Reproduce

Bug ID: NIM004656

Software:

No Product Found

Related Information

ArcGIS 9.3.1 Service Pack 1

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options