Unable to compress state tree

Last Published: April 25, 2020

Error Message

This problem is addressed in ArcGIS 8.1 Service Pack 1. See the Related Information section to download this pack.

Using DB2, compression fails when the SDE.STATES table has 202 states.


An error inside the DB_sp_states_def_delete function causes the compression to fail when SDE.STATES table has exactly 202 states (also fails for 402, 602, 200xN+2, etc.).

Solution or Workaround

Download Service Pack 1.

Article ID:000004090

  • Legacy Products
  • ArcMap 8 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