ERROR

Schema is out of date, retry as owner or sdeadmin

Last Published: April 25, 2020

Error Message

If a user other then the owner of the data source attempts to open the feature class or table in ArcCatalog, an error message may occur if the table's schema has been modified in the DBMS.

"Schema is out of date, retry as owner or sdeadmin."

Cause

If a user other then the owner of the data source attempts to open the feature class or table in ArcCatalog, an error message may occur if the table's schema has been modified in the DBMS.

For example, if user admin owns the table parcels and adds a new column named last_owner in the DBMS, not by way of ArcGIS, any user other then admin who attempts to open the table in ArcCatalog or queries the table with ArcObjects, and so forth, encounters the error message.

Solution or Workaround

The owner of the data source must be the first user who opens the table in ArcCatalog, or open the table once the error has been encountered by any other users.

The process of opening the table by the data source owner, correctly updates ArcGIS's metadata about the table's columns; these are maintained in the ArcSDE table column_registry.

Add new columns to data sources by way of ArcCatalog to avoid this problem.

    Article ID:000007970

    Software:
    • ArcMap 9 x
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic