tips & tricks for troubleshooting geodatabase issues at arcgis 10
DESCRIPTION
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…. - PowerPoint PPT PresentationTRANSCRIPT
Esri International User Conference | San Diego, CA
Demo Theater |
Tips & Tricks for TroubleshootingGeodatabase Issues at ArcGIS 10
Chet Dobbins
Nana Y. Dei
July 13th, 2011
Topics:
• Upgrading the geodatabase (v10.0)
• Compressing with Replicas
• SDEINTERCEPT
• Additional Troubleshooting Resources
…we can’t compress…
…how do I upgrade…
Upgrading the Geodatabase
Enterprise Geodatabase Upgrade - ArcGIS 10.0
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
• 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
InstallArcGIS 10
Client
Pre-requisiteCheck
UpgradeArcSDE
Application
UpgradeGeodatabase
Schema
Post Upgrade
Configuration
ApplicationServer? yes
no
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
Compressing with Replicas
Types of Replicas
One-way
Two-way
Check out/ Check in Parent Child
Once only
Multiple times
Parent Child
Parent Child
OR
Multiple times
Compress with a One-way Replica
1 2 3Default
Project 1 Replica 11 2
4
1 2 3
3
4
43
COMPRESS
3
Compress with a Two-way Replica
1 2 3Default
Replica 2
1 2
4
3Default
Replica 2
34
COMPRESS COMPRESS
Parent Child
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 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_interceptFlag 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: QueryWithInfo[W 14:30:54.582] Long: 1[W 14:30:54.582] Query Info:
Num Columns: 1Columns: "Shape"SQL_Construct: [1]Tables: "scratch.MAP.STATES"WhereClause: "STATE_NAME LIKE 'C%'"Query Type: 4ByClause: <null>Num Hints: 0Num Parameter markers: 0Logfile: <null>
[R 14:30:54.582] Long: 0[R 14:30:54.582] Col_Defines: [1]
========================================[W 14:30:54.582] Command: QueryWithInfo[W 14:30:54.582] Long: 1[W 14:30:54.582] Query Info:
Num Columns: 1Columns: "Shape"SQL_Construct: [1]Tables: "scratch.MAP.STATES"WhereClause: "STATE_NAME LIKE 'C%'"Query Type: 4ByClause: <null>Num Hints: 0Num Parameter markers: 0Logfile: <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
Additional Troubleshooting Resources
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