English

ArcSDE 9.1 SQLServer Patch 1

Summary

ESRI announces ArcSDE 9.1 SQL Server Patch 1. This Patch addresses an issue with building pyramids on raster datasets and an issue with the sdetable command. It deals specifically with the issues listed below. We highly recommend that all ArcSDE 9.1 for SQL Server users who are currently using rasters to download and install this Patch at their earliest convenience.

Description

ArcSDE 9.1 SQLServer Patch 1


Installing the Patch

ArcSDE 9.1 Service Pack 2 must be installed before you can install this Patch. It is strongly recommended that you back up your database including all previous ArcSDE system tables and user layer data before upgrading your ArcSDE installation. Install this Patch using your SDE user account.

REQUIRED INSTALL STEP: If you connect to ArcSDE 9.1 via an Application Server and Direct Connect connections using ArcGIS 9.1, ArcIMS 9.1, or ArcView GIS 3.3 with DBA 2.1g make sure you also see ESRI Products connecting to ArcSDE (Application and Direct Connect connections).

Server Install for Windows


Installation Steps


  1. 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 files to a location other than the ArcSDE installation folder:

  3. sde91-sqlpatch1-sql-win.exe 2 MB

  4. Double-click the appropriate executable to start the install process.


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


  6. As the SDE user, run the following command to restart the ArcSDE service:

    sdemon -o start

ArcSDE SDK Install for Windows


  1. Make sure you have write access to the ArcSDE SDK installation folder:.


  2. Download the appropriate files to a location other than the ArcSDE SDK installation folder:
  3. ArcSDE SDK sde91-sqlpatch1-sdk-win.exe 2 MB
    ArcSDE Java SDK sde91-sqlpatch1-javasdk-win.exe 1 MB

  4. Double-click the appropriate executable to start the install process.


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

ESRI Products connecting to ArcSDE (Application and Direct Connect connections).

Windows

  • If you connect to ArcSDE 9.1 using ArcGIS 9.1 Desktop (ArcInfo 91, ArcView 9.1, ArcEditor 9.1, ArcReader 9.1), ArcGIS Engine 9.1, ArcGIS Server 9.1, ArcIMS 9.1, ArcInfo Workstation 9.1, or ArcView GIS 3.3 with DBA 2.1g, please follow the steps below to install this Patch to your ArcGIS 9.1 Desktop (ArcInfo 91, ArcView 9.1, ArcEditor 9.1, ArcReader 9.1), ArcGIS Engine 9.1, ArcGIS Server 9.1, ArcIMS 9.1, ArcInfo Workstation 9.1, or ArcView GIS 3.3 with DBA 2.1g installation folder:

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

    sde91-sqlpatch1-esri-win.zip 2 MB

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

  • Use WinZip to extract the new file from sde91-sqlpatch1-esri-win.zip to the appropriate installation folder, see list below:

    • ArcGIS Desktop, Server, Engine, Reader, or ArcView 9 - <installation-folder>\arcgis\bin
    • ArcGIS Workstation - <installation-folder>\arcexe9x\bin
    • ArcView GIS - <installation-folder>\av_gis30\arcview\(bin32 & DCONNECT\LIB)
    • Depending on the ArcIMS Setup features installed, the SDE 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

  • ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor and ArcIMS Tasker (in that order).

How to identify which Patch is installed


    Windows

    To check for the presence of a Patch, for each file examine the unique identification information provided (right click, properties, version tab, item name, QFE Version). With only a few exceptions, all files modified as part of a Patch distribution can be uniquely identified in this manner. The identification string for this Patch should read:

      QFE-SDE-91-CQ00293412

Service Pack Updates

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

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.