ArcSDE 8.1.2 Service Pack 1

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.

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 -

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

Stop your current ArcSDE service.

% sdemon -o shutdown
Extract the specified tar file by typing:

% tar -xvf sde812_sp1_<Database>_<Platform>.tar
Start the installation by typing:

% ./apply_sp
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.
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
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
Start your service again.

% sdemon -o start

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 -

Make sure you have write access to %SDEHOME%, that no one is using ArcSDE, and that the ArcSDE service is down.

Download the appropriate files to a location other than %SDEHOME%:

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

Double-click the sde812_sp1_<Database>.exe to start the install process.
When Setup starts, follow the instructions on your screen.
As the SDE user, run the following command to restart the ArcSDE service:

C:\> sdemon -o start
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)

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.

Download ID:144