Diagnose Version Metadata (Data Management)

Summary

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

Usage

• This tool can be run on enterprise geodatabases.

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

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

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

Parameters

Dialog

Label	Explanation	Data Type
Input Database Connection	The database connection (.sde file) to the enterprise geodatabase in which traditional versioning system table inconsistencies may exist. The connection must be made as the geodatabase administrator.	Workspace
Diagnostic Version Metadata Log	The name and location of the output log file. The log file is an ASCII file containing a list of the system tables in the specified version that contain inconsistent records, as well as the database connection file used.	File

Derived Output

Label	Explanation	Data Type
Updated Input Workspace	The updated input workspace.	Workspace

Python

arcpy.management.DiagnoseVersionMetadata(input_database, out_log)

Name	Explanation	Data Type
input_database	The database connection (.sde file) to the enterprise geodatabase in which traditional versioning system table inconsistencies may exist. The connection must be made as the geodatabase administrator.	Workspace
out_log	The name and location of the output log file. The log file is an ASCII file containing a list of the system tables in the specified version that contain inconsistent 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 productiongdb.sde database connection file 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