English

ArcSDE 10.0 General Update Patch for SQL Server

Summary

This is a mandatory patch that should be applied to ArcSDE 10.0 for SQL Server and all ArcGIS 10.0 clients that connect to ArcSDE 10.0 or earlier release geodatabases on SQL Server.

Description

Introduction

ESRI® announces the ArcSDE 10.0 General Update Patch for SQL Server. This patch addresses issues that may be encountered when working with geodatabases stored in SQL Server. It deals specifically with the issues listed below under Issues Addressed with this Patch.

Issues Addressed with this Patch


  • NIM058241 - Edits made by a User that was assigned edit privileges do not persist after saving when loading raster data in a raster type field in a feature class.

    Description: Users performing versioned edits on raster fields of either a feature class or a table will encounter a problem if they do not own the feature class or table and were granted edit access, by the owner.

    After starting the edit session, loading a raster value into the raster field, and saving the edits, the raster value returns to a null state.

  • NIM059142- Date fields created in SQL Server 2008 9.3.x geodatabases by ArcGIS 10 clients using direct connect are inaccessible by pre-10 ArcGIS clients.

    Description: ArcGIS 10 clients using a direct connect to older geodatabases in SQL Server 2008 are erroneously creating date fields using the datetime2 data type. The datetime2 datatype is not supported by pre-10 ArcGIS clients. Please see technical article 38046 for more details.

  • NIM059178 - Unable to preview feature classes or upgrade geodatabase from ArcGIS 10 Client via Direct Connect.

    Description: When making a Direct Connect from an ArcGIS 10 client to a 9.2, 9.3 or 9.3.1 geodatabase, previewing feature classes, or upgrading the geodatabase to version 10 fails with “DBMS table not found” errors. Please see technical article 38048 for more details.

Files Installed in this Patch



    ArcSDE\bin folder:

      sdesqlsrvr100.dll

    ESRI products connecting to ArcSDE:

      sdesqlsrvr100.dll

Installing this Patch


Since this Patch replaces 10.0 files, you must have ArcSDE 10.0 before you can install this Patch.

  1. Install this Patch using an administrator account. Make sure you have write access to the ArcSDE installation folder, that no one is using ArcSDE, and that the ArcSDE service is down.


  2. Download the appropriate file to a location other than your ArcSDE installation location.

    ArcSDE SQL Server (32 bit Operating System)
    SQL Server SDE10-GUP-SQL-win.msp 1 MB
    ArcSDE SDK SDE10-GUP-CAPI-win.msp 1 MB
    ArcSDE Java SDK SDE10-GUP-JavaSDK-win.msp 1 MB
     
    ArcSDE SQL Server (64 bit Operating System)
    SQL Server 64 SDE10-GUP-SQL-win64.msp 1 MB
    ArcSDE SDK 64 SDE10-GUP-CAPI-win64.msp 1 MB
    ArcSDE Java SDK 64 SDE10-GUP-JavaSDK-win64.msp 1 MB

  3. Double-click SDE10-GUP-<Product>-win<Bit>.msp to start the install process.


  4. NOTE: If double clicking on the MSP file does not start the Patch installation, you can run the Patch manually by using the following commands.
    c:\msiexec.exe /p [location of patch]\SDE10-GUP-<Product>-win<Bit>.msp

  5. When Setup starts, follow the instructions on your screen.


  6. Server Only: As the ArcSDE administrative user, run the following command to restart the ArcSDE service:

    c:\sdemon -o start

ESRI products connecting to ArcSDE (application server and direct connections)

    Windows

    1. If you connect to ArcSDE 10.0 using ArcGIS 10.0, ArcIMS 10.0, or ArcInfo Workstation 10.0, please follow the steps below to install this Patch to your ArcGIS 10.0, ArcIMS 10.0, or ArcInfo Workstation 10.0 installation folder:

    2. Before you start, make sure you have write access to the installation folder, then download the zip file to that location:

      sde10-gup-esri-win.zip 1 MB

    3. ArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, and ArcIMS Application Server (in that order).


    4. Extract the new files from sde10-gup-esri-win.zip to the appropriate installation folder, see list below:


      • ArcGIS Desktop, Server, Engine, Reader, or ArcView 10 - <installation-folder>\<Product>\bin
      • ArcGIS Workstation - <installation-folder>\arcexe10x\bin
      • Depending on the ArcIMS Setup features installed, the ArcSDE client file could be located in one or more of the following locations:


        • C:\Program Files\ArcGIS\bin
          C:\Program Files\ArcGIS\ArcIMS\IndexBuilder
          C:\Program Files\ArcGIS\ArcIMS\Metadata\Commands
          C:\Program Files\ArcGIS\ArcIMS\Server\bin
    5. ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor and ArcIMS Tasker (in that order).

Patch Updates

Check Online Support Center periodically for the availability of additional patches. New information about this Patch will be posted here.

How to identify which Patch is installed

To find out what products and which patches are currently installed on your machine, download the PatchFinder utility and run it from your local machine.

Getting Help

Domestic sites, please contact ESRI Technical Support at 1-888-377-4575, if you have any difficulty installing this Service Pack. International sites, please contact your local ESRI software distributor.