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)
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.
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)
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)
- ArcGIS Desktop Basic: No
- ArcGIS Desktop Standard: Yes
- ArcGIS Desktop Advanced: Yes