Transcript Title Safe Area — Please Read

Esri International User Conference | San Diego, CA
Demo Theater | July 13th, 2011
Tips & Tricks for Troubleshooting
Geodatabase Issues at ArcGIS 10
Chet Dobbins
Nana Y. Dei
Topics:
•
Upgrading the geodatabase (v10.0)
•
Compressing with Replicas
…we can’t
compress…
•
SDEINTERCEPT
•
Additional Troubleshooting Resources
…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
Install
ArcGIS 10
Client
• 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?
no
Pre-requisite
Check
Upgrade
Geodatabase
Schema
Post
Upgrade
Configuration
Upgrade
ArcSDE
yes
Application
Geodatabase Upgrade Options
•
Two options
-
•
Upgrade Geodatabase button in ArcCatalog
Upgrade Geodatabase: GP Tool API
-
UpgradeGDB_management(…)
Upgrade Resources
•
ArcSDE 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
ArcSDE Geodatabase User Forum
-
http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE
Compressing with Replicas
Types of Replicas
Once only
Check out/
Check in
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
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
Replica 2
COMPRESS
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 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
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:
QueryWithInfo
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"
WhereClause: "STATE_NAME LIKE 'C%'"
WHERE & ORDER BY
Query Type: 4
Clauses, query type
ByClause:
<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 ArcSDE C-API
ExecuteSQL
-
•
Monitors commands generated by the ArcSDE client library
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
-
•
SDEVERBOSE
-
•
Monitoring, investigating and reporting
Replica Activity Logs
-
•
Logs errors/messages to sde_<instance>.log
Geodatabase Toolset (GDBT)
-
•
ArcSDE errors/messages received on the client or in the logs
Records information for replica creation / synchronization
sdegdbrepair
-
Identifies and repairs any inconsistencies
Online Resources
•
ArcGIS Resource Center
-
•
ArcGIS Web-based Help
-
•
http://resources.arcgis.com/content/web-based-help
Forums
-
•
http://resources.arcgis.com/
http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE
Blogs
-
http://blogs.esri.com/Dev/blogs/geodatabase/default.aspx