Tag Archives: geodatabase

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 for Desktop, ArcSDE, 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, 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 Geodatabase | Tagged , , , , , , | Leave a comment

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, 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 for Desktop, ArcGIS for Server, Geodatabase | Tagged , , , , , , , , , , , , , | 13 Comments

Oracle geodatabase issue for ArcGIS 10.2.1

Esri logo

If you are a customer with an Oracle geodatabase and are planning to upgrade your enterprise geodatabase to ArcGIS 10.2.1, please read the following technical article before you upgrade, as some issues exist that directly impact the upgrading process. If you have any further … Continue reading

Posted in Announcements, Geodatabase, High Priority | Tagged , , , , , , , , | Leave a comment

Workflow Manager – Not an Administrator

You’re all set to take on a Workflow Manager database as the new administrator. All is going well, until you try to log in to Workflow Manager Administrator. At that time, you get the following error, “Current user is not an administrator on the selected database. Please contact your administrator.” (Figure 1)

Figure 1 – Not an Administrator

When I first experienced this, my natural instinct was to follow my nose down the trail that the error had provided. Like me, you may even decide to grant database administrative rights to the user in question in an effort to temporarily alleviate this error. Unfortunately, this is technically not the case and you will continue receiving this error.

Don’t worry - it’s not your fault. This error is technically correct, but tends to be misleading. It gives the impression that the database user needs additional administrator privileges. This is not the case. Continue reading

Posted in ArcSDE, Geodatabase | Tagged , , , , , , , , , | 2 Comments

Do This, Not That! – Alternatives to using SDE command line tools

globe

With the release of 10.2 and plans to deprecate the ArcSDE command line tools, you may be wondering how current tasks that use these tools can be completed elsewhere. I wanted to share some workflows that have alternate user interface … Continue reading

Posted in ArcGIS for Desktop, ArcSDE, Geodatabase | Tagged , , , , , , | 55 Comments

Replicating distributed data with the ‘register with existing data’ option

With the growing need for organizations to distribute their data in remote locations, geodatabase replication can help to manage the changes made between geodatabases in different locations. When working with distributed and remote geodatabases it is often asked, “What is the best method to create and setup replicas?”

Continue reading

Posted in ArcGIS for Desktop, Geodatabase | Tagged , , , , | Leave a comment

Resources for rebuilding indexes and updating statistics in an SDE geodatabase

Tuning your RDBMS is an important aspect of maintaining your enterprise geodatabase. Two tasks found in all Esri-supported RDBMS are updating DBMS statistics and rebuilding indexes. If you are loading data in bulk or running query-intensive DML operations with SQL, these tasks need to be done more often. Fortunately for us, these tasks are relatively straightforward to accomplish.

Continue reading

Posted in ArcSDE, Geodatabase | Tagged , , , , | 1 Comment