Diagnose Version Metadata (Data Management)

Summary

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

Usage

  • 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.

Syntax

arcpy.management.DiagnoseVersionMetadata(input_database, out_log)
ParameterExplanationData Type
input_database

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.

Workspace
out_log

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.

File

Derived Output

NameExplanationData Type
out_workspace

The updated input workspace.

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)

Environments

Licensing information

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

Related topics