ArcSDE 9.0 Service Pack 1

This Service Pack is now obsolete. It has been superceded by the ArcSDE 9.0 Service Pack 2.

This Service Pack is now obsolete. It has been superceded by the ArcSDE 9.0 Service Pack 2.

• Introduction 
• Issues Fixed with this Service Pack
• Files Installed in this Service Pack
        Server
        — UNIX
        — Windows
        ArcSDE SDK
        — UNIX
        — Windows
  

Introduction

ESRI is pleased to announce ArcSDE 9.0 Service Pack 1. Please download and install this required Service Pack at your earliest convenience. This Service Pack contains performance improvements and maintenance fixes that deal specifically with the issues listed below under Issues Fixed with this Service Pack.

Issues Fixed with this Service Pack

• • 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.
    CQ00230320 - se_table_rename returns underlying DBMS error.
    CQ00238017 - Fix errors and memory leaks.
    CQ00238288 - Reconcile failure due to unique constraint violation.
    CQ00239211 - Deadlock Issues when multiple users edit in Informix.
    CQ00239214 - Fix Insure reported memory leaks for Informix.
    CQ00239436 - Compress doesn't check for states marked in the current session.
    CQ00244652 - gsrvr crash can occur during logfile insert when number of cursors held reaches above Max cursors.
    

  • Oracle

    CQ00237945 - Oracle Spatial 10g (only): Cannot create feature classes with measures.
    CQ00241971 - ORA-01480 trailing null missing from STR bind value returned when loading an XML doc that has string tag value length ~80K.
    

  • SQL Server

    CQ00238017 - Fix internal errors and memory leaks.
    

  • Metadata Server

    CQ00240789 - Improve performance for ArcIMS Metadata Server on Oracle when publishing metadata documents.
    

  • Java-API

    CQ00237881 - After using SeShape.update, getting error: "-134: THE GIVEN SHAPE OBJECT H.
    

  • All

    CQ00239819 - Fix a potential for memory read overflow when working with very specific shapes in a feature class.
    CQ00237339 - (TRU64 and HP9i64 only) sde2shp fails when using direct connect.
    CQ00240772 - Setting the Vertical perspective coordinate system fails in ArcMap using ArcSDE data.
    CQ00241374 - Searching metadata using a search string with odd number 8-bit characters is not working.
    CQ00241628 - After loading an XML with a tag value length > 100K, an SDE Error: -51 is returned on the next doc.
    CQ00247184 - Direct connect doesn't work with HPUX at 9.0.
    

Files Installed in this Service Pack

UNIX (Server)

• Under the $SDEHOME/bin directory:
  
  

• All Databases
  

  • gsrvr.shared
    gsrvr.static
    
• Under the $SDEHOME/lib directory:

  All Databases
  

  • libsg90.so (.sl for HP)
    
  DB2
  
  • libgsrvrdb290.so
    libsdedb2srvr90.so
    sdesrvsp
    sdesrvsp.bnd
    
  Informix
  
  • libgsrvrinf90.so (.sl for HP)
    libsdeinfsrvr90.so (.sl for HP)
  Oracle 8i
  
  • libgsrvrora8i90.so (.sl for HP)
    libsdeora8isrvr90.so (.sl for HP)
    
  Oracle 9i
  
  • libgsrvrora9i90.so (.sl for HP)
    libsdeora9isrvr90.so (.sl for HP)
    

Windows (Server)

• Under the %SDEHOME%\bin folder:

• All Databases
  

  • gsrvr.exe
    sg90.dll
    
  DB2
  
  • gsrvrdb290.dll
    sdedb2srvr90.dll
    sdesrvsp.dll
  Informix
  
  • gsrvrinf90.dll
    sdeinfsrvr90.dll
  Oracle 8i
  
  • gsrvrora8i90.dll
    sdeora8isrvr90.dll
  Oracle 9i
  
  • gsrvrora9i90.dll
    sdeora9isrvr90.dll
  SQL Server
  
  • gsrvrsql90.dll
    sdesqlsrvr90.dll
    
    

• Under the %SDEHOME%\lib folder:

• DB2
  

  • sdesrvsp.bnd
    

UNIX (ArcSDE SDK)

• Under the $SDEHOME/lib directory:
  
  
  • jsde90_sdk.jar
    libgsrvrdb290.so
    libgsrvrinf90.so (.sl for HP)
    libgsrvrora8i90.so (.sl for HP)
    libgsrvrora9i90.so (.sl for HP)
    libesdedb2srvr90.so (IBM only)
    libsdeinfsrvr90.so (.sl for HP)
    libsdeora8isrvr90.so (.sl for HP)
    libsdeora9isrvr90.so (.sl for HP64)
    libsg90.so (.sl for HP)
    libsg90.a

Windows (ArcSDE SDK)

• Under the %SDEHOME%\bin folder:

• All Databases C-API SDK
  

  • gsrvrdb290.dll
    gsrvrora8i90.dll
    gsrvrora9i90.dll
    gsrvrsql90.dll
    sdedb2srvr90.dll
    sdeora8isrvr90.dll
    sdeora9isrvr90.dll
    sdesqlsrvr90.dll
    sg90.dll
    
    

  All Databases Java SDK
  

  • sg90.dll
    jsde90_sdk.jar
    

Download ID:833