Problem: Updates made to a check-out replica outside of an ArcMap edit session do not update ArcSDE when synchronizing
Using the ArcToolbox tools, a Python script, or the Field Calculator to update feature classes participating in a check-out replica does not update the parent ArcSDE geodatabase upon synchronizing the check-out. Using these tools within ArcMap while editing the check-out feature class is the only way the updates will synchronize.
When creating a check-out replica to a file or personal geodatabase, system tables are created in the check-out geodatabase. These system tables keep a record of the edits that have been made, so only the edits are sent to the parent ArcSDE geodatabase upon synchronizing (checking in) the check-out replica.
However, the system tables are only updated if changes are made to the check-out feature classes during an ArcMap edit session (or at versions 9.3 and 9.3.1, using the Simple Data Loader in ArcCatalog). For example, if ArcToolbox tools, a Python script, or the Field Calculator are being used to update the check-out feature class outside of an ArcMap edit session, then the changes are not loaded into ArcSDE upon synchronizing the check-out.
Solution or Workaround
Below are three possible ways to update records in the check-out file or personal geodatabase feature classes and synchronize those changes back to ArcSDE:
- Edit the feature classes manually in an ArcMap edit session.
- Use ArcToolbox tools or the Field Calculator from within ArcMap, while editing the check-out feature class in an ArcMap edit session. Save all the edits made with these tools and stop editing, before synchronizing the check-out back to ArcSDE.
- At version 9.3 or 9.3.1, if data needs to be loaded into the check-out replica feature class from another data source, use the Simple Data Loader in ArcCatalog. Loading data into the check-out in this way inserts the new records into the ArcSDE parent geodatabase when synchronizing and does not require editing the feature class in ArcMap. Please note this option does not work at version 9.2.
For more information, see the link on the ArcCatalog Simple Data Loader in the Related Information.