210 likes | 551 Views
July 13 th , 2011. Tips & Tricks for Troubleshooting Geodatabase Issues at ArcGIS 10. Chet Dobbins Nana Y. Dei. Topics:. Upgrading the geodatabase (v10.0) Compressing with Replicas SDEINTERCEPT Additional Troubleshooting Resources. …how do I upgrade…. …we can’t compress….
E N D
July 13th, 2011 Tips & Tricks for TroubleshootingGeodatabase Issues at ArcGIS 10 Chet Dobbins Nana Y. Dei
Topics: • Upgrading the geodatabase (v10.0) • Compressing with Replicas • SDEINTERCEPT • Additional Troubleshooting Resources …how do I upgrade… …we can’t compress…
Before Upgrading… • Backup DBMS and configuration files • DBMS full backup & configuration files • DBTUNE, DBINIT, GIOMGR • Install an ArcGIS 10 client • Upgrade integrated into client • Backwards compatible • Requirement • Direct connect • Proper credentials
Prerequisite Checks Install ArcGIS 10 Client • 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 Application Server? Upgrade ArcSDE Application • yes • no Pre-requisite Check Upgrade Geodatabase Schema Post Upgrade Configuration
Geodatabase Upgrade Options • Two options • Upgrade Geodatabase button in ArcCatalog • Upgrade Geodatabase: GP Tool API • UpgradeGDB_management(…)
Upgrade Resources • ArcSDE Install Guides • http://resources.arcgis.com/content/geodatabases/10.0/arcsde-installation-guides • KB Articles • http://resources.arcgis.com/content/kbase • Online Help • http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html • ArcSDE Geodatabase User Forum • http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE
Types of Replicas Once only Check out/ Check in Parent Child Multiple times One-way OR Parent Child Multiple times Two-way Parent Child
Compress with a One-way Replica Default 1 2 3 4 1 2 3 Project 1 Replica 1 1 2 3 3 4 3 4 COMPRESS
Compress with a Two-way Replica Parent Child Default 1 2 3 Default 1 2 3 3 4 4 Replica 2 Replica 2 COMPRESS COMPRESS
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 • Built-in ArcSDE functionality • Logs ArcSDE client - server calls • Helps diagnose connection & performance issues • Enable SDEINTERCEPT by setting the following environment variables: • set SDEINTERCEPT=crwTf • set SDEINTERCEPTLOC=C:\temp\sde_intercept
SDEINTERCEPT Output ======================================== [W 14:30:54.582] Command: QueryWithInfo [W 14:30:54.582] Long: 1 [W 14:30:54.582] Query Info: Num Columns: 1 Columns: "Shape" SQL_Construct: [1] Tables: "scratch.MAP.STATES" WhereClause: "STATE_NAME LIKE 'C%'" Query Type: 4 ByClause: <null> Num Hints: 0 Num Parameter markers: 0 Logfile: <null> [R 14:30:54.582] Long: 0 [R 14:30:54.582] Col_Defines: [1] Command name Queried tables & columns WHERE & ORDER BY Clauses, query type Response: Description of columns returned
Monitoring Tools • SDEINTERCEPT • Monitors commands generated by the ArcSDE client library • SDETRACE • Logs the calls from the client application to the ArcSDE C-API • ExecuteSQL • Control database SQL Traces from the ArcGIS client • Database SQL Traces • Records SQL received by the database engine, and what processing occurred in response to each request.
Diagnostic Tools • ArcSDE Error Messages • ArcSDE errors/messages received on the client or in the logs • SDEVERBOSE • Logs errors/messages to sde_<instance>.log • Geodatabase Toolset (GDBT) • Monitoring, investigating and reporting • Replica Activity Logs • Records information for replica creation / synchronization • sdegdbrepair • Identifies and repairs any inconsistencies
Online Resources • ArcGIS Resource Center • http://resources.arcgis.com/ • ArcGIS Web-based Help • http://resources.arcgis.com/content/web-based-help • Forums • http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE • Blogs • http://blogs.esri.com/Dev/blogs/geodatabase/default.aspx