Repair Version Metadata (Data Management)


Repairs inconsistencies within the versioning system tables of a versioned geodatabase.


  • Run the Diagnose Version Metadata tool to determine if there are inconsistencies in your geodatabase's versioning tables before you run the Repair Version Metadata tool.

  • This tool can only be run against an enterprise geodatabase.

  • This tool is not supported for geodatabases in SAP HANA.

  • Only the geodatabase administrator can run the Repair Version Metadata tool.

  • Always create a database backup before running the Repair Version Metadata tool.


RepairVersionMetadata(input_database, out_log)
ParameterExplanationData Type

Provide a database connection (.sde file) to the enterprise geodatabase for which you want to repair inconsistencies in the versioning system tables. The connection must be made as the geodatabase administrator.


The output log file. The log file is an ASCII file containing the results of the repair operation.


Derived Output

NameExplanationData Type

The repaired geodatabase.


Code sample

RepairVersionMetadata sample 1 (Python window)

You can alter and run the following from a Python window to repair inconsistencies in the version system tables.

This example connects through the database connection file productiongdb.sde.

import arcpy

input_database = "c:\\myconnections\\productiongdb.sde"
out_log = "c:\\temp\\gdb_repair.log"
arcpy.RepairVersionMetadata_management(input_database, out_log)
RepairVersionMetadata sample 2 (stand-alone script)

The following is a stand-alone script you can alter and run to repair inconsistencies in the version system tables.

# Set the necessary product code
import arceditor
# Import arcpy module
import arcpy

# Local variables:
input_database = "c:\\myconnections\\productiongdb.sde"
out_log = "c:\\temp\\gdb_repair.log"

# Process: Repair Version Metadata
arcpy.RepairVersionMetadata_management(input_database, out_log)


Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes

Related topics