Diagnose Version Metadata (Data Management)


Identifies inconsistencies within the system tables used to manage versions and states in a versioned geodatabase.


  • This tool can be run against enterprise geodatabases.

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

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

  • This tool is usually run at the direction of Esri support.


DiagnoseVersionMetadata(input_database, out_log)
ParameterExplanationData Type

Provide a database connection (.sde file) to the enterprise geodatabase you suspect contains inconsistencies in the versioning system tables.

The connection must be made as the geodatabase administrator.


Specify a log file name and location where the tool will create the file.

The log file is an ASCII file containing a list of the system tables in the specified version that contain orphaned records, as well as the database connection file used.


Derived Output

NameExplanationData Type

The updated input workspace.


Code sample

DiagnoseVersionMetadata sample 1 (Python window)

You can alter and run the following from a Python window to discover if inconsistencies exist in the versioning system tables and export those messages to a log file.

This example connects through the database connection file productiongdb.sde and exports a file named gdb_diagnose.log to the temp directory.

import arcpy

input_database = "c:\\myconnections\\productiongdb.sde"
out_log = "c:\\temp\\gdb_diagnose.log"
arcpy.DiagnoseVersionMetadata_management(input_database, out_log)
DiagnoseVersionMetadata sample 2 (stand-alone script)

The following is a stand-alone script you can alter and run to export versioning system tables inconsistencies to a log file.

# 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_diagnose.log"

# Process: Diagnose Version Metadata
arcpy.DiagnoseVersionMetadata_management(input_database, out_log)


Licensing information

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

Related topics