Repair Version Metadata (Data Management)

Summary

Repairs inconsistencies in the versioning system tables of a geodatabase that contains traditional versions.

Usage

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

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

• This tool does not support geodatabases in SAP HANA because they don't support traditional versioning.

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

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

Parameters

Dialog

Label	Explanation	Data Type
Input Database Connection	The database connection (.sde file) to the enterprise geodatabase in which versioning system table inconsistencies exist. The connection must be made as the geodatabase administrator.	Workspace
Repair Version Metadata Log	The output log file. The log file is an ASCII file containing the results of the repair operation.	File

Derived Output

Label	Explanation	Data Type
Updated Input Workspace	The repaired geodatabase.	Workspace

Python

arcpy.management.RepairVersionMetadata(input_database, out_log)

Name	Explanation	Data Type
input_database	The database connection (.sde file) to the enterprise geodatabase in which versioning system table inconsistencies exist. The connection must be made as the geodatabase administrator.	Workspace
out_log	The output log file. The log file is an ASCII file containing the results of the repair operation.	File

Derived Output

Name	Explanation	Data Type
out_workspace	The repaired geodatabase.	Workspace

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 productiongdb.sde database connection file.

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)

Environments

Current Workspace

Licensing information

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