Skip to Content

Patches and updates

ArcGIS (Desktop, Engine, Server) SQL Server Compress Patch

Published: October 18, 2017

Summary

This is a general cumulative maintenance patch for ArcGIS 10.5 and 10.5.1 clients connecting to SQL Server geodatabases.

Description

EsriĀ® announces the ArcGIS (Desktop, Engine, Server) SQL Server Compress Patch. This patch for ArcGIS 10.5 and 10.5.1 addresses compress and other issues that may occur when connecting to SQL Server geodatabases and working with geometry elements created with advanced editing or parcel editor tools such as circular arcs and Bezier curves, PointIDs, Multipatch features and Surface patches from ArcGIS Spatial Analyst. It deals specifically with the issue listed below under Issues Addressed with this patch.

 

Issues Addressed with this patch

 

  • BUG-000108546 - Curve feature converted to densified line segment from arc in SQL Server Geodatabase after geodatabase compress.
  • BUG-000106321 - Enabling archiving on SQLServer feature classes created prior to 10.5 causes "Attribute Column Not Found" error when saving edits.

To avoid conflicts the ArcGIS 10.5.1 version also includes:

  • BUG-000107499 - Spatial indexes are deleted in ArcMap while executing the Append tool as a sysadmin.
  • BUG-000107267 - Permissions granted at the schema level are not honored when permissions are cached during connection to SQL Server.
  • BUG-000106595 - ArcGIS Pro 2.0 and 10.5.1 Desktop require explicit object level select privileges for users to view SQL Server geodatabase data in the Catalog tree.
  • BUG-000106582 - Database Connection Fails to a Field Case Sensitive Database in ArcMap.
  • BUG-000105319 - Selecting over 10,000 features and opening attribute table for registered database view returns a warning message, "There was an error reading the table selection. Clear selection to correct. ODBC Driver Manager Invalid cursor state."
  • BUG-000104745 - The Register with Geodatabase tool fails in a database view if it contains null geometry.
  • BUG-000104225 - The session-based log file causes the reconciliation to hang with one particular SQL Server geodatabase.

To avoid conflicts the ArcGIS 10.5 version also includes:

  • NIM079029 - Improve display performance of 3rd party spatial types such as PostgreSQL PG_Geometry and SQL Server Geometry.

 

Installing this patch on Windows

 

Installation Steps:

 

ArcGIS 10.5 or 10.5.1 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.
    ArcGIS 10.5.1   Checksum (Md5)
         
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-1051-BGDT-SSC-Patch.msp 939815B9028F56D86817DD0BB870A1A4
         
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-1051-BGE-SSC-Patch.msp BDD31354C2C159A6B99A93523E9961AF
         
    ArcGIS Desktop ArcGIS-1051-DT-SSC-Patch.msp 0D67C9C39D3493E0C991FA1EE2982DA5
         
    ArcGIS Engine ArcGIS-1051-E-SSC-Patch.msp 5BE17E7C9FFE62A77142B24CEF50377A
         
    ArcGIS Server ArcGIS-1051-S-SSC-Patch.msp D76970E6209AF5BC79B68FBAF6C129BD
         
    ArcGIS 10.5   Checksum (Md5)
         
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-105-BGDT-SSC-Patch.msp D88410A71383BB8B7D901226366D4048
         
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-105-BGE-SSC-Patch.msp 6B8E2ED7320EDE04F08D51FE6CE2C7BE
         
    ArcGIS Desktop ArcGIS-105-DT-SSC-Patch.msp 4F7EB3987A15582C8DEACE452F3D3071
         
    ArcGIS Engine ArcGIS-105-E-SSC-Patch.msp 100B0E81E8E92F3CF0F2C8DF33F0EAB7
         
    ArcGIS Server ArcGIS-105-S-SSC-Patch.msp B159715DE4D9F750623B962FB351A9D3
         
  2. Make sure you have write access to your ArcGIS installation location.
  3. Double-click ArcGIS-<Version>-<Product>-SSC-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>-SSC-Patch.msp

 

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

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options