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

DiagnoseVersionMetadata(input_database, out_log)

Parameter	Explanation	Data 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

Name	Explanation	Data 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

Current Workspace

Licensing information

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