Issues addressed with ArcSDE 9.1 Service Pack 1

DB2

• CQ00251905 - Zooming in to a geodatabase raster catalog causes an Invalid Cursor State error.
• CQ00269426 - A copy/paste of a raster catalog fails with an invalid cursor state error.
• CQ00271516 - During reconcile of a child version, an exclusive lock may be placed on the adds table causing the connection to hang.
• CQ00275114 - Rows from original child state may be lost during a reconcile if the child version is in a different state than the parent.
  

Informix

• CQ00264652 - Deadlock issues in Informix. (Informix Only)
• CQ00264987 - ArcSDE for Informix memory leak in the gsrvr process while editing data. If you monitor the gsrvr process on the ArcSDE server, you'll notice an unusually large amount of the process memory being allocated.
• CQ00268181 - Reconciles with joined tables may result in a Net I/O error in some situations.
• CQ00270823 - Serialization error or locking of logfile tables occurs when logfile selections are made in multiple sessions with the same user.
• CQ00273706 - Informix databases are crashing when an attempt is made to rename a table with more than 20 characters using ArcCatalog or sdetable -o rename.
• CQ00276110 - Reconciles with custom conflict resolution code may give incorrect results or cause a Network I/O error.
  

Oracle

• CQ00245990 - CQ00263567—SE_stream_update_ordered crashes the gsrvr on Oracle if spatial column is updated..
• CQ00255310 - Selection on Oracle Spatial geodetic layer returns incorrect result.
• CQ00263411 - Change ORDERED hints to LEADING.
• CQ00264515 - Random Oracle Error ORA-03127 when copying data between two SDE Oracle tables that contain a BLOB column.
• CQ00265240 - Under a heavy load (number of users and operations) Oracle deadlocks may occur.
• CQ00265668 - BLOB (attribute) spatial selections not resetting dblayer blob properties correctly.
• CQ00266095 - Oracle Spatial problem with assigning PointID values and persisting the values. Although there is no error returned when an attempt is made to update a feature’s PointID values, the assigned value is not stored.
• CQ00269208 - Performance issue with some large versioned spatial queries results in slow return times for selected features.
• CQ00269665 - ArcSDE 9.1 will not connect to Oracle10gR2 databases. This fix will allow ArcSDE 9.1 SP1 to connect to Oracle10gR2.
• CQ00272341 - Oracle Spatial—Network I/O error editing geometric network in complex feature dataset.
• CQ00275613 - new_edit_state can create invalid lineage entries for new states during compress.
• CQ00280524 - Piecewise fetching of LONG RAW attribute data drops 60K chunk when raw data exceeds transmission buffer size.
• CQ00280752 - When using standalone session log files performing reconcile and post where conflicts are detected and analyzed, you may encounter an error indicating the maximum number of session cursors has been exceeded.
  

SQL Server

• CQ00248869 - ArcMap > Select By Attributes > Select from current selection does not work against ArcSDE on SQL Server 2000.
• CQ00261144 - When using ArcSDE for SQL Server and the Multiple Database Model, you will be unable to create an empty geometric network in any database except the sde database. An error is returned that states: Invalid database name[sde.sde.GDB_NetWeights].
• CQ00277777 - Add support for SQL Server 2005—SQL Server 2005 specific changes to enable registering datasets as versioned.
• CQ00277778 - Add support for SQL Server 2005—SQL Server 2005 specific changes to enable copy and paste of feature datasets using ArcCatalog.
• CQ00282110 - ArcMap > Select By Attributes > Select from current selection does not work against ArcSDE on SQL Server 2005.
  

ArcSDE Geocoding

• CQ00274876 - For some datasets, attempting to geocode addresses in ArcSDE for Oracle results in not finding all the matched addresses.
  

ArcSDE Raster

• CQ00243041 - When 16-bit raster data is loaded with zero-valued data, SE_rasbandinfo_get_stats_histogram does not return the correct histogram.
• CQ00267168 - Raster delete query needs to be modified to improve performance when deleting rasters from the raster catalog.
  

Java-API

• CQ00261467 - SeShape.intersect() on intersecting lines returns null.
• CQ00265971 - Incorrect results from SeShape.intersect() on a buffer shape obtained from executing SeShape.buffer().
• CQ00267737 - Connection attempt hangs if locale is set to Japanese (EUC) on Solaris.
• CQ00271882 - SeShape.isTouching fails with java.lang.ArrayIndexOutOfBoundsException error.
• CQ00271884 - SeShape.build fails with a NullPointerException.
• CQ00274815 - Unable to load custom projections using the PeFactory.projcs() method.
• CQ00280047 - After a compress operation, ArcSDE leaves rows behind in the Adds and Deletes tables.
  

ArcSDE Client

• CQ00276714 - SE_CONNECTION_FREE is not freeing up socket connections and eventually results in the ArcSDE Server machine being unable to start any further connections.
  

ArcSDE Server

• CQ00258942 - Possible performance problem when opening ArcMap documents. A query is repeatedly being sent to the database when it should be getting it from the stream cache instead.
• CQ00268047 - When attempting to perform a query against a sequence and passing in a fully-qualified owner and sequence name, the owner is removed and the sequence cannot be located. This results in a Sequence not found error. This problem affects ArcFM users.
• CQ00277129 - Querying certain data in ArcMap that contains a join involving a view causes a Network I/O error.
  

ArcSDE Translators

• CQ00234997 - sdeexport command fails to export raster image when there is a row of empty tiles at the bottom of an image.
  

ArcSDE Versioning

• CQ00274543 - When running the sdeversion -o compress command and there are more than 150 states in attempting to trim back to base, a parse error will occur.
• CQ00276057 - When SE_state_merge is called repeatedly on the ArcSDE database, the database reaches a state after which each call to SE_state_merge results in a Network I/O error.
• CQ00279152 - Range query scanning states needs to use ORDER BY.
  

ArcSDE General

• CQ00252137 - The sdedbtune -o import command dose not import the B_INDEX_RASTER parameter correctly.
• CQ00265541 - SDE admin command returns incorrect error message for invalid username/password.