Patches and updates

ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch

Published: January 11, 2013

Summary

This patch addresses general performance issues when editing Parcel Fabrics, specifically when creating new parcels. This patch also includes general performance improvements when using a PostgreSQL Geodatabase.

Description

EsriĀ® announces the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch. This patch addresses general performance issues when editing Parcel Fabrics, specifically when creating new parcels. This patch also includes general performance improvements when using a PostgreSQL Geodatabase. It deals specifically with the issues listed below under Issues Addressed with this Patch.

Issues Addressed with this Patch

  • NIM083241 - PostgreSQL: Performance is affected when querying a feature class with more than 25 columns.
  • NIM084235 - St_Geometry spatial indexes are not creating S###$_IX2 indexes on the IOT SP_ID column.
  • NIM084822 - Compress not trimming internal states or compressing to the base table.
  • NIM085207 - Using the Parcel Editor, construction creates overlapping parcels.
  • NIM085493 - Parcel StatedArea field is not calculated when the parcel misclose is greater than 1:5000.
  • NIM085737 - Using the Parcel Editor, deleting a parcel deletes points of neighboring active parcels on Oracle and PostgreSQL geodatabases.
  • NIM086450 - Realm (Editor Tracking) needs to be cached to prevent repeated queries to the geodatabase about this info.
  • NIM086456 - PostgreSQL: Optimize queries in detecting primary key indexes when working with PostgreSQL geodatabases.
  • NIM086457 - PostgreSQL: Modify the initialization parameter "cursor_tuple_fraction" to 1 when working with PostgreSQL geodatabases.
  • NIM086458 - PostgreSQL: Remove the logic that creates and releases savepoints on a cursor.
  • NIM086463 - Build parcels fails when a parcel has curves with exit tangent bearing that is similar to an adjacent line.
  • NIM086474 - Parcel Editing Performance: Do not redraw map display after certain steps using the Parcel Workflows.
  • NIM086717 - SQL Server SDE Binary Only: ArcCatalog or ArcMap crashes when displaying specific ArcSDE feature classes.
  • NIM087059 - Validating a large query layer has poor performance.
  • NIM087236 - Parcel Editing Performance: Eliminate unnecessary calls to the database by caching all tables.
  • NIM087237 - Parcel Editing Performance: Cache all Parcel Fabric tables when start editing is called.
  • NIM087238 - Parcel Editing Performance: Eliminate writing unnecessary, temporary log files to the database.
  • NIM087239 - Parcel Editing Performance: Eliminate querying too much information from the Parcel Fabric Jobs table.
     

Files Installed in this Patch

Under the Windows <ArcGIS Product Installation Directory>\bin folder:

CadastralFabric.dll
CadastralUI.dll (ArcGIS for Desktop Only)
gsrvrpg101.dll
gsrvrmssql101.dll
gsrvrora11g101.dll
gsrvrsql101.dll
SdeFDB.dll
sdepgsrvr101.dll
sdemssqlsrvr101.dll
sdesqlsrvr101.dll
sdeora11gsrvr101.dll

Under the Windows <ArcGIS Product Installation Directory>\lib folder:

st_domain_methods.stb
st_domain_methods_10g.stb

Under the Linux <ArcGIS for Server Installation Directory>/bin folder:

CadastralFabric.dll
gsrvrpg101.dll
gsrvrmssql101.dll
gsrvrora11g101.dll
gsrvrora10g101.dll
gsrvrpg101.dll
gsrvrsql101.dll
libcadastralfabric.so
libsdefdb.so
SdeFDB.dll
sdepgsrvr101.dll

Under the Linux <ArcGIS for Server Installation Directory>/lib folder:

st_domain_methods.stb
st_domain_methods_10g.stb

Under the Linux <ArcGIS Engine Installation Directory>/bin folder:

CadastralFabric.rsb
libcadastralfabric.so
sdefdb.rsb
libsdefdb.so
libgsrvrora11g101.so
libgsrvrpg101.so
libsdeora11gsrvr101.so
libsdepgsrvr101.so

Installing this Patch on Windows

Installation Notes:

