ArcSDE 9.2 Service Pack 3 contains a number of new fixes as well as all
the previous fixes released in Service Pack 1 and 2
New issues addressed with Service Pack 3
SQL Server Specific
- NIM007077 - sdesetup -o upgrade does not use DBTUNE storage parameters for SQL Server file groups correctly.
- NIM008325 - sdelayer -o si_stats does not return information (or correct information) when run against SQL Server databases.
- NIM009399 - Beginning with ArcGIS® 9.2, SQL Server geodatabase identifiers, such as feature class or table names, cannot be case sensitive. This means the contents of the ArcSDE® and geodatabase repository tables (SDE_ and GDB_ tables) cannot be created and stored using a case-sensitive collation. Your database collation must be case insensitive, however individual character data columns can store case-sensitive data. This patch will assist users in converting existing 8.3, 9.0 or 9.1 SQL Server geodatabases with a case-sensitive database collation to a 9.2 geodatabase using a case-insensitive collation. After applying the patch users will be able to enable case-sensitive collations on individual character data columns.
DB2 and Informix Specific
- NIM007362 - When data is updated in a child replica using geodatabase replication, those features or records are not synchronized to the parent replica. Features that were inserted or deleted, however, are synchronized properly.
- NIM009097 - DB2 only - When saving edits to a Move to Base Feature class as a privileged non-owner, a "Version could not be posted" error may occur.
- NIM005992 - SDO_GEOMETRY or Spatial Type for Oracle - When zooming in on event layers in ArcMap, all the features of the event layer disappear.
- NIM008635 - Not all features in a large (> 1000) selection set move in a single edit operation. Fails with this error: db_sda_execute_stmt::Invalid OCI handle (-2).
- NIM009208 - Extent calculation may be incorrect when (1) imported from feature class with nil (empty) geometries, or (2) extent is recalculated with "sdelayer -o alter -E calc" and feature class contains nil (empty) geometries .
- NIM010346 - Tru64 only - Some SQL functions fail with error: symbol "SgShapeFree" unresolved.
- NIM010347 - Using SQL to insert points into an ST_POINT geometry type may round the minimum-bounding rectangle values in the geometry's metadata.
- NIM010348 - AIX and Tru64 only - Creating a pSelectionSet in ArcObjects can cause an "Out of server memory" error (-12) when the query filter WHERE clause is blank or null.
- NIM007138 - XML document won't publish with long content in a tag that is indexed as STRING.
- NIM008343 - Editors may encounter a unique constraint violation when reconciling edits made to data that has been registered as versioned with the option to move edits to base.
- NIM008806 - Improve connection time to ArcSDE geodatabases containing a large number of tables by restricting the tables returned based on the connecting user’s privileges to the tables. Note: If the connecting user owns a large number of tables, an improvement in connection times may not be experienced.
- NIM010282 - Not all features in a large (> 1000) selection set move in a single edit operation. Fails with this error: db_sda_execute_stmt::Invalid OCI handle (-2).
- NIM007546 - Receive error message, “Failed to connect to the specified server. Server machine not found.” when attempting to use a server alias that is 32 characters in length or greater in the ArcCatalog 9.2 Spatial Database Connection Properties dialog box. The fix allows the use of up to 32 characters in the server name.
- NIM008481 -Editors receive the error message, “Feature could not be created, the geometry is invalid” when trying to edit data that meets the following criteria:
- Data, such as a shapefile or ArcSDE export file, was originally created in a previous version of ArcGIS (9.1 or earlier).
- Data is loaded into the ArcSDE geodatabase using the ArcSDE administration command tools (for example, shp2sde or sdeimport).
- Data is subsequently registered with the geodatabase.
- NIM010392 - ArcSDE’s giomgr process in a 3 tier configuration can crash if an excessively large numeric value is written to the TCP port. This causes a buffer overflow and stops the process from running. This is an obscure/rare condition.
NON Database specific Server fixes
- NIM007048 - Memory allocation has been optimized so that the gsrvr process does not consume or hold as much memory as it did in previous releases.
- NIM007607 - sde2shp fails with error "Invalid state ID value" when using -V option.
- NIM008157 - Unable to connect to ArcSDE through ArcCatalog after the spatial references on existing data are upgraded to high precision.
- NIM008315 - SDE servers on UNIX operating systems - Users who have permissions to access more than 5000 tables or feature classes in the geodatabase cannot connect to the ArcSDE geodatabase through ArcGIS.
- NIM008390 - With ArcIMS' Metadata Server - XML documents will not be published and an error message will be returned if a user attempts to publish an XML document if the value stored in tags that are indexed as VARCHAR exceeds 256 characters. (Previous behavior allowed the document to be published without error, but the indexed VARCHAR information was truncated to 256 characters.)
Issues previously addressed with Service Pack 2, and included in Service Pack 3
- NIM006032 - Support geometries larger than 1MB in size for DB2. Support needs to be added for geometries as large as 4MB (4190000 byte) in ArcSDE 9.2 for DB2. A corresponding fix was required in DB2, so DB2 UDB 8.2 FP 15 is required to take advantage of this enhancement. If you're using a pre-FP15 version of DB2, the software continues to work as before , but you cannot load or use data with a geometry size larger than 1MB.
- NIM007057 - Using the option "“Compress all edits in the Default version into the base table" when unregistering as versioned can corrupt the table.
- NIM007490 - When performing concurrent editing in an ArcSDE for DB2 or Informix geodatabase, deadlocks are encountered when users save their edits.
- NIM005106 - Granting two identical Oracle roles with the Select permission to a user will cause layers to disappear in ArcCatalog 9.2. Multiple grants of the same privilege on the same table from a different grantee, for example, from a different role, will cause access privilege problems.
- NIM005767 - Oracle dead locks encountered when local variable lineage_name is not fully qualified. See KB # 32308.
- NIM005974 - SDE upgrade and service startup fail at checking existence of geometry_columns table.
- NIM005987 - Network I/O error encountered while running queries with outer joins from custom AO VBA code against ArcSDE on Oracle.
- NIM006341 - When geometry is stored as BINARY, LOB, or OGCWKB, selected features of a feature class that is not registered with the geodatabase are not drawn/highlighted in the ArcMap map display window.
- NIM007057 - Using the Compress all edits in the default version into the base table option when unregistering as versioned can corrupt the table.
- NIM007189 - Archiving fails if a field is added to a feature class after the archive is created.
- NIM007481 - sdeexport will not support the export of GeoRaster data, because native storage of Oracle GeoRaster is different from regular SDE raster.
- NIM006455 - Trying to copy and paste an annotation feature class that has rows in it fails with an ORA-1008 not all variables bound error. This happens with SDO_GEOMETRY (Oracle Spatial) only.
- NIM006734 - Connections to SDE using SQL Server 2005 are very slow.
- NIM007528 - Large INSERT operations (loading data, building networks, etc) are slower at 9.2.
- NIM005450 - When loading and mosaicing 4-bit TIFF raster images, the first image loaded displays properly; subsequent 4-bit TIFF raster images do not display and cannot be queried.
- NIM006003 - sderaster -o export command fails (hangs) when exporting sde rasters with color maps.
- NIM006286 - Error building pyramid using 9.2 ArcSDE client for data stored in an ArcSDE 9.1 server when the raster is compressed with JPEG.
- NIM006577 - Using ArcGIS 9.2 to display raster data from an ArcSDE 9.1 geodatabase hangs if ArcGIS is on the same machine as the ArcSDE server.
- NIM007481 - sdeexport will not support the export of GeoRaster data because native storage of Oracle GeoRaster is different from regular SDE raster.
- NIM006060 - Creating new geodatabase with ArcSDE9.2 on SQL Server fails when customized address locator is installed.
- NIM006735 - When creating an address locator in ArcCatalog, ArcCatalog may crash if Reference Data name is longer than 30 characters.
- NIM006898 - Creating locator from an empty feature class causes a failure.
- NIM007492 - Provide a way to process input values in fields other than standardization.
- NIM005829 - When using ST_ Geometry for vector data and geodatabase annotation, ArcMap hangs after zooming and attempting to redisplay.
- NIM006055 - When storing geometry as ST_Geometry, features can disappear when panning and zooming.
- NIM006282 - Improve performance of Oracle ST_Geometry relational operators by using statistics. Gathering DBMS statistics now adds information to the st_geometry_index table for each table.
- NIM007480 - When geometry is stored as ST_Geometry, drawing performance is too slow. The performance drawing ST_Geometry points should be comparable to SDEBinary. Traces show a 30% difference when drawing larger (500K) feature classes.
Issues perviously addressed with Service Pack 1, and included in Service Pack 3
- CQ00296130 - DB2 Network I/O error occurs when reading blob data of size 5M.(DB2 only)
- CQ00297171 - Memory leak when editing if feature class is registered with move edits to base.
- CQ00298480 - In-Place Spatial Reference converters fail on Unix Platforms.
- CQ00292541 - When ArcSDE attempts to write a null (non-existent) geometry to an SDO_GEOMETRY column, ArcSDE instead writes a nil (empty) geometry. Placing a nil geometry where there should be a null geometry is incorrect, and causes problems for some ArcGIS processing and with third-party applications that expect "NULL".
- CQ00296298 - Oracle Spatial: Zooming on edited compound curve feature classes caused features to disappear.
- CQ00297271 - Query fails with SDE error code -38 when using joined tables and ArcSDE 9.2 featureclass with SDO_GEOMETRY layer config.
- CQ00298816 - Improve SDELOB performance using LONG API binding.
- CQ00297008 - Geocoding fails in SqlExpress/Direct Connect SDE - Without this, geocoding with personal and workgroup ArcSDE doesn’t work.
- NIM005825 - Adding columns in a GPS-enabled ArcSDE Personal geodatabase using GPS Analyst causes ArcCatalog to crash.
- CQ00296867 - Add a confirmation to the sderaster update operation to avoid users of the sderaster -o update operation mistaking it for the mosaic operation and accidently replacing a raster dataset wth the input image. This fix will require users to confirm they really want to replace the existing raster dataset with the input image file when the update operation executes.
- CQ00297273 - Rolling back an Oracle transaction on a mosaic operation does not rollback the pyramid tiles. Currently users must manually rollback a failed user transaction on a mosaic operation. This work around was documented as a known problem for ArcSDE 9.2 final.
- CQ00299517 - The ArcSDE sdo_georaster trigger is not maintaining the raster_id column value of the user_sdo_geor_sysdata table.
- CQ00293119 - Port C API function SE_table_rebuild_index to Java API. - To keep in sync with the c-api functionalities for 9.2 release.
- CQ00293231 - SeShape.generateCircle() not available in java-api.
- CQ00293261 - SeShape.generateBuffer fails with error -148 NUMOFPTS IS LESS THAN REQUIRED FOR FEATURE.
- CQ00294131 - Incorrect layer extent returned for high precision coordinate references.
- CQ00294156 - Java API function killProcess(<pid>, “<admin pwd>” doesn’t work. Need to make the killProcess a workable function.
- CQ00294298 - SeShape1.overlay(seShape2) throws exception if SeShape contains more than 4k points.
- CQ00296302 - (Java api) PeCSTransformations.geog1ToGeog2 doesn't work for some specific transform code.
- CQ00298974 - Port adjusted coordinate system to keep in sync with what the c-api has released.
- CQ00299289 - PCSConstants are not calculated accurately. There will be a slight difference in the projection calculation between the c-api and the java-api if the pcsconstants values are not calculated in the exact manner as the c-api.
- CQ00299305 - PeProjectedCSRes not returning the correct PeProjectedCS object.
- CQ00296785 - When specifying the instance to connect to by using the ArcSDE service port number, specifying "/tcp" after the port number causes a failed to connect error in 9.2.
- CQ00296730 - When attempting to start the ArcSDE application server with the service entry absent from the system services file the giomgr crashes rather than handling the failure and reporting a warning message.
- NIM005805 - Adding to a current selection set fails when creating a selection and having the attribute table open in Selected View mode.
- CQ00296168 - A<> shape column entries are not deleted from the sde.st_geometry_columns table when the versioned Feature Class is deleted. The affect of this is "orphaned" entries in the table that should not affect any functionality.
- CQ00296625 - Creating the spatial indx on certain layer data & spatial ref may generate spix records that fail during Identify's. If you run into this issue spatial selections will fail to select/Identify on small search areas involving small features.
- CQ00298817 - Add ST_Geometry operator ST_TRANSFORM.
- CQ00299145 - ORA-06522: Unsatisfied code symbol '__shlTerm' when using the st_geometry spatial type for Oracle functions on HP. - Spatial type operators do not work on HP without this fix.
- NIM005804 - Network I/O error when viewing/working with the attribute table of a feature class after performing a selection of more than 100 features.
- NIM005829 - Spatial selections against GDB annotation featureclasses lock up the server.
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.