English

ArcSDE 8.1.2 Service Pack 1

Summary

This Service Pack contains performance improvements and maintenance fixes. It includes all the bug fixes from the ArcSDE 8.1.2 Patch. We highly recommend that you download and install this required Service Pack at your earliest convenience.

Description

Introduction

ESRI is pleased to announce the ArcSDE 8.1.2 Service Pack 1. We highly recommend that customers download and install this required Service Pack at their earliest convenience. This Service Pack contains performance improvements and maintenance fixes that deal specifically with the problems listed below under Bugs Fixed with this Patch. This Patch includes all the bug fixes from the ArcSDE 8.1.2 Patch.

Disk Space Requirement

During installation, you can either save the original 8.1.2 files or overwrite them. If you choose to save them, make sure you have enough disk space. The estimated disk space requirements are:

Platform
DB2
Informix
Oracle 8i
SQL Server
HP® PA-RISC HP-UX®
n/a
9.5 MB
14.5 MB
n/a
IBM® RS/6000® and AIX®
11 MB
11.5 MB
16 MB
n/a
Sun Solaris2
n/a
9.5 MB
15 MB
n/a
Tru64 UNIX
n/a
n/a
26 MB
n/a
Windows NT®/2000®/XP®-Intel®
3 MB
3 MB
4 MB
3.5 MB


Bugs Fixed with this Service Pack

ArcSDE Java Client

CQ00146623: Network I/O error occurs when updating versioned data when using the Java Client.

DB2

CQ00151707: Spatial column name of FID causes problems querying attribute information of layers.
CQ00155985: Network trace fails using incorrect state following save edits.
CQ00158847: Not able to compress the database with a single edit made to single feature class (state lock or unknown error occurs).

Informix

CQ00155985: Network trace fails using incorrect state following save edits.

Oracle 8i

CQ00146634: Writing or reading more than 32,000 ID's between client and server using XDR results in Network I/O (-1) error.
CQ00151707: Spatial column name of FID causes problems querying attribute information of layers.
CQ00154641: Optimize UPDATE_NOCHAGE difference filter performance.
CQ00155566: Using ArcSDE 8.1.2 sdeimport on Tru64 to load sdeexport file generated on a non-Tru64 system may get unexpected results or a failure when importing (Tru64 Only).
CQ00155985: Network trace fails using incorrect state following save edits.
CQ00156928: Optimize UPDATE_UPDATE difference filter performance.
CQ00157166: IWorkspaceEdit::StopEditoperation fails after pfeature.store of a row with a BLOB attribute.
CQ00157812: "Create feature task could not be completed. The parameter is the wrong kind of geometry" when geometric network is SDO_GEOm.
CQ00159364: Correct random occurrence of Oracle "ORA-00933 SQL command not properly ended" on versioned feature classes.
CQ00161161: Fix memory leaks in ArcSDE server.
CQ00162154: Can't join versioned tables using Oracle or SQL Server -- ORA-01008 not all variables bound. CQ00164654: sdeexport errors with 8.1.2 patch when exporting layers that have FID specified as their shape column.

SQL Server

CQ00151707: Spatial column name of FID causes problems querying attribute information of layers.
CQ00155985: Network trace fails using incorrect state following save edits.
CQ00162154: Can't join versioned tables using Oracle or SQL Server -- ORA-01008 not all variables bound.

Files Installed in this Service Pack

UNIX

  • Under the $SDEHOME/bin directory:

    All Databases
    gsrvr.shared
    gsrvr.static

    Oracle 8i
    giomgr
    sdeexport (Tru64 only)
    sdeimport (Tru64 only)
    sdexinfo (Tru64 only)

  • Under the $SDEHOME/lib directory:

    All Databases
    jsde81_sdk.jar

    DB2 (IBM only)
    libgsrvrdb281.so
    libsdedb2srvr81.so

    Informix
    libgsrvrinf81.so (.sl for HP)
    libsdeinfsrvr81.so (.sl for HP)

    Oracle 8i
    libgsrvrora8i81.so (.sl for HP)
    libsdeora8isrvr81.so (.sl for HP)
    libsde81.so (Tru64 only)

Windows

  • Under the %SDEHOME%\lib folder:
  • All Databases
    jsde81_sdk.jar

  • Under the %SDEHOME%\bin folder:

    DB2
    gsrvr.exe
    gsrvrdb281.dll
    sdedb2srvr81.dll

    Informix
    gsrvr.exe
    gsrvrinf81.dll
    sdeinfsrvr81.dll

    Oracle 8i
    giomgr.exe
    gsrvr.exe
    gsrvrora8i81.dll
    sdeora8isrvr81.dll

    SQL Server
    gsrvr.exe
    gsrvrsql81.dll
    sdesqlsrvr81.dll

Java Client (UNIX and Windows)

  • Under the <ArcSDE Java Client Installation>\lib folder:

    All Databases
    jsde81_sdk.jar

Installing the Service Pack

Since this Service Pack replaces several ArcSDE 8.1.2 files, ArcSDE 8.1.2 must be installed before you can install this Service Pack. 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.