System Administrators: A technical paper is available that discusses the enterprise deployment of ArcGIS 10.1 setups using Microsoft Systems Management Server (SMS), System Center Configuration Manager (SCCM), and Group Policy, including additional system requirements, suggestions, known issues, and Microsoft Software Installation (MSI) command line parameters. Deployment in a lockdown environment is also covered. ArcGIS 10.1 Enterprise Deployment.

Enterprise geodatabase upgrades:

You must upgrade geodatabases in the following database management systems. Geodatabase upgrades are run from an ArcGIS client. Therefore, you must apply the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch then upgrade your geodatabase. See the topic specific to your DBMS and its related links for instructions to upgrade a geodatabase:

ST_Geometry upgrades:

If you installed the ST_Geometry type in your Oracle or PostgreSQL database, upgrade the type after you install the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch. See the topic specific to your DBMS for instructions:

Installation Steps:

ArcGIS 10.1 Service Pack 1 for Desktop, Engine, or Server must be installed before you can install this patch.

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

        Checksum
    ArcGIS for Desktop ArcGIS-101SP1-DT-PPEP-Patch.msp 13CA3E7528A3DAD9C0C336C7BDDB33C3
         
    ArcGIS Engine ArcGIS-101SP1-E-PPEP-Patch.msp 47B015286EC248BFED87300BE4004A3F
         
    ArcGIS for Server ArcGIS-101SP1-S-PPEP-Patch.msp A2FBE8199100AB7E156FFDF3813E9684

  2. Make sure you have write access to your ArcGIS installation location.
  3. ArcGIS for Server only: Open the Services Management Console> Control Panel > Administrative Tools > Services. Stop the ArcGIS Server service.
  4. Double-click ArcGIS-101SP1-<Product>-PPEP-Patch.msp to start the install process.

    NOTE: If double clicking on the MSP file does not start the Patch installation, you can start the Patch installation manually by using the following command:

    msiexec.exe /p [location of Patch]\ArcGIS-101SP1-<Product>-PPEP-Patch.msp
     
  5. ArcGIS for Server only: Open the Services Management Console> Control Panel > Administrative Tools > Services. Start the ArcGIS Server service.

Installing this Patch on Linux

Installation Notes:

Enterprise geodatabase upgrades:

You must upgrade geodatabases in the following database management systems. Geodatabase upgrades are run from an ArcGIS client. Therefore, you must apply the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch then upgrade your geodatabase. See the topic specific to your DBMS and its related links for instructions to upgrade a geodatabase:

ST_Geometry upgrades:

If you installed the ST_Geometry type in your Oracle or PostgreSQL database, upgrade the type after you install the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch. See the topic specific to your DBMS for instructions:

Installation Steps:

Complete the following install steps as the ArcGIS Install owner. The Install owner is the owner of the arcgis folder.

ArcGIS 10.1 Service Pack 1 for Engine, or Server must be installed before you can install this patch.

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

        Checksum
    ArcGIS Engine ArcGIS-101SP1-E-PPEP-Patch-lx.tar D6B69A64D46FD1C5CE409E22E57CF878
         
    ArcGIS for Server ArcGIS-101SP1-S-PPEP-Patch-lx.tar 49D3C7CBAF1CA5D0A8B40989A4FF530D

  2. Make sure you have write access to your ArcGIS installation location, and that no one is using ArcGIS.
  3. ArcGIS for Server only: stop the ArcGIS server service by typing:

    % arcgis/server/stopserver.sh
     
  4. Extract the specified tar file by typing:

    % tar -xvf ArcGIS-101SP1-<Product>-PPEP-Patch-<Platform>.tar
     
  5. Start the installation by typing:

    % ./applypatch

  6. 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.
  7. ArcGIS for Server only: start the ArcGIS Server service by typing:

    % arcgis/server/startserver.sh
     

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.

Update 02/14/2013: PostgreSQL users only; After installing this patch, geodatabase replication may stop working with PostgreSQL geodatabases. This issue is resolved by installing the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) Geodatabase Replication for PostgreSQL Patch.
 

How to identify which Patch is 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.

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

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options