Patches and updates

ArcGIS (Desktop, Engine, Server) 10.7.1 Azure SQL Database Collations General Patch

Published: April 30, 2020

Summary

If you are using ArcGIS 10.7.1 and enabling enterprise geodatabases in the Azure SQL Database environment, this patch resolves a limitation that prevented use of non-default collations.

Description

Esri® announces the ArcGIS (Desktop, Engine, Server) 10.7.1 Azure SQL Database Collations General Patch. If you are using ArcGIS 10.7.1 and enabling enterprise geodatabases in the Azure SQL Database environment, this patch resolves a limitation that prevented use of non-default collations. This patch deals specifically with the issue listed below under Issues Addressed with this patch.

 

Issues Addressed with this patch


  • BUG-000129828 - Enabling an Azure SQL Database with Hebrew_CI_AS Collation as an enterprise geodatabase in ArcGIS Pro and ArcMap fails with ERROR: Cannot resolve the collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

 

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.

    ArcGIS 10.7.1   Checksum (Md5)
         
    ArcGIS Desktop
    Background Geoprocessing (64-bit)     		ArcGIS-1071-BGDT-ASDCG-Patch.msp E5E3489E8BFAEFCDA898DA5C985B0D71
         
    ArcGIS Engine
    Background Geoprocessing (64-bit)     		ArcGIS-1071-BGE-ASDCG-Patch.msp C6B055371DB7C609A878A8BC81B8EBC7
         
    ArcGIS Desktop ArcGIS-1071-DT-ASDCG-Patch.msp C3E7A312AF3381E7104386D7F758C588
         
    ArcGIS Engine ArcGIS-1071-E-ASDCG-Patch.msp 8AA824197675FBDF77A6134BB4F0B50A
         
    ArcGIS Server ArcGIS-1071-S-ASDCG-Patch.msp C6717DDF0FF4E2301446626C4DDEA5CC
         

  2. Make sure you have write access to your ArcGIS installation location.
  3. Double-click ArcGIS-1071-<Product>-ASDCG-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-1071-<Product>-ASDCG-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   Checksum (Md5)
         
    ArcGIS Server ArcGIS-1071-S-ASDCG-Patch-linux.tar 18358135916957F1EE0F8F24E7807B42
         

  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-1071-S-ASDCG-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.

 

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 /tmp 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.

 

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:7798

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options