Esri International User Conference San Diego CA Demo

Esri International User Conference | San Diego, CA Demo Theater | July 13 th, 2011 Tips & Tricks for Troubleshooting Geodatabase Issues at Arc. GIS 10 Chet Dobbins Nana Y. Dei

Topics: • Upgrading the geodatabase (v 10. 0) • Compressing with Replicas …we can’t compress… • SDEINTERCEPT • Additional Troubleshooting Resources …how do I upgrade…

Upgrading the Geodatabase

Enterprise Geodatabase Upgrade - Arc. GIS 10. 0

Before Upgrading… • • • Backup DBMS and configuration files - DBMS full backup & configuration files - DBTUNE, DBINIT, GIOMGR Install an Arc. GIS 10 client - Upgrade integrated into client - Backwards compatible Requirement - Direct connect - Proper credentials

Prerequisite Checks • No active user connections • Correct user to perform upgrade • Required privileges for upgrade • DBMS XML support • Geodatabase schema integrity • Geodatabase configuration check - ST shape library - Multiple user schema geodatabases Install Arc. GIS 10 Client Application Server? no Pre-requisite Check Upgrade Geodatabase Schema Post Upgrade Configuration Upgrade Arc. SDE yes Application

Geodatabase Upgrade Options • Two options - • Upgrade Geodatabase button in Arc. Catalog Upgrade Geodatabase: GP Tool API - Upgrade. GDB_management(…)

Upgrade Resources • Arc. SDE Install Guides - • KB Articles - • http: //resources. arcgis. com/content/kbase Online Help - • http: //resources. arcgis. com/content/geodatabases/10. 0/arcsde -installation-guides http: //help. arcgis. com/en/arcgisdesktop/10. 0/help/index. html Arc. SDE Geodatabase User Forum - http: //forums. arcgis. com/forums/32 -Geodatabase-amp-Arc. SDE

Compressing with Replicas

Types of Replicas Check out/ Check in Once only Parent Child Multiple times One-way Parent OR Child Multiple times Two-way Parent Child

Compress with a One-way Replica Default 1 2 3 4 3 Project 1 Replica 1 COMPRESS 1 2 3 4 3

Compress with a Two-way Replica Parent Default Child 1 2 3 Default 4 Replica 2 COMPRESS 1 2 3 4 3

Best Practices • Remove unnecessary replicas • Send changes regularly • Reconcile & Post named versions before synchronizing • Full compress is ideal but not always possible - Look to achieve an effective compress

SDEINTERCEPT Tracing

SDEINTERCEPT • Built-in Arc. SDE functionality • Logs Arc. SDE client - server calls • Helps diagnose connection & performance issues • Enable SDEINTERCEPT by setting the following environment variables: - set SDEINTERCEPT=crw. Tf - set SDEINTERCEPTLOC=C: tempsde_intercept Flag Description c Intercept the API command name r Intercept the Channel broadcasts read-only w Intercept the Channel broadcasts write-only t Intercept log time (minute: second) T Intercept log time (hour: minute: second) f Intercept flush immediate

SDEINTERCEPT Output ==================== [W 14: 30: 54. 582] Command: Query. With. Info Command name [W 14: 30: 54. 582] Long: 1 [W 14: 30: 54. 582] Query Info: Num Columns: 1 Queried tables & columns Columns: "Shape" SQL_Construct: [1] Tables: "scratch. MAP. STATES" Where. Clause: "STATE_NAME LIKE 'C%'" WHERE & ORDER BY Query Type: 4 Clauses, query type By. Clause: <null> Num Hints: 0 Num Parameter markers: 0 Logfile: <null> [R 14: 30: 54. 582] Long: 0 Response: Description [R 14: 30: 54. 582] Col_Defines: [1] of columns returned

Additional Troubleshooting Resources

Monitoring Tools • SDEINTERCEPT - • SDETRACE - • Logs the calls from the client application to the Arc. SDE C-API Execute. SQL - • Monitors commands generated by the Arc. SDE client library Control database SQL Traces from the Arc. GIS client Database SQL Traces - Records SQL received by the database engine, and what processing occurred in response to each request.

Diagnostic Tools • Arc. SDE Error Messages - • SDEVERBOSE - • Monitoring, investigating and reporting Replica Activity Logs - • Logs errors/messages to sde_<instance>. log Geodatabase Toolset (GDBT) - • Arc. SDE errors/messages received on the client or in the logs Records information for replica creation / synchronization sdegdbrepair - Identifies and repairs any inconsistencies

Online Resources • Arc. GIS Resource Center - • Arc. GIS Web-based Help - • http: //resources. arcgis. com/content/web-based-help Forums - • http: //resources. arcgis. com/ http: //forums. arcgis. com/forums/32 -Geodatabase-amp-Arc. SDE Blogs - http: //blogs. esri. com/Dev/blogs/geodatabase/default. aspx