Category Archives: Geodatabase

WWTSD (What Would Tech Support Do?) Part II: Data-specific Issues

Esri logo

This blog post is part II of the WWTSD blog series from Esri Support Services. Click here to view the first part in the series: WWTSD (What Would Tech Support Do?) Part I. Have you ever attempted to run a geoprocessing tool, … Continue reading

Posted in ArcGIS Desktop, export, Geodatabase, Raster, Support.Esri.com | Tagged , , , , , , | Leave a comment

Release of the Deprecated Features Plan for ArcGIS 10.4 and 10.4.1

Esri logo

This blog post provides the latest updates regarding deprecated features in ArcGIS 10.4 and in the recent release of ArcGIS 10.4.1.

Posted in Announcements, ArcGIS Desktop, ArcGIS Enterprise, ArcGIS Pro, export, Geodatabase, SDK | Tagged , , , , , , , , | Leave a comment

Updating Your Enterprise Geodatabase License Just Got Easier

With the release of ArcGIS 10.4 comes a brand new geoprocessing tool that allows you to update your enterprise geodatabase license efficiently through ArcGIS for Desktop. The Update Enterprise Geodatabase License tool is now included in the Geodatabase Administration toolset in the Data Management toolbox. Continue reading

Posted in Announcements, ArcGIS Desktop, ArcSDE, export, Geodatabase, Uncategorized | Tagged , , , , , , | 1 Comment

Simplify Your Life: Working with Schema Changes in your Replicas

As a support analyst, we get a range of fun issues to review. These issues may be specific to the user’s environment, data, workflow, etc. Sometimes, we may notice an influx of calls pertaining to a single workflow. When this happens, we revisit the resources our users have available to them, and ensure that the documentation clearly describes how to execute workflows.

One of these workflow issues we have seen in the call center lately has been working with schema changes in replicas. For example, after creating a replica, you realize you need to add a field to a certain feature class, or remove a domain that is no longer necessary. This blog hopes to make this workflow more intuitive with a few tricks that will help the replica gurus out there efficiently deal with schema changes. Continue reading

Posted in ArcSDE, export, Geodatabase | Tagged , , | 6 Comments

Tips for Compressing with Existing Geodatabase Replicas

In a versioned environment, all edits are stored in what we call delta tables, or Adds and Deletes tables, and these tables are assigned to a unique state ID. Edits are held in the delta tables to handle any conflicts in a multi-user enterprise geodatabase. A compress operation trims the delta tables of any unreferenced state ids, consolidating the states lineage down to one state. If a state is still being referenced, it will remain in the delta tables, resulting in a partial compress.

In a fully compressed geodatabase, there are no rows in the delta tables, and the state tree is trimmed back to one state, state_id=0. Although a full compress is ideal, it is not always necessary and in some cases may not even be practical. For example, if there are many multi-generation replicas in your geodatabase that are not unregistered before the compress, you will need to send changes for all of these replicas to achieve a full compress. If there are many Two-way replicas, and you intend to fully compress both the parent and the child geodatabases, this process of synchronization will need to be done separately from both geodatabases, even if there are no changes to be sent.

Continue reading

Posted in export, Geodatabase | Tagged , , , , , , | Leave a comment

Options for Authorizing an Enterprise Geodatabase

Following up on a previous post regarding obtaining license files for creating enterprise geodatabases, we want to provide more insight into how this can be done if you don’t have access to the server installed with ArcGIS for Server or if you don’t have ArcGIS for Server installed at all. Since enterprise geodatabases use the ArcGIS for Server license, there are a few options for you. Continue reading

Posted in export, Geodatabase | Tagged , , , , , , , | 11 Comments

Where is the install for ArcSDE 10.3?

You’ve just updated your client and geodatabases to ArcGIS 10.3, and you want to ensure you are using the most up-to-date ArcSDE command line tools and application server install. So where is the install for ArcSDE 10.3? Continue reading

Posted in ArcGIS Desktop, ArcGIS Enterprise, ArcSDE, export, Geodatabase | Tagged , , , , , , , | 17 Comments

Critical Information Regarding Oracle Update and ArcGIS

Esri logo

Please be aware that if the recent Oracle Critical Patch Update (CPU) released on October 14th, 2014 is installed on your Oracle database, connecting to the Oracle database will crash ArcGIS. This issue only affects you if you use Oracle. … Continue reading

Posted in Announcements, ArcGIS Desktop, ArcGIS Enterprise, ArcSDE, export, Geodatabase, High Priority, Support.Esri.com | Tagged , , , , , , , , | 2 Comments

Errors, Errors and more Errors

In my line of work, I must have at least a working knowledge of each database management system (DBMS) supported by Esri. Other vendors require near-perfect database administrator (DBA) expertise. This means I am constantly looking at error messages.

Some I have memorized, but there is no way I will ever be able retain all of them in my memory. So, here are some resources I use for looking up the meaning of those vague return codes. What are yours?

Continue reading

Posted in ArcSDE, export, Geodatabase | Tagged , , , , , , , , , , , | Leave a comment

The Evolution of Query Layers

MJarman-querylayers_4-lg

Query layers were first introduced at the 10.0 release primarily to allow ArcMap to integrate data from databases that do not contain the system geodatabase repository tables. Think of query layers as a method for accessing database objects that are not … Continue reading

Posted in ArcGIS Desktop, ArcGIS Enterprise, export, Geodatabase | Tagged , , , , , , , , , , , , , | 13 Comments