English

Error: Schema is out of date, retry as owner or sdeadmin

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.