Skip To Content

Diagnose Version Metadata


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_management (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.


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"
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


Licensing information

  • ArcGIS Desktop Basic: No
  • ArcGIS Desktop Standard: Yes
  • ArcGIS Desktop Advanced: Yes