Question
How do you turn on verbose logging in ArcGIS for Desktop when doing a direct connection to an enterprise geodatabase?
Question
How do you turn on verbose logging in ArcGIS for Desktop when doing a direct connection to an enterprise geodatabase?
The term ArcSDE/SDE is being gradually replaced with the term “Multiuser Geodatabase” and this is probably creating some confusion among the users of the ArcGIS platform. In order to understand the difference between ArcSDE and multiuser geodatabase, let’s start clarifying what is and what is not ArcSDE.
What is not ArcSDE:
ArcSDE is not a product. It’s a technology. In the same way ArcGIS is not a product, is a platform. Only prior to ArcGIS 9.2, ArcSDE was a standalone software product. At the ArcGIS 9.2 release, ArcSDE was integrated into both ArcGIS for Desktop and ArcGIS for Server.
ArcSDE is not only the application sever connection, a piece of software that packs the giomgr.exe and a gsrv.exe processes. This is a common mistake that I have mentioned in my previous post but from a more business perspective. I’ll try to do the same exercise now but from a technical perspective.
So, what is ArcSDE – also called “the database enhanced with the ArcSDE technology” or simply the “ArcSDE geodatabase” or the “Multiuser geodatabase”?
Let’s answer this question step by step.
This is a recurrent question in my geodatabase seminars.
“ArcSDE” is a concept that has always created some confusion, and part of the reason is, I think, due to how ArcSDE has evolved overtime.
I have seen that some users tend to associate the concept ArcSDE with the “application service connections” which has been deprecated in 10.3. Sometimes, I see people mixing things up and ending up asking questions like, “Has Esri got rid of ArcSDE?”
It’s also common to see users asking in forums why they should use ArcSDE if there are many databases that support spatial data, multi-user editing, replication, and even spatial functions, as one of colleagues here in the Melbourne office found the other day. The confusion comes from the terminology used:
A short answer to all these questions is: – No, it is not the same.
With the release of 10.2 and plans to deprecate the ArcSDE command line tools, there has been lots of talk about how all these tools will be replaced.
The following technical blog and forum addresses some of the questions you may have regarding the deprecation of the SDE command line tools: Continue reading
Whenever a replica creation or synchronization process is performed with ArcGIS Desktop, whether it be connected or disconnected, detailed information about the process is recorded in a replica activity log.
The replica log file can be found in the temp directory (as defined by the temp environment variable) of the machine on which the replica operation was executed.
For example: TEMP variable is set to “%USERPROFILE\Appdata\Local\Temp”
Thus, the location the ReplicaLog.dat file would be in Eg. for Windows 7 – “C:\Users\tthompson\AppData\Local\Temp”.
*** New at 10.1, you can choose the location of the file and the level of detail recorded. This option is available from ArcMap 10.1 > Distributed Geodatabase toolbar > Distributed Geodatabase menu > Options > General Tab > Log level.
The information in the replica activity log includes the following:
The contents of the ReplicaLog.dat file can be viewed directly in a text editor. However, the technical article “HowTo: Get a formatted view of the ReplicaLog.dat file” describes how to get a formatted view of the information in the log. The article can be found at: http://support.esri.com/en/knowledgebase/techarticles/detail/34752
More information about the operations included in the log can be found via the following web link:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/The_replica_activity_log/002700000043000000/
Formatted Replica Activity Log Example
ERRORS: 0
WARNINGS: 0
OperationName | Time Completed | Operation Info |
Rebuild Connectivity | 19/09/2012 2:04:46 PM | Zoning_Polygon_repl |
TransferedRelatedChanges | 19/09/2012 2:04:46 PM | Zoning_Polygon_repl |
TransferingChanges | 19/09/2012 2:06:56 PM | ZONING_POLYGON |
TransferingDelete | 19/09/2012 2:06:56 PM | ZONING_POLYGON |
TransferedDelete | 19/09/2012 2:06:56 PM | ZONING_POLYGON : 0 |
TransferingInsert | 19/09/2012 2:06:56 PM | ZONING_POLYGON |
TransferedInsert | 19/09/2012 2:06:56 PM | ZONING_POLYGON : 3 |
TransferingUpdate | 19/09/2012 2:06:56 PM | ZONING_POLYGON |
TransferedUpdate | 19/09/2012 2:06:56 PM | ZONING_POLYGON : 0 |
Rebuild Connectivity | 19/09/2012 2:06:56 PM | Zoning_Polygon_repl |
TransferedRelatedChanges | 19/09/2012 2:06:56 PM | Zoning_Polygon_repl |
Tania T.
Are you receiving the following error: “Lock request conflicts with an established lock.” or unable to change any properties of your data via ArcCatalog?
This is a common occurrence that occurs when you are making schema changes such as: Continue reading
Up to and including v10.0, the ArcCatalog “Set Data Source” tool is only designed for updating MXD file based data sources such as Personal and File geodatabases.
ArcSDE data connections updated via the ArcCatalog “Set Data Source” tool are not supported. The tool may allow you to update or repair MXD data references from ArcSDE geodatabases but is not the recommended method. Continue reading
Any map service (Including ArcIMS and Dekho map services), that connects to ArcSDE feature classes, places a schema lock on the dataset that is participating in the associated map service.
Planning to upgrade your ArcSDE 9.2 or 9.3 / 9.3.1 to ArcSDE 10.0? Beginning with ArcGIS 10.0, ArcSDE geodatabase upgrades must be performed using the Upgrade Geodatabase tool or Python script. Continue reading
TADAAH! The Geodatabase Toolset (GDBT) for ArcCatalog. (Yes free…)