English

ArcGIS Server Date Fields Performance Improvement Patch

Summary

This patch improves performance while accessing date fields through feature services or map services when a time zone is set. A memory leak when accessing attachments on feature services is also resolved.

Description

Esri® announces the ArcGIS Server Date Fields Performance Improvement Patch. This patch improves performance while accessing date fields through feature services or map services when a time zone is set. A memory leak when accessing attachments on feature services is also resolved. This patch deals specifically with the issues listed below under Issues Addressed with this patch.


Issues Addressed with this patch


  • BUG-000138264 - Accessing feature attachments in an ArcGIS Server service sourced from an enterprise geodatabase, spikes the CPU and memory utilization for the associated ArcSOC.exe processes.
  • BUG-000130979 - Poor performance of the ArcGIS Server feature service with user managed data from enterprise geodatabase, with the 'Date Field Settings' time zone and 'Value are adjusted for daylight savings' options enabled.
To avoid conflicts on 10.8.1 this patch also addresses:
  • BUG-000137346 - Crash occurs when reconcile is executed while the intermediate table is not registered as versioned.
  • BUG-000137139 - Optimize UpdateAssociationInfo function by splitting the query to discover from/toglobalid associations
  • BUG-000136979 - Validate Network Topology incorrectly allocating large amounts of memory impacting server soc mem usage
  • BUG-000136930 - In a branch versioned service, sourcing from a PostgreSQL database, any interruption to the connection results into underlying DBMS error until service is restarted.
  • BUG-000136892 - When a -1 is returned to ArcGIS Pro the conflict resolution dialog is unable to properly present the conflicts
  • BUG-000136889 - After upgrading Enterprise Geodatabase 10.7.1 to 10.8.1 and running the query to get Next_RowID, the following error message is returned: Msg 8144, Level 16, State 2, Procedure DBO.i13_get_ids, Line 0 [Batch Start Line 0] Procedure or function i13_get_ids has too many arguments specified.
  • BUG-000136296 - Long running reconciles may block users from editing Default or reconciling other versions with Branch Versioning.
  • BUG-000136284 - Editing data which are registered as multibranch causes lock escalation and blocking scenarios in the geodatabases in the SQL Server.
  • BUG-000136107 - The Update Subnetwork tool fails and returns the error message, "ERROR 001400: The server took too long to answer. The client has timed out. (status code 28). Failed to execute (UpdateSubnetwork)."
  • BUG-000135328 - Reconcile fails on a branch version and returns the error message, "A row with this OID already exists."
  • BUG-000135117 - Updating the subnetwork on a geographic coordinate system (GCS) spatial reference utility network fails the second time for short lines.
  • BUG-000134954 - Reconciling multiple versions in the utility network using the Reconcile Versions tool crashes the ArcSOC.exe instance.
  • BUG-000134950 - Crash occurs when reconcile is executed while a related destination table was not registered as versioned
  • BUG-000134496 - Using the 'Reconcile Versions' tool and leaving the 'Abort if conflicts detected' parameter unchecked, the session is still aborting the reconcile.
  • BUG-000133698 - Enabling the topology with the 'Only generate errors' option does not clean the dirty areas of the error.
  • BUG-000132887 - The electric subnet lines and electric lines do not overlap when the UN is in a GCS of 'GDA2020'.
  • BUG-000130888 - The Register with Geodatabase tool fails when registering an empty feature class
To avoid conflicts on 10.7.1 this patch also addresses:
    There are no additional issues addressed for 10.7.1

Installing this patch on Windows


Installation Steps:


This patch should be installed on all ArcGIS Server installations related to the ArcGIS Server site.

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.8.1  
       
         ArcGIS Server ArcGIS-1081-S-DFPI-Patch.msp
         Checksum
         (SHA256)
    F6EFDFDC923C5D3DEADF9ABD486CAC4ADC544F97C0936B94FEE329CFAC28BAEA
       
    ArcGIS 10.7.1  
       
         ArcGIS Server ArcGIS-1071-S-DFPI-Patch.msp
         Checksum
         (SHA256)
    6A6A67943C795F0F7150A6E1935B6358942CD66B757BCFC2A2D63D3870F99C44
       

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

  4. Double-click ArcGIS-<Version>-S-DFPI-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>-S-DFPI-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. This patch should be installed on all ArcGIS Server installations related to the ArcGIS Server site.

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.8.1  
       
         ArcGIS Server ArcGIS-1081-S-DFPI-Patch-linux.tar
         Checksum
         (SHA256)
    C4E13654F617C2EE3F9496BCA953091CCAD6D6F0DE33FC4D04C54DE515113162
       
    ArcGIS 10.7.1  
       
         ArcGIS Server ArcGIS-1071-S-DFPI-Patch-linux.tar
         Checksum
         (SHA256)
    B4BE6BAAEB9D7BE405FF49C6AB267D5495DC70DD58C261726A6D0709D80AB935
       

  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-DFPI-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 <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.

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.