English
Continue in the app

ArcGIS (Desktop, Engine, Server) File Geodatabase SQL Performance Patch

Summary

This patch resolves a attribute performance issue in the file geodatabase introduced in ArcGIS 10.6.1 and repaired as part of the 10.8 release. It primarily effects expressions involving LIKE. If you are seeing performance issues with your queries against a file geodatabase starting at 10.6.1 you should install this patch.

Description

Introduction

Esri® announces the ArcGIS (Desktop, Engine, Server) File Geodatabase SQL Performance Patch. This patch resolves a attribute performance issue in the file geodatabase introduced in ArcGIS 10.6.1 and repaired as part of the 10.8 release. It primarily effects expressions involving LIKE. If you are seeing performance issues with your queries against a file geodatabase starting at 10.6.1 you should install this patch. This patch deals specifically with the issues listed below under Issues Addressed with this patch.


Issues Addressed with this patch


  • BUG-000131010 - The Find command in ArcGIS Desktop and ArcGIS Servers REST endpoint takes exponentially longer to execute from 10.6.0 to 10.6.1.
  • BUG-000119030 - Querying or selecting from a compressed file geodatabase over eight times in ArcGIS Desktop 10.6.1 is slower than in ArcGIS Desktop 10.5.1.

Installing this patch on Windows


Installation Steps:


The ArcGIS product listed in the table must be installed on your system before you can install a patch. Each patch setup is specific to the ArcGIS product in the list. To determine which products are installed on your system, please see the How to identify which ArcGIS products are installed section. Esri recommends that you install the patch for each product that is on your system.

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

  2. ArcGIS 10.7.1  
       
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-1071-BGDT-FGSP-Patch.msp
         Checksum
         (SHA256)
    7C0AFC72B2F63718100C7700914534357FC822BC1FCDA09222CF040FB2936617
       
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-1071-BGE-FGSP-Patch.msp
         Checksum
         (SHA256)
    ACE98A0B8EB2660412CD9F72CBD7A105AFE8944C92FA15B1C10C28AD99C0D42F
       
    ArcGIS Desktop ArcGIS-1071-DT-FGSP-Patch.msp
         Checksum
         (SHA256)
    D1DF551AA53008417E0A620EF77598B1FFCA0090989A2D740A24B838F28D0C9E
       
    ArcGIS Engine ArcGIS-1071-E-FGSP-Patch.msp
         Checksum
         (SHA256)
    6F0A9879D3E4B11CAFBA04427E9DCDA0FBB64CD2045CDD3C241FAD1CCC66CEE2
       
    ArcGIS Server ArcGIS-1071-S-FGSP-Patch.msp
         Checksum
         (SHA256)
    B71966935BC779680831A047B6711AC260D7403187114780BCBE87D48B7186BB
       
    ArcGIS 10.7  
       
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-107-BGDT-FGSP-Patch.msp
         Checksum
         (SHA256)
    10748AD5824336177F150AE2E2B29C0467A8C6A2DC17F147F17FDDFE4CFB18C0
       
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-107-BGE-FGSP-Patch.msp
         Checksum
         (SHA256)
    CCBC8BCF6235DBF5D8969660BB4CE63C1F6226EFB375468E49BA824F960982AF
       
    ArcGIS Desktop ArcGIS-107-DT-FGSP-Patch.msp
         Checksum
         (SHA256)
    DDC6C604A7B468955BD0926EB87E08A8267500F3F9A1D4F71CDB5F17624CDB03
       
    ArcGIS Engine ArcGIS-107-E-FGSP-Patch.msp
         Checksum
         (SHA256)
    75563AA170D7E83C46FA70CBEA51A847D42CCCA6D0EBC357A73F7FAFE12D9188
       
    ArcGIS 10.6.1  
       
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-1061-BGDT-FGSP-Patch.msp
         Checksum
         (SHA256)
    B02999DF5EC11457149C3102BEB87EF4C6E76F2EE81CBCE162FF98912E7BFE85
       
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-1061-BGE-FGSP-Patch.msp
         Checksum
         (SHA256)
    9022FB44FC1B3CCC1525A7B9820B0413A565366E0EC5164B46BC64E45B8A12BB
       
    ArcGIS Desktop ArcGIS-1061-DT-FGSP-Patch.msp
         Checksum
         (SHA256)
    9990635087493091D5C890CA8FB0E03F5FB5A5C84CA2D89D54AB94368940D0FB
       
    ArcGIS Engine ArcGIS-1061-E-FGSP-Patch.msp
         Checksum
         (SHA256)
    97994CDF7D2F8FC4AD7DAA3881CF389C4F6DA6AE5C559F6A4E02B503F3BA1065
       
    ArcGIS Server ArcGIS-1061-S-FGSP-Patch.msp
         Checksum
         (SHA256)
    FFCDB67A874533FB3E8E47DD76AAF07F53B57E5D9F5C7ED9E4BC971CD1774912
       

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

  4. Double-click ArcGIS-<Version>-<Product>-FGSP-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-<Version>-<Product>-FGSP-Patch.msp


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.

The ArcGIS product listed in the table must be installed on your system before you can install a patch. Each patch setup is specific to the ArcGIS product in the list. To determine which products are installed on your system, please see the How to identify which ArcGIS products are installed section. Esri recommends that you install the patch for each product that is on your system.

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


    ArcGIS 10.7.1  
       
    ArcGIS Server ArcGIS-1071-S-FGSP-Patch-linux.tar
         Checksum
         (SHA256)
    B3B74A60C221EA5BA657B8C290AC7F4264A3C32D6D970999AA7D01DC78145C6D
       
    ArcGIS 10.6.1  
       
    ArcGIS Server ArcGIS-1061-S-FGSP-Patch-linux.tar
         Checksum
         (SHA256)
    5ACFB0959BE95A12F661F334D263746CBEC14824B008A544F0308117EE77B3C1
       

  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-<Version>-S-FGSP-Patch-linux.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.


Upgrade a geodatabase

When a hotfix or patch for ArcGIS has been applied, it may also be necessary to upgrade your geodatabase. See the Upgrade the Geodatabase section on the Geodatabase management page for your individual DBMS platform for more information.


Uninstalling this patch on Windows


    To uninstall this patch on Windows, open the Windows Control Panel and navigate to installed programs. Make sure that "View installed updates" (upper left side of the Programs and Features dialog) is active. Select the patch name from the programs list and click Uninstall to remove the patch.

Uninstalling this patch on Linux


    To remove this patch on versions 10.7 and higher, navigate to the <Product Installation Directory>/.Setup/qfe directory and run the following script as the ArcGIS Install owner:


    ./removepatch.sh

    The removepatch.sh script allows you to uninstall previously installed patches or hot fixes. Use the -s status flag to get the list of installed patches or hot fixes ordered by date. Use the -q flag to remove patches or hot fixes in reverse chronological order by date they were installed. Type removepatch -h for usage help.

    Restart your ArcGIS services

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.

December 3, 2021 The windows setup(s) of this patch have been updated with new digital signatures. This change addresses the possible install error:

A required certificate is not within its validity period when verifying against the current system clock or the timestamp in the signed file.

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.