ArcSDE 9.1 SQLServer NULL Field Patch

Under certain conditions, ArcSDE for SQL Server users may not be able to delete records in the Business table using ArcObjects with the Shape field equal to NULL. This patch fixes this condition, so that users will be able to do so.

• Issues Fixed with this Patch
• Files Installed in this Patch
• 
  
• Installing this Patch
        Server
        — Windows
        ArcSDE SDK
        — Windows
        ESRI Products connecting to ArcSDE (Application and Direct Connect connections)
        — Windows
  
• How to identify which Patch is installed
• Patch Updates
• Getting Help

Installing the Patch

ArcSDE 9.1 Service Pack 2 must be installed before you can install this Patch. 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 Patch using your SDE user account.

REQUIRED INSTALL STEP: If you connect to ArcSDE 9.1 via an Application Server and Direct Connect connections using ArcGIS 9.1, ArcIMS 9.1, or ArcView GIS 3.3 with DBA 2.1g make sure you also see ESRI Products connecting to ArcSDE (Application and Direct Connect connections).

Server Install for Windows

Installation Steps

1. Make sure you have write access to the ArcSDE installation folder, that no one is using ArcSDE, and that the ArcSDE service is down.
2. 
   
   
3. Download the appropriate files to a location other than the ArcSDE installation folder:
4. 
   

   sde91-NFpatch-sql-win.exe

   2 MB

   
   
5. Double-click the appropriate executable to start the install process.
6. 
   
   
7. When Setup starts, follow the instructions on your screen.
8. 
   
   
9. To upgrade, run sdesetupmssql. Failure to do so may cause problems in starting the service or with connecting to the service.
10. 
    
    

    % sdesetupmssql -o upgrade –u sde –p <SDE_Admin_password>

11. As the SDE user, run the following command to restart the ArcSDE service:
    
    

    sdemon -o start

ArcSDE SDK Install for Windows

1. Make sure you have write access to the ArcSDE SDK installation folder:.
2. 
   
   
3. Download the appropriate files to a location other than the ArcSDE SDK installation folder:

4. ArcSDE SDK sde91-NFpatch-sdk-win.exe	2 MB
   ArcSDE Java SDK sde91-NFpatch-javasdk-win.exe	1 MB

   
   
5. Double-click the appropriate executable to start the install process.
6. 
   
   
7. When Setup starts, follow the instructions on your screen.
8. 
   

ESRI Products connecting to ArcSDE (Application and Direct Connect connections).

Windows

• If you connect to ArcSDE 9.1 using ArcGIS 9.1 Desktop (ArcInfo 91, ArcView 9.1, ArcEditor 9.1, ArcReader 9.1), ArcGIS Engine 9.1, ArcGIS Server 9.1, ArcIMS 9.1, ArcInfo Workstation 9.1, or ArcView GIS 3.3 with DBA 2.1g, please follow the steps below to install this Patch to your ArcGIS 9.1 Desktop (ArcInfo 91, ArcView 9.1, ArcEditor 9.1, ArcReader 9.1), ArcGIS Engine 9.1, ArcGIS Server 9.1, ArcIMS 9.1, ArcInfo Workstation 9.1, or ArcView GIS 3.3 with DBA 2.1g installation folder:
  
  
• Before you start, make sure you have write access to the installation folder, then download the zip file to that location:
  
  

  sde91-NFpatch-esri-win.zip

  2 MB

  
  

• ArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, ArcIMS Application Server (in that order).

• Use WinZip to extract the new file from sde91-sqlpatch1-esri-win.zip to the appropriate installation folder, see list below:
  
  
  • ArcGIS Desktop, Server, Engine, Reader, or ArcView 9 - <installation-folder>\arcgis\bin
    
  • ArcGIS Workstation - <installation-folder>\arcexe9x\bin
    
  • ArcView GIS - <installation-folder>\av_gis30\arcview\(bin32 & DCONNECT\LIB)
    
  • Depending on the ArcIMS Setup features installed, the SDE client file could be located in one or more of the following locations:
    
    • C:\Program Files\ArcGIS\bin
      
    • C:\Program Files\ArcGIS\ArcIMS\IndexBuilder
      
    • C:\Program Files\ArcGIS\ArcIMS\Metadata\Commands
      
    • C:\Program Files\ArcGIS\ArcIMS\Server\bin
      
    
    

• ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor and ArcIMS Tasker (in that order).
  

How to identify which Patch is installed

1. Windows
   

   To check for the presence of a Patch, 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 Patch distribution can be uniquely identified in this manner. The identification string for this Patch should read:

   • QFE-SDE-91-CQ00294643

Patch Updates

Check the Online Support Center periodically for the availability of additional Patches or Service Packs. New information about this Patch will be posted here.

Getting Help

Domestic sites, please contact ESRI Technical Support at 1-888-377-4575, if you have any difficulty installing this Service Pack. International sites, please contact your local ESRI software distributor.

Download ID:1182