English
Continue in the app

ArcGIS Server 10.9 SQL Server Branch Versioning Patch

Summary

This patch resolves potential performance and blocking issues that may occur with branch versioned data stored in SQL Server geodatabases.

Description

Esri® announces the ArcGIS Server 10.9 SQL Server Branch Versioning Patch. If you are using ArcGIS Server 10.9 and working with branch versioned data stored on SQL Server, this patch resolves issues related to performance and blocking that may occur. It deals specifically with the issues listed below under Issues Addressed with this patch.


Issues Addressed with this patch


  • BUG-000140539 - STIntersects() queries do not use the spatial index
  • BUG-000140449 - Connections blocked by exclusive table lock on sde_process_information.
  • BUG-000140030 - Improve performance for branch query with UUID log file table join.
  • BUG-000140013 - Dead lock can be encountered when multiple connections hold exclusive locks on the sde_process_information and sde_table_locks tables.
  • BUG-000139968 - Upgrade can create incorrect conditional index on GDB_Locks table.

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.9  
       
    ArcGIS Server ArcGIS-109-S-SSBV-Patch.msp
         Checksum
         (SHA256)
    CF00F67DBEFA91EBD37524CD571FDBEAF1B15C01DB29DF906F31442E749DA7FA
       

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

  4. Double-click ArcGIS-109-S-SSBV-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-109-S-SSBV-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.9  
       
    ArcGIS Server ArcGIS-109-S-SSBV-Patch-linux.tar
         Checksum
         (SHA256)
    EC6E7F3B47747E84C19BF2D4D8621C4297E51DCB70A7E6D0A8509C410BAB5B9E
       

  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-109-S-SSBV-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.

Tip: Upgrade your Enterprise geodatabases stored in Microsoft SQL Server to take advantage of critical fixes to branch versioning.

Upgrading from ArcGIS Server requires the use of Python. If you are working with ArcGIS Server on Windows or Linux, you can access the appropriate Python 3 environment by using the python.exe which is included with the framework/runtime components of ArcGIS Server. Additionally, on Windows a script batch file is available to launch the Python 3 environment.

To perform the upgrade, create a script using this example Python syntax, and name the script upgrade_gdb.py.

import arcpy
Connection_File_Name_full_path="C:\\temp\\sysadmin_connection.sde"
arcpy.UpgradeGDB_management(Connection_File_Name_full_path, "PREREQUISITE_CHECK", "UPGRADE")


Additional documentation on how to Upgrade an enterprise geodatabase in SQL Server is available from this help topic: Upgrade an enterprise geodatabase in SQL Server

On Windows, run the upgrade script explicitly using the Python 3 environment. If ArcGIS Server is installed to the default location, the script can be executed with either of the following commands:

"C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\bin\Python\scripts\propy.bat" C:\temp\upgrade_gdb.py
Or
"C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\bin\Python\envs\arcgispro-py3\python.exe" C:\temp\upgrade_gdb.py



On Linux, launch the Python 3 environment using the following commands:

source /<arcgis_server_installation_directory>/arcgis/server/framework/etc/arcenv
unset LD_PRELOAD
unset CONDA_DEFAULT_ENV


And then execute the upgrade script with the following command:

wine "Z:\<arcgis_server_installation_directory>\arcgis\server\framework\runtime\ArcGIS\bin\Python\envs\arcgispro-py3\python.exe" <path_To>\upgrade_gdb.py



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.

November 19, 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.