ERROR

Delete feature: An unexpected failure occurred.DBMS table not found[database.schema.table][state_id=####]

Last Published: April 25, 2020

Error Message

When editing a feature class with a missing or corrupted i-table, an error message similar to the following is returned:
"Delete feature: An unexpected failure occurred.DBMS table not found[territory.SDE_USER.Alumbra][state_id=4622]".

This applies only to SQL SERVER databases.

Cause

If the i-table of a feature class has been manually deleted or corrupted, valid ROWID and shape identifiers cannot be generated, resulting in an error message.

Solution or Workaround

Verify that the i-table is either missing or corrupted. Delete the i-table if it has been corrupted. Upgrade the geodatabase by running either the sdesetup –o upgrade command or the repository setup option from the Post Installation wizard. ArcSDE automatically generates a new, valid i-table.

    Article ID:000010504

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Esri Community

    Search for related information

    Training

    Find training related to this topic

    ArcGIS Ideas

    Explore ideas and give feedback

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options