Tag Archives: ArcSDE

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

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

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

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

Where did the ArcSDE Post Installation Wizard go at 10.1?

ArcSDE for SqlServer

You may have already noticed some of the changes at 10.0 with the upgrade process for ArcSDE geodatabase no longer using the Post Installation wizard. This was discussed in an earlier blog written on “The Evolution of the ArcSDE Geodatabase … Continue reading

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

Getting to Know Esri Support: Shan C.

An interview with ArcSDE Enterprise Geodatabase analyst Shan C.

To continue our “Getting to Know Esri Support” series, we’ve recapped our talk with Shan Chen regarding his experiences with GIS. We hope you enjoy this blog and getting to know some of the members of the Esri Support Services team! Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | Leave a comment

The Evolution of the ArcSDE Geodatabase Upgrade Process at 10.0

When using ArcSDE geodatabases, you may have noticed a change within the 10.0 release in how the upgrade process is now handled. Instead of using the Post Installation Wizard and selecting Repository Setup, as in previous releases, there is a new upgrade process. Upgrading your geodatabase is now performed within ArcCatalog using the new Upgrade Geodatabase (Data Management) tool.

The Upgrade Geodatabase (Data Management) Tool can be accessed in ArcCatalog via the Database Properties of a database connection under the General tab > Upgrade Status or within the Upgrade Geodatabase geoprocessing tool referencing an existing connection. For ArcSDE geodatabases, a direct connection to the geodatabase is necessary to run the upgrade.

Post Installation Wizard at 10.0:
The Post Installation Wizard in 10.0 can be used for the following:

  • Defining Database and SDE DBA User – Creating new ArcSDE enterprise geodatabases
  • Repository Setup – Populate system repository tables (for new geodatabases only)
  • Authorize ArcSDE – Perform Software Authorization of the geodatabase
  • Create ArcSDE Service – If using application server service (when not using direct connections)

More changes are on the horizon to incorporate Post Installation functionality into the client tools for the 10.1 release, so stay tuned!

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

Is my database patch supported?

A lot of users often have questions concerning their system configuration for the version of software being used in conjunction with our products. Questions get more specific to involve installing patches, service packs, etc., within an environment and, in relation to ArcSDE Enterprise geodatabases, questions also involve RDBMS patches. Let’s outline some of the key points made in our Supported Environment Policy document that should help you answer these questions when considering patching a test or production database that houses ArcSDE Enterprise geodatabases.

Support Environment Policy

Meet or exceed the minimum requirements:

  • As a rule of thumb, ensure your configuration meets or exceeds the minimum configuration listed on our system requirements page.

  • Non-certification of an environment does not necessarily mean it is not supported.

  • An environment is supported if it meets or exceeds the base build environment and that environment is not known to fail.

Check out the ‘limitations’ section of the system requirements page:

  • Environments that are known to not work are usually documented on the product support page as soon as that information is available.

  • An environment may be supported even if there are some known issues with the software on that particular environment (any known issues will be documented in the “limitations” section of the System Requirements for that environment).

Check that the 3rd-party vendor supports the environment:

  • Esri cannot support any environment not supported by the vendors of the operating systems, RDBMSs, or Web servers.

Test, test, test!
Since Esri cannot test and certify every possible configuration, it is always recommended to thoroughly test any upgrade or change to your production environment on a test server first. This helps to ensure your organization’s workflows prior to implementing such a change.

Geodatabase and ArcSDE System Requirements – Version 10.0

ArcGIS Server 9.3/9.3.1 System Requirements – see Supported Relational Database Management Systems (ArcSDE) section

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