ArcSDE 8.3 Service Pack 2
Date Submitted: August 6, 2004
Last Modified: September 9, 2004
Summary:
This Service Pack contains performance improvements and maintenance fixes. We highly recommend that you download and install this required Service Pack at your earliest convenience.
Description:
Introduction
ESRI announces ArcSDE 8.3 Service Pack 2. We recommend that all ArcSDE 8.3 customers download
and install this Service Pack, at their earliest convenience, to ensure the highest quality
experience when working with ArcSDE 8.3. This Service Pack includes all of the issues addressed
in ArcSDE 8.3 Service Pack 1 and some additional performance and maintenance issues.
It deals specifically with the issues listed below under Issues Fixed with this
Service Pack.
Issues Fixed with this Service Pack
DB2
CQ00129564 - Eliminate repeated SQLGetInfo calls to improve redraw time.
CQ00185139 - Normal Version filter query needs to be optimized for DB2.
CQ00190660 - Elimintate ST_EnvIntersects calls when at, approaching (95% of),
or exceeding the layer extent.
CQ00196585 - Moving connected junctions in response to the IEditEvents.OnCreateFeature
event of an edge feature does not work on DB2.
CQ00196738 - Eliminate extra LAYERS table queries from db_get_spatial_column().
CQ00197578 - Using wrong Sql type to write BLOB data for DB2 causes mosaic
error.
CQ00197820 - Running sdesetupinfx or sdesetupdb2 -o upgrade may result in
a core dump.
CQ00198792 - Clean up obsolete code that is slowing performance.
CQ00216588 - Previous service packs may degrade rendering performance.
CQ00236817 - DB2 can exhibit deadlocks under heavy concurrent editing loads.
CQ00238288 - Reconcile fails with error SQL0803N anytime two or more buffered array inserts
(where buffer size == MAX_ARRAY_ROWS == 100) are executed. May occur during unique scenarios.
CQ00239958 - Optimize the standard version filter query with logfiles that is performing poorly on reconcile.
Informix
CQ00129564 - Eliminate repeated SQLGetInfo calls to improve redraw time.
CQ00191161 - gsrvr crash when attempting to delete a feature on Solaris only.
CQ00194899 - Arcmap crashes when you join a non-versioned table and a versioned
feature class.
CQ00197820 - Running sdesetupinfx or sdesetupdb2 -o upgrade may result in
a core dump.
CQ00202198 - Registering a table or feature "as versioned" does not propagate
user defined attribute indexes to the "A" table.
CQ00202586 - Statistics on state_lineages need not be updated on every gsrvr
connection.
CQ00206219 - Rework the Delete_state stored procedure to avoid executing the
deleting lineage SQL everytime.
CQ00217679 - Optimize the difference filter queries.
CQ00218069 - Optimize sql for inserts into base tables.
CQ00219106 - Allow option for Exclusive locking of tables during compress.
CQ00219138 - sdeimport truncates long fields.
CQ00231997 - Problem in Update_Nochange difference filter.
CQ00245829 - User edits may get lost when multiple users save edits at the same time.
Oracle
CQ00157226 - When using the 'sdegroup' command with a tile size specified,
some features are removed from the newly created feature class.
CQ00177052 - Improved performance for computing statistics on queries against
SDE views.
CQ00184331 - If a user is not the owner of a raster layer and has full access
to it, it will get an Insufficient Permission" error message when loading
raster data into it. The owner can load raster data with no problem.
CQ00184816 - The mosaic operation (sderaster -o mosaic) fails with and "invalid
raster data" error message. This happens when the top left image is not loaded
first. The workaround is to load the top left image first.
CQ00185671 - The 'sdeimport' command does not generate spatial index when
used with 'SPIDX_GRID, <grid1,grid2,grid3>' and '-k DEFAULTS' specifiers.
Workaround: run the 'sdeimport' command and then set manually the spatial
index using the 'sdelayer' command:
- sdeimport -o create -l <table,column> -f <export_file> -k
DEFAULTS -g SPIDX_GRID,<grid1,grid2,grid3> -v
- sdelayer -o alter -l <table,column> -g SPIDX_GRID,<grid1,grid2,grid3>
- sdelayer -o normal_io -l <table,column>
CQ00187137 - The 'ArcSDE Configuration and Tuning Guide for Oracle' was not
generated correctly. Please download the new guide found in this page.
CQ00195613 - Improved performance on Versioning states queries.
CQ00195799 - Reduce the amount of Oracle lock conflicts on the SDE lock tables.
CQ00196501 - Compressing a database may fail with a "Fatal Error" error message
if there is a table containing a large number of columns.
CQ00196520 - State autolocking may now be turned off by using "set SDENOSTATEAUTOLOCK=TRUE"
in dbinit.sde file.
CQ00203329 - Some shape length values change to incorrect values following
Validate on unregistered feature classes on ArcSDE.
CQ00204525 - Adding route events in ArcMap may cause a Network I/O error.
CQ00211285 - Copy and pasting multiple personal geodatabase annotation features
into an ArcSDE Geodatabase annotation feature class when ELEMENT column is
a BLOB fails and returns an "Underlying DBMS error" message.
CQ00212572 - Geocoding service with offset set to 50% does not place point
in the center of street centerline segment.
CQ00212818 - Improved performance of state lineage queries.
CQ00212910 - ArcInfo Desktop will hang or fatal if user tries to list versions
of an ArcSDE Geodatabase that contains 5000 or more versions.
CQ00219384 - The sdeimport command was changing column size from number(10)
to number(38). It now maintains the column as number(10).
CQ00241890 - In rare cases spatial queries generated by ArcSDE for Oracle
Spatial can fail due to an improperly formed SQL statement.
CQ00242020 - SE_stream_calculate_table_statistics returns "-38 Attribute
column not found".
SQL Server
CQ00157226 - The sdegroup command removes features.
CQ00180617 - windows logins allocate from different desktop heap than sql
logins.
CQ00190174 - ArcSDE 9.0 for SQL Server 2000 SP3 will hang under connect/disconnect/unselect
statements from ArcMAP.
CQ00209987 - Upgrading to 8.3 may slow your connection time.
CQ00239819 - The ArcSDE shape library has a potential for memory read overflow
when working with feature subparts. In some very specific cases counting points
in a feature subpart can cause array bound read. This can happen when the
beginning and end points of a subpart are also the rightmost points.
Java-API
CQ00127400 - SeRow.getGeometry has bad performance and returns incorrect results
for multi-part shapes.
CQ00137641 - SeRow.getBlob returns null.
CQ00154517 - SeShape methods findBetween, findAlong not working properly.
CQ00162812 - Network I/O Error occurs when inserting BLOBs size > 65 520 bytes.
CQ00163059 - Using SE_LOCK_POLICY or SE_TRYLOCK_POLICY, may cause SeConnection
methods to fail.
CQ00197497 - SeVersion.getLocks() returns "GENERAL FAILURE OCCURRED (-1)"
when version is being edited in ArcMap.
CQ00151837 - Can't read a state that has lineage length > 1366.
CQ00216942 - ArcSDE 8.3 and 9.0 Java API fail with NullPointerExceptions on
SeConnection inside Oracle JVM.
C-API
CQ00160992 - Clipping envelopes derived from rectangular horizons extended
beyond the x edges of the world envelope, SgShapeClip fails.
CQ00192981 - SE_shape_generate_buffer gives operation failed(-1) error for
a distance of 0.00002.
CQ00193811 - SE_shape_intersect is not returning all parts of a multipart
polygon.
CQ00224286 - Copy/paste annotation in ArcMap may cause an ORA-01000 maximum
open cursors exceeded error.
All
CQ00166454 - DBACESS 2.1e using ArcSDE 8.2/8.3 libraries not working on 98/ME.
CQ00184303 - Cov2SDE fails when trying to convert a coverage into SDE. (HP64
only)
CQ00184780 - When Geocoding, mtch.dll causes application crash if reference
data field contains more than 80 characters.
CQ00191082 - Queries against the default version return incorrect data when
using stream pools.
Files Installed in this Service Pack
UNIX (Server)
- Under the $SDEHOME/bin directory:
-
All Databases
cov2sde
giomgr
gsrvr.shared
gsrvr.static
sde2cov
sde2shp
sde2tbl
sdeexport
sdegroup
sdeimport
sdexinfo
shp2sde
shpinfo
tbl2sde
- Under the $SDEHOME/Documentation directory:
Oracle 8i & 9i
config_tuning_guide_oracle.pdf
- Under the $SDEHOME/lib directory:
All Databases
libgpsrvr83.so (.sl for HP)
libmtch.so (.sl for HP)
libmtchloc.so (.sl for HP)
libsde83.so (.sl for HP)
libsg83.so (.sl for HP)
libtiff.so (.sl for HP)
DB2 (IBM only)
libgsrvrdb283.so
libsdedb2srvr83.so
sdesrvsp
sdesrvsp.bnd
Informix
libgsrvrinf83.so (.sl for HP)
libsdeinfsrvr83.so (.sl for HP)
Oracle 8i
libgsrvrora8i83.so (.sl for HP)
libsdeora8isrvr83.so (.sl for HP)
lock_util.spb
lock_util.sps
Oracle 9i
libgsrvrora9i83.so (.sl for HP)
libsdeora9isrvr83.so (.sl for HP)
lock_util.spb
lock_util.sps
Windows (Server)
- Under the %SDEHOME%\bin folder:
All Databases
cov2sde.exe
giomgr.exe
gsrvr.exe
libtiff.dll
mtch.dll
mtchloc.dll
sde2cov.exe
sde2tbl.exe
sde83.dll
sdeexport.exe
sdegroup.exe
sdeimport.exe
sdemon.exe
sg83.dll
tbl2sde.exe
DB2
gsrvrdb283.dll
sdedb2srvr83.dll
Informix
gsrvrinf83.dll
sdeinfsrvr83.dll
Oracle 8i
gsrvrora8i83.dll
sdeora8isrvr83.dll
Oracle 9i
gsrvrora9i83.dll
sdeora9isrvr83.dll
SQL Server
gsrvrsql83.dll
sdesqlsrvr83.dll
- Under the %SDEHOME%\lib folder:
Oracle 8i & 9i
lock_util.spb
lock_util.sps
DB2
- Under the %SDEHOME%\Documentation folder:
Oracle 8i & 9i
config_tuning_guide_oracle.pdf
UNIX (Client)
- Under the $SDEHOME/lib directory:
jsde83_sdk.jar
libedge.so (.sl for HP)
libgsrvrora8i83.so (.sl for HP)
libgsrvrora9i83.so (.sl for HP)
libloceng.so (.sl for HP)
libmtch.so (.sl for HP)
libmtchloc.so (.sl for HP)
libsde83.so (.sl for HP)
libsdeora8isrvr83.so (.sl for HP)
libsdeora9isrvr83.so (.sl for HP64)
libsg83.a (.sl for HP)
libsg83.so (.sl for HP)
lock_util.spb
lock_util.sps
Windows (C-API Client)
Installing the Service Pack
Since this Service Pack replaces several ArcSDE 8.3 files, ArcSDE 8.3 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 Service Pack using your SDE user account.
NOTE: If you connect to ArcSDE 8.3 via an Application Server and Direct Connect
connections using ArcGIS 8.3, ArcIMS 4.0.1, or ArcView GIS 3.3 with DBA 2.1e
make sure you also see ESRI Products connecting to ArcSDE
(Application and Direct Connect connections).
Server Install for UNIX
During installation, you can either save the original 8.3 files or overwrite them.
If you choose to save them, make sure you have enough disk space. The disk space requirements,
for each platform, are displayed during the installation process.
- Download the appropriate tar file to a location other than $SDEHOME:
- Stop your current ArcSDE service.
% sdemon -o shutdown
- Extract the specified tar file by typing:
% tar -xvf sde83-sp2-<Database>-<Platform>.tar
- Start the installation by typing:
% ./apply_sp_<Platform>_<Database>
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 Oracle 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 TABLE
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 TABLE
DROP ANY VIEW
DROP ANY PROCEDURE
DROP ANY SEQUENCE
EXECUTE ANY PROCEDURE
SELECT ANY SEQUENCE
- To upgrade, run sdesetup<dbms>. Failure to do so may cause problems
in starting the service or with connecting to the service. Using Oracle 9i
as an example:
% sdesetupora9i -o upgrade
- Start your service again.
% sdemon -o start
Server Install for Windows
- Make sure you have write access to the ArcSDE installation folder, that
no one is using ArcSDE, and that the ArcSDE service is down.
- Download the appropriate files to a location other than the ArcSDE installation
folder:
- Double-click the ArcSDE-<Database>-83-sp2.msp to start the install
process.
- When Setup starts, follow the instructions on your screen.
- (DB2 ONLY) Before upgrading your DB2 instance, you must copy the %SDEHOME%\bin\sdesrvsp.dll
to the %DB2TEMPDIR%\function folder under your DB2 installation folder.
- (Oracle only) Before upgrading your Oracle 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 TABLE
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 TABLE
DROP ANY VIEW
DROP ANY PROCEDURE
DROP ANY SEQUENCE
EXECUTE ANY PROCEDURE
SELECT ANY SEQUENCE
- To upgrade, run sdesetup<dbms>. Failure to do so may cause problems
in starting the service or with connecting to the service. Using Oracle 9i
as an example:
C:\> sdesetupora9i -o upgrade
- As the SDE user, run the following command to restart the ArcSDE service:
C:\> sdemon -o start
ArcSDE Client Install for UNIX
- Download the appropriate tar file to a location other than ArcSDE Client
installation location:
- Extract the specified tar file by typing:
% tar -xvf sde83-sp2-client-<Platform>.tar
- Start the installation by typing:
% ./apply_sp_<Platform>_c
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.
ArcSDE Client Install for Windows
- Make sure you have write access to the ArcSDE Client installation folder:.
- Download the appropriate files to a location other than the ArcSDE Client installation
folder:
- Double-click the appropriate executable to start the install process.
- When Setup starts, follow the instructions on your screen.
ESRI Products connecting to ArcSDE (Application
and Direct Connect connections).
ArcSDE 8.3 sp2 must be installed on both the client and server sides.
UNIX
- If you connect to ArcSDE 8.3 using ArcGIS 8.3 or ArcIMS 4.0.1, please
follow the steps below to install this Service Pack to your ArcGIS 8.3 Workstation
installation directory under $ARCHOME, or ArcIMS 8.3 installation directory
under $AIMSHOME:
- Before you start, make sure you have write access to the (ArcGIS or
ArcIMS) installation directory then download the appropriate compressed
tar file to that location:
-
ArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, ArcIMS
Application Server (in that order).
-
Uncompress and extract the specified tar file for your platform. Ensure
that the last letter of the file name is a capital Z. Otherwise, the
uncompress command will not work. At the UNIX prompt type:
%cd <installation_directory> (i.e. cd $ARCHOME)
%uncompress sde83-sp2-esri-<Platform>.tar.Z
%tar -xvf sde83-sp2-esri-<Platform>.tar
-
ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor
and ArcIMS Tasker (in that order).
Windows
- If you connect to ArcSDE 8.3 using ArcGIS 8.3, ArcIMS 8.3., or ArcView
GIS 3.3 with DBA 2.1e, please follow the steps below to install this Service
Pack to your ArcGIS 8.3, ArcIMS 4.0.1, or ArcView GIS 3.3 with DBA 2.1e
installation folder:
- Before you start, make sure you have write access to the installation
folder, then download the zip file to that location:
-
ArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, ArcIMS
Application Server (in that order).
- Use WinZip to extract the new files from sde83-sp2-esri.zip to the
appropriate installation folder, see list below:
- ArcGIS Desktop, Server, Engine, Reader, or ArcView 8 - <installation-folder>\arcexe8x\bin
& lib
- ArcGIS Workstation - <installation-folder>\arcexe8x\bin
& lib
- ArcView GIS - <installation-folder>\av_gis30\arcview\(bin32 & DCONNECT\LIB)
- Depending on the ArcIMS Setup features installed, the SDE client files could be located in one
or more of the following locations:
- ArcGIS Desktop, Workstation, or ArcView 8 -<installation-folder>\arcexe83\(bin
& lib)
- ArcView GIS - <installation-folder>\av_gis30\arcview\(bin32 & DCONNECT\LIB)
- ArcIMS - <installation-folder>\server\(bin & lib)
-
ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor
and ArcIMS Tasker (in that order).
Installing the Java Client on ArcIMS(UNIX and Windows)
- Download the new Java library jsde83_sdk.jar
to the appropriate location:
- UNIX
- ArcIMS 4.0.1 - <JRE Installation location>/lib/ext
- ArcExplorer Java 4.0 - <JRE Installation location>/lib/ext
- Windows
- ArcIMS 4.0.1 - <JRE Installation location>\lib\ext
- ArcExplorer Java 4.0 - <JRE Installation location>\lib\ext
New ArcSDE for Oracle Configuration and Tuning Guide (UNIX and
Windows)
You can access the new ArcSDE for Oracle Configuration and Tuning Guide Guide from here or
you can save it to your system: config_tuning_guide_oracle.pdf
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 for UNIX and the "strings" command
for Linux. For example, to display the identification string for this Service
Pack on UNIX, type:
%what gsrvr.static | grep QFE
QFE-SDE-83-CQ00245464
Windows
To check for the presence of Quick Fixes, 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 QFE distribution can be uniquely
identified in this manner. The identification string for this Patch should read:
QFE-SDE-83-CQ00245464
Service Pack Updates
Check the Online Support Center periodically for the availability of additional Service Packs.
New information about this Service Pack will be posted here.
UPDATE 08/09/04 - Now available:
- Informix (Server) download files for HP, IBM, Solaris and Windows.
- Oracle 8i (Server) download file for Tru64.
- Oracle 9i (Server) download file for Tru64.
- All ESRI Products download files.
UPDATE 08/19/04 - Updated all UNIX Client download files.
- Replaced all UNIX Client download files to include the library libedge.
If you need to link your application to the libedge library, you must download
and install the updated client download files.
UPDATE 09/09/04 - Minor text only updates to the web page.
Getting Help
Domestic sites, please contact ESRI Technical Support at 909.793.3774,
if you have any difficulty installing this Service Pack. International sites, please
contact your local ESRI software distributor.