New Issues Addressed with ArcSDE 9.0 Service Pack 3
DB2
CQ00232645 - When using shared log file settings and inserting records,
an "SE_stream_execute ERROR on SE_STREAM: SE_NET_FAILURE (-10)" error
may occur.
CQ00249769 - On 64-bit platforms, a segment violation occurs when using
shp2sde with the -G option to specify an SRID to use when loading the
data.
CQ00255169 - After deleting features in a versioned feature class within
a user transaction, a refresh in ArcMap will commit an edit to a non-versioned
table.
CQ00259458 - An "Error importing SDE export file version 9.0"
message appears, when using sdeimport although the data loads correctly.
This occurs when importing data that has just been exported.
Informix
CQ00237990 - When attempting to create a GlobalID column, the column
gets created as a GUID column instead.
CQ00241603 - Executing update, delete, and query stream operations with
dynamically bound where clauses fail if the where clause binds the SE_FLOAT32_TYPE
date type.
CQ00241864 - When creating an inner join on tables in ArcMap or with
a query definition in ArcObjects, a Network I/O error may occur.
Oracle
CQ00105940 - sdeexport with -O spatial index ordering does not change
the drawing order after importing the resultant export file into new layer.
CQ00235403 - When connecting to Oracle 10g some system objects for Oracle
Ultra Search, Oracle Text, and Oracle Recycle Bin are displayed in the
layer list for ArcCatalog. This is due to Oracle granting select privileges
to the public on these objects. ArcSDE will now filter these objects out
when a layer list is requested.
CQ00253833 - During reconcile, the error: "ORA-01747: invalid user.table.column,
table.column, or column specification" may occur after editing Geometric
networks.
CQ00254217 - Intermitant Network I/O errors occur when querying with
subfields where the OID is not in the subfield list. Usually this is encountered
when using custom ArcObjects code that uses subfields in definition queries
that do not include all fields (including the OID column).
CQ00255018 - Updating an Annotation feature class, such as updating
an attribute column value, stored using ATTRIBUTE_BINARY=BLOB and GEOMETRY_STORAGE=SDO_GEOMETRY
results in a Network I/O error.
CQ00255809 - If ArcSDE is installed on a Linux OS and an 'sdelayer -o
register ...' command is executed to register an Oracle Spatial layer
with ArcSDE, it will return a "Network I/O - Broken Pipe" error.
CQ00258440 - Performance enhancement: Unnecessary checking of Oracle
error codes has been removed to stop any contention on the Oracle oraus.msb
file on the operating system.
CQ00260262 - In rare situations, annotations may become corrupt when
reconciling. This occurs when reconciling geodatabase annotations and
copying rows from the child version linage to the new state in the parent
lineage. Users who have annotations using LONG RAW as the ATTRIBUTE_BINARY
setting in the keyword used for the feature class are at risk of running
into this bug. Users using LOB as attribute storage will not run into
this problem. The usual behavior pointing to this problem is the client
application (e.g. ArcMap) will crash when reading the annotation. NOTE: If you have experienced this problem, you must first
identify the corrupt annotations, delete them, and recreate them after
applying this Service Pack. This fix will stop future problems with
annotations becoming corrupt.
SQL Server
CQ00239359 - This fixes an error that occurs with the use of the Production
Line Tool Set (PLTS) Mapping Agency Solution with ArcSDE 9.0 and SQL Server.
Previous to this fix, when a user would be editing and using PLTS, the
"intersect ON during create new feature" function did not intersect correctly.
Now when editing and creating new features that should intersect, these
new features will intersect correctly.
CQ00252042 - Previously, when using ArcSDE 9.0 and SQL Server, a user
in ArcCatalog could log in using "" as a username and password
if the SQL Server instance had BUILTIN\ADMINISTRATORS as a Windows Group.
After this fix, if a user attempts to login with "" as a username
and password, it is treated as a SQL Server login and an error message
of "bad user login" is returned.
CQ00252456 - This fixes an issue with ArcSDE 9.0 and SQL Server. When
two users in ArcMap try to perform a save on the same edited data, a deadlock
situation could occur. SQL Server would automatically terminate one user's
operation and the data would not save correctly. This fix will handle
the deadlock internally by identifying the 'deadlock victim' and attempting
to save the operation.
ArcSDE Geocoding
CQ00235747 - Attempting to create a StreetMap Locator on AIX 64-bit
platforms results in this error: "Unable to store the address locator.
Locator cannot be validated." For all other platforms StreetMap Locators
can be created without issue.
Java-API
CQ00248238 - A “-148 NUMOFPTS IS LESS THAN REQUIRED FOR FEATURE”
error is returned by SeShape.generateBuffer() on a polygon shape if the
resultant buffer is a polygon shape with a donut hole.
CQ00251856 - A "-150 POLYGON DOES NOT CLOSE PROPERLY" error
is returned by SeShape.generateBuffer() on complex polygons.
CQ00257107 - A “-65 SPECIFIED VALUE IS NULL OR INVALID” error
is returned by SeShape.changeCoordRef() if a PeGeographicTransformation
object is used.
CQ00259018 - SeShape.generateBuffer returns a "-1 GENERAL FAILURE"
error on multipart polygon shapes with holes.
CQ00259019 - SeShape.generateBuffer returns an "ArrayIndexOutOfBoundsException"
error on some polygon shapes.
CQ00259981 - SeShape.generateBuffer() fails to generate buffers on some
polygon shapes. No error message is returned.
ArcSDE Server
CQ00228273 - Adding, then editing more than 50 feature classes in one
ArcMap session is causing the "Oracle error ORA-01000: maximum open cursors
exceeded" and causes the edits to fail.
CQ00248501 - In some cases, Direct Connect results in files being left
in /tmp. The workaround is to delete all files in /tmp with names like
*FIFO* when no ArcSDE connections are in progress on the machine direct
connect is being run from. Using direct connect with ArcSDE admin commands
that experience this problem is not fixed with this Service Pack.
ArcSDE Translators
CQ00248722 - A memory overwrite while importing UUID data using sdeimport
was found in the code review process. Users should see no negative affects
of this overwrite in the functionality of the sdeimport command. The issue
was addressed to ensure continued reliability.
CQ00252066 - Taking a layer with an OBJECTID column defined as NOT NULL
NUMBER(38), exporting it using sdeexport, and re-importing it causes the
OBJECTID column to be incorrectly defined as NUMBER(10).
CQ00258416 - An "Exportfile and SDE layer is not compatible: INCOMPATIBLE_ENTITY_TYPE"
error occurs when using sdeimport -o append when the layer being appended
to is stored in ArcSDE using ATTRIBUTE_BINARY=BLOB and GEOMETRY_STORAGE=SDO_GEOMETRY.
ArcSDE Versioning
CQ00255114 - Changes to SDE.DEFAULT may not be visible to a connected
non-versioned client. When a non-versioned ArcSDE client has an existing
connection (such as ArcIMS), new changes that are saved or posted to the
SDE.DEFAULT version by a versioned client should be available to subsequent
queries without reconnecting. Due to this issue, changes may or may not
be visible.
ArcSDE General
CQ00242498 - This issue is ArcGIS Server specific. StreetMap EDGE files
cannot be licensed for use with ArcGIS Server on UNIX.
CQ00247888 - AIX platform only: libgsrvr<db>90.so and libsde<db>srvr90.so
libs have no QFE identification tags for the AIX patch installs prior
to SP3. They should have tags referencing the QFE ID.
Issues previously addressed with ArcSDE 9.0 Service Pack 2, and included
in Service Pack 3
DB2
CQ00234905 - ArcSDE 9 / DB2 8.2 - Modify ArcSDE to support DB2 V8.2 Geodetic
SRS ID (>1999999999).
CQ00235423 - sdeimport -o update_else_insert fails after an sdeimport
-o delete.
CQ00235456 - sdeimport -o init sends incorrect sql and fails with SDE
Code (-49): Lock request conflicts with an established lock.
CQ00238790 - ArcSDE 9 / DB2 V8.2 performance degradation with use of AsSde()
method due to geodetic support - Use sdepoints method instead.
CQ00239958 - Optimize the standard version filter with logfiles that is
performing poorly on reconcile of specific versions.
CQ00247939 - Creating a logfile is committing user transactions.
CQ00248618 - ArcSDE 9 /DB2 8.2 - Use new signatures (3 parameters) of
the FromSDE functions to support only geodetic data, else continue to use
the old version.
Informix
CQ00243482 - Deletes may be committed during geodatabase user transactions.
Oracle
CQ00242124 - Windows XP server only. Getting an ORA00911: invalid character
error when trying to create an XML column.
CQ00242340 - Network I/O error occurring when loading XML documents with a
large string tag (100k+) and the last tag in the document encounters a tag
conflict.
CQ00242459 - mdupgrade command returning 12 Out of server memory on AIX.
CQ00242659 - Unable to View large metadata through an ArcIMS server, or by
directly fetching an XML document larger than 60K.
CQ00243040 - ArcSDE views created using sdetable -o create_view are not maintaining
the view definitions where clause when attempting to view and query the layer.
Results of these queries include records from outside the where clause definition.
CQ00243418 - SE_xmlcolumn_alter returning 1 Operation Failed when trying to
build an index.
CQ00243479 - Large XML documents with a tag larger than 100K are not being
indexed properly on 64 bit unix machines.
CQ00244577 - Using the identify tool in ArcCatalog or ArcMap against versioned
Point feature classes with a blob attribute column result in ORA-00932: Inconsistant
data type errors.
SQL Server
CQ00243809 - When using ArcSDE 9.0 and or 9.0 SP1 to connect to SQL Server,
Feature Datasets are missing Feature Classes. These feature classes appear
as SDE tables and will appear when the following conditions are met:
User-defined roles have been created for Data Readers and Data Writers and
Topology has been created in the Feature Dataset.
All
CQ00235701 - Geocoding and reverse geocoding resulting in StreetMap locator
errors on 64bit platforms.
CQ00242236 - Deleting the top level pyramid causes the entire pyramid to disappear
in certain raster mosaics.
CQ00242449 - Setting the PEOBJEDITHOME system environment variable for user-defined
projection engine objects to be persisted is not working with Coordinate Frame,
Position Vector and Bursa Wolf methods.
CQ00244020 - Internally match the old spelling of DHDN gcs/datum with the
new DHDN definition.
CQ00246042 - Incorrect storage of Polygons with an inclusion when using Oracle
Spatial geometry storage. When ArcSDE stores a polygon with an inclusion (an
inner ring that touches the outer ring at one vertex) into Oracle Spatial,
and when the first point of the outer ring is the vertex shared with the inner
ring, ArcSDE wrote the inner ring (geometric element) into the SDO_GEOMETRY
before the outer ring. This is not the recommended representation. The outer
ring always should appear first.
CQ00246824 - Oracle RAC users attempting to use the version_util.spb package
are experiencing ora-1405 errors when attempting to open states.
CQ00249941 - version_util.no_state_seq.spb insert_state package can corrupt
the state lineage with an invalid lineage_name in certain situations where
the new state is not a branch state.
Java-API
CQ00234329 - When an attempt is made to delete a pre-existing locator, the
SeLocator.delete() method returns NO PERMISSION TO PERFORM OPERATION exception
even when the Locator in question belongs to the same user.
CQ00247752 - SeShape.generateBuffer does not work on multi point shapes.
CQ00248365 - SeShape.generateBuffer returns "-1 General Failure" on some polygon
shapes.
CQ00161843 - Error retrieving Layers if the Coordinate Reference Projection
description has blank space characters.
CQ00236209 - The method SeShape.changeCoordRef() returns a NullPointerException.
CQ00236518 - SeShape.generateBuffer() returns a "NullPointerException" with
some polygon features.
CQ00237120 - SeShape.union() returns “-154 Multipart area has overlapping
parts” error.
CQ00237267 - Using SE_LOCK_POLICY connection concurrency policy, with dynamic
bind, hangs Java API applications.
CQ00237881 - If you use the 9.0 final version of the Java API is to update
a feature class that supports CAD data (all feature classes created via ArcCatalog
support CAD data), all features updated by the Java API application may be
corrupted. Any attempt to read the updated features from the feature class
will return a "-134: THE GIVEN SHAPE OBJECT HANDLE IS INVALID" error.
CQ00240742 - Spatial query fetch fails if SeQuery.setSpatialConstraints()
is invoked with argument calcMasks set to true.
CQ00243448 - New jar file concurrent.jar, required for PE performance functions,
added to 9.0 Java API install.
CQ00243459 - SeShape.generateBuffer() fails on some polygon features.
CQ00247502 - generateBuffer on polygons returns ArrayIndexOutOfBoundsException
error.
ArcSDE Server
CQ00245721 - Cursors not being closed/reused when inserting rows into a feature
classes feature table.
CQ00247338 - MDUpgrade command failing in a number of situations when attempting
upgrade.
Issues previously addressed with ArcSDE 9.0 Service Pack 1, and included
in Service Pack 3
DB2
CQ00210514 - Investigate possible memory leak in gsrvr while displaying
versioned data.
CQ00232301 - AIX ONLY - Copy/paste of large parcel dataset may result
in Network/IO error.
CQ00234828 - DB2 deadlocks with concurrent edit sessions.
CQ00236817 - DB2 can exhibit deadlocks under heavy concurrent editing
loads.
CQ00238017 - Fix errors and memory leaks.
CQ00238288 - Reconcile failure due to unique constraint violation.
CQ00239436 - Compress doesn't check for states marked in the current session.
CQ00237401 - shp2sde is mistakenly altering the default spatial reference
record.
Informix
CQ00210514 - Investigate possible memory leak in gsrvr while displaying
versioned data.
This website's graphical display is now viewable only with W3C standards-compliant browsers, but the content is accessible to all browsers and Internet devices.
View our supported browser matrix for more information on our website display.
