Category Archives: ArcSDE

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

Getting Ready for Esri 2016 – It’s Time to Upgrade from ArcGIS 10.0

Are you running ArcGIS 10.0 for some of your GIS needs? We know, it’s a great platform, but it’s time to move onward and upward. Over the last five years, Esri has developed greater and more powerful functionalities across all platforms, moving from ArcGIS 10.0 all the way to the upcoming release of ArcGIS 10.4. These upgrades have come with more tools, more efficient processing, and more features that allow you to create and share the data and maps you need. If you haven’t upgraded your applications and geodatabases yet, it’s time to start planning. Continue reading

Posted in Announcements, ArcGIS Desktop, ArcGIS Enterprise, ArcSDE, export | Tagged , , , , | 3 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

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, export, 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 Desktop, ArcSDE, export, Geodatabase | Tagged , , , , , , | 55 Comments

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, export, Geodatabase | Tagged , , , , | 1 Comment

Updating the license for enterprise geodatabases at 10.1

The ArcGIS Server license is missing or not valid. Please 
provide the path to an authorization file (ECP file) that 
contains a ArcGIS Server license.

Esri Developer Network (EDN) licenses, Site License Agreements (SLAs), educational site licenses, and other license agreements require that the license files for ArcGIS for Server and ArcSDE enterprise geodatabases be updated upon or prior to expiration for continued use. In previous … Continue reading

Posted in ArcSDE, export | Tagged , , , , | 4 Comments