Skip to Content

Patches and updates

ArcGIS 10.1 SP1 QIP for (Desktop, Engine, Server) Spatial Reference Consistency Patch

Published: July 22, 2014


This patch corrects inconsistencies between a feature class’s spatial reference and the geodatabase’s metadata. This patch should be applied to all ArcGIS client applications that are connecting to geodatabases using Oracle. Running the geodatabase upgrade command is mandatory after applying the patch. Additional steps must be taken to create any spatial indexes that were previously dropped.


Esri® announces the ArcGIS 10.1 SP1 QIP for (Desktop, Engine, Server) Spatial Reference Consistency Patch. This patch addresses critical issues introduced into spatial reference metadata after upgrading Oracle enterprise geodatabases. Full explanations of the issues that are resolved with the patch are available in the following knowledge base articles:

Bug: Invalid spatial reference (4326) set when inserting/updating the sde gdb_items table when modifying the content for upgraded ArcGIS 10.0 geodatabases (ID 42335)

Bug: Unable to insert or update Oracle st_geometry feature classes, encountering ORA-20085 errors (ID 42461)

After applying the patch upgrading the geodatabase is mandatory. Failure to do so will result in inconsistent metadata and behavior. Upgrading the geodatabase will correct the metadata inconsistencies and prevent additional inconsistencies from being introduced by unpatched ArcGIS clients. After the upgrade is complete, additional steps must be performed to create missing or invalid spatial indexes. See the following article for more information:

HowTo: Perform post upgrade operations after installing the Spatial Reference Consistency Patch (ID 42776)

Upgrading all ArcGIS clients is strongly recommended. Failure to apply the patch will result in certain operations from succeeding because the upgraded geodatabase will prevent any new inconsistencies. See the following article for more information:

Error: Spatial Reference Consistency Patch - unpatched client behavior (ID 42775)

Issues Addressed with this patch

  • NIM099594 - The following Oracle errors: ORA-29877, ORA-20085 and ORA-06512, are encountered when attempting to make object schema changes, spatial index changes, or create Raster Dataset in ArcCatalog after upgrading certain ArcSDE 10.0 Oracle geodatabases.
  • NIM100823 - Rebuild the spatial index on a versioned feature class fails with an SRID mismatch error.
  • NIM101030 - When copy/pasting feature classes with the same spatial reference to Oracle SDO_GEOMETRY, new entries are created in the sde.spatial_references table instead of using an existing one.
  • NIM101204 - SDEBINARY/SDELOB layers are incorrectly referencing/sharing SPATIAL_REFERENCES entries from ST/SDO layers that have AUTH_SRID, AUTH_NAME.

Installing this patch on Windows

Installation Steps:

ArcGIS 10.1 SP1 QIP for Desktop, Engine or Server must be installed before installing this patch.

  1. Download the appropriate file to a location other than your ArcGIS installation location.

  2.     Checksum (Md5)
    ArcGIS Desktop Background Geoprocessing (64-bit) ArcGIS-101SP1QIP-BGDT-SRC-Patch.msp 0E93591E516625569C12B4BD853AE25B
    ArcGIS Engine Background Geoprocessing (64-bit) ArcGIS-101SP1QIP-BGE-SRC-Patch.msp 581BDD3257A5837D71136637E1F278BA
    ArcGIS for Desktop ArcGIS-101SP1QIP-DT-SRC-Patch.msp 9882A028CBE49F23CE4E54A04AD0CFC4
    ArcGIS Engine ArcGIS-101SP1QIP-E-SRC-Patch.msp 011A608A7570CA346D72EDCDC14A62B2
    ArcGIS for Server ArcGIS-101SP1QIP-S-SRC-Patch.msp F02075FF2F0BCBCDB54BCD59CCA9EC19

  3. Make sure you have write access to your ArcGIS installation location.

  4. Double-click ArcGIS-101SP1QIP-<Product>-SRC-Patch.msp to start the setup process.

    NOTE: If double clicking on the MSP file does not start the setup installation, you can start the setup installation manually by using the following command:

    msiexec.exe /p [location of Patch]\ArcGIS-101SP1QIP-<Product>-SRC-Patch.msp

  5. After the installation procedure has finished, complete Upgrade a geodatabase in Oracle section.

Installing this patch on Linux

Installation Steps:

Complete the following install steps as the ArcGIS Install owner. The Install owner is the owner of the arcgis folder.

ArcGIS 10.1 SP1 QIP for Engine or Server must be installed before installing this patch.

  1. Download the appropriate file to a location other than your ArcGIS installation location.

        Checksum (Md5)
    ArcGIS Engine Coming Soon!  
    ArcGIS for Server ArcGIS-101SP1QIP-S-SRC-Patch-lx.tar 2B5C58C612477540A011D5FA6480CE97

  2. Make sure you have write access to your ArcGIS installation location, and that no one is using ArcGIS.

  3. Extract the specified tar file by typing:

    % tar -xvf ArcGIS-101SP1QIP-<Product>-SRC-Patch-lx.tar

  4. Start the installation by typing:

    % ./applypatch

    This will start the dialog for the menu-driven installation procedure. Default selections are noted in parentheses ( ). To quit the installation procedure, type 'q' at any time.

  5. After the installation procedure has finished, complete the Upgrade a geodatabase in Oracle section.

Upgrade a geodatabase in Oracle

Running geodatabase upgrade is mandatory after applying this patch. To upgrade the geodatabase follow these instructions.

  1. Open ArcCatalog or ArcMap.
  2. Make a direct connection to your your geodatabase as the geodatabase administrator user.
  3. Right-click the geodatabase connection and click Properties.
  4. Navigate to the General tab and check the Upgrade Status section.
  5. Click the Upgrade Geodatabase button.

Please go to the ArcGIS Web help topics for more information on upgrading:

"Preparing to upgrade a geodatabase in Oracle"

Patch Updates

Check the Patches and Service Packs page periodically for the availability of additional patches. New information about this patch will be posted here.

How to identify which ArcGIS products are installed

To determine which ArcGIS products are installed, choose the appropriate version of the PatchFinder utility for your environment and run it from your local machine. PatchFinder will list all products, hot fixes, and patches installed on your local machine.

Getting Help

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

Download ID:2103

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options