On UNIX -

  1. Download the appropriate tar file to a location other than $SDEHOME:
    DB2  
    IBM (coming soon) 6 MB
    Informix  
    sde812_sp1_inf_hp.tar 6 MB
    sde812_sp1_inf_ibm.tar 6 MB
    sde812_sp1_inf_slrs.tar 5 MB
    Oracle 8i  
    sde812_sp1_ora8i_hp.tar 9 MB
    sde812_sp1_ora8i_ibm.tar 9 MB
    sde812_sp1_ora8i_slrs.tar 8 MB
    sde812_sp1_ora8i_tru64.tar 15 MB
  2. Stop your current ArcSDE service.

    % sdemon -o shutdown

  3. Extract the specified tar file by typing:

    % tar -xvf sde812_sp1_<Database>_<Platform>.tar

  4. 4. Start the installation by typing:

    % ./apply_sp
  5. This will start the dialog for the menu-driven installation procedure. Default selections are noted in parentheses ( ). To quit the installation procedure, type 'q' at any time.

  6. Before upgrading your Oracle8i instance, you must grant the following additional permissions to the SDE user in Oracle:
      ALTER ANY INDEX
      ALTER ANY TABLE
      ANALYZE ANY
      CREATE ANY INDEX
      CREATE ANY PROCEDURE
      CREATE ANY SEQUENCE
      CREATE ANY TRIGGER
      CREATE ANY VIEW
      CREATE SESSION
      DROP ANY INDEX
      DROP ANY VIEW
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      EXECUTE ANY PROCEDURE
      SELECT ANY SEQUENCE
      SELECT ANY TABLE
      UNLIMITED TABLESPACE

    After the upgrade completes, you may revoke the following permissions from the SDE user account:

      ALTER ANY INDEX
      ALTER ANY TABLE
      ANALYZE ANY
      CREATE ANY INDEX
      CREATE ANY TRIGGER
      CREATE ANY VIEW
      DROP ANY INDEX
      DROP ANY VIEW
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      EXECUTE ANY PROCEDURE
      SELECT ANY SEQUENCE

  7. To upgrade, run the updated version of sdesetup<dbms>. Failure to do so will cause problems in starting the service or with connecting to the service. Using Oracle 8i as an example:

    % sdesetupora8i -o upgrade

  8. Start your service again.

  9. % sdemon -o start

  10. If you use Direct Connect, please follow the steps below to install this patch to your ArcGIS 8.1.2 Workstation installation directory under $ARCHOME/lib, or ArcIMS 3.1 installation directory under $AIMSHOME/lib or ArcView GIS 3.3 with DBA 2.1c under $AVHOME/lib:

    • Before you start, make sure you have write access to the (ArcGIS, ArcIMS or ArcView GIS) installation directory then download the appropriate compressed tar file to that location:


    • Oracle 8i  
      sde812_sp1_dc_ora8i_hp.tar.Z 3 MB
      sde812_sp1_dc_ora8i_ibm.tar.Z 4 MB
      sde812_sp1_dc_ora8i_slrs.tar.Z 2 MB
      sde812_sp1_dc_ora8i_tru64.tar.Z 6 MB

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

    • Install the patched files, at the UNIX prompt type:

      %cd <installation_directory> (i.e. cd $ARCHOME)
      %uncompress sde812_sp1_dc_ora8i_<platform>.tar.Z
      %tar xvf sde812_sp1_dc_ora8i_<platform>.tar

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

On Windows -

  1. Make sure you have write access to %SDEHOME%, that no one is using ArcSDE, and that the ArcSDE service is down.
  2. Download the appropriate files to a location other than %SDEHOME%:
  3. DB2  
    (coming soon) 2 MB
    Informix  
    sde812_sp1_inf.exe 2 MB
    Oracle 8i  
    sde812_sp1_ora8i.exe 2 MB
    SQL Server  
    sde812_sp1_sql.exe 2 MB
  4. Double-click the sde812_sp1_<Database>.exe 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:

  7. C:\> sdemon -o start

  8. If you use Direct Connect, please follow the steps below to install this Service Pack to your ArcGIS 8.1.2, ArcIMS 3.1, or ArcView GIS 3.3 with DBA 2.1c installation folder:

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

    • ArcGIS Desktop and Workstation

      • Use WinZip to extract the new files from sde812_sp1_dc_ora8i_win.zip to <installation_folder>\bin.

    • ArcIMS

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

      • Use WinZip to extract the new files from sde812_sp1_dc_ora8i_win.zip to <installation_folder>\server\bin.

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

    • ArcView 3.3

      • Use WinZip to extract the new files from sde812_sp1_dc_ora8i_win.zip to <installation_folder>\arcview3\bin

Java Client (UNIX and Windows)

  1. Download the new Java library jsde81_sdk.jar to the appropriate location:

    • UNIX


      • ArcSDE 8.1.2 - <JRE Installation location>/lib
      • ArcIMS 3.1 - <JRE Installation location>/lib/ext
      • ArcExplorer Java 3.1 - <JRE Installation location>/lib/ext

    • Windows


      • ArcSDE 8.1.2 - <JRE Installation location>\lib
      • ArcIMS 3.1 - <JRE Installation location>\lib\ext
      • ArcExplorer Java 3.1 - <JRE Installation location>\lib\ext

Identifying QFE files on your machine

    UNIX

    Any modified UNIX executables (or libraries) being sent out as part of a Quick Fix will return the unique identification number for that fix when checked with the "what" command. The identification string for this Service Pack is:

    ESRI QFE-ArcSDE-812-13-CQ00166931 (5/24/2002)

    Windows

    To check for the presence of Quick Fixes, examine the unique identification information by a (right click, properties, version tab) action under Explorer. With only a few exceptions, all files modified as part of a QFE distribution can be uniquely identified in this manner. Under Windows 2000, select 'Product Version' under the 'Item name' column to see the unique identifier.

Patch Updates

Added Direct Connect download files (11/08/02).

Getting Help

Domestic sites, please contact ESRI Technical Support at 909.793.3774, if you have any difficulty installing this patch. International sites, please contact your local ESRI software distributor.