Patches and updates
ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch
Summary
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
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
st_domain_methods.stb
st_domain_methods_10g.stb
CadastralFabric.dll
gsrvrpg101.dll
gsrvrmssql101.dll
gsrvrora11g101.dll
gsrvrora10g101.dll
gsrvrpg101.dll
gsrvrsql101.dll
libcadastralfabric.so
libsdefdb.so
SdeFDB.dll
sdepgsrvr101.dll
st_domain_methods.stb
st_domain_methods_10g.stb
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:
- Preparing to upgrade a geodatabase in Oracle
- Preparing to upgrade a geodatabase in PostgreSQL (If you use the PostGIS geometry type in PostgreSQL, also see Esri technical article 40553 for information on supported versions.)
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.
- 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 - Make sure you have write access to your ArcGIS installation location.
- ArcGIS for Server only: Open the Services Management Console> Control Panel > Administrative Tools > Services. Stop the ArcGIS Server service.
- 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
- 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:
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:
- Preparing to upgrade a geodatabase in Oracle
- Preparing to upgrade a geodatabase in PostgreSQL (If you use the PostGIS geometry type in PostgreSQL, also see Esri technical article 40553 for information on supported versions.)
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.
- 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 - Make sure you have write access to your ArcGIS installation location, and that no one is using ArcGIS.
- ArcGIS for Server only: stop the ArcGIS server service by typing:
% arcgis/server/stopserver.sh
- Extract the specified tar file by typing:
% tar -xvf ArcGIS-101SP1-<Product>-PPEP-Patch-<Platform>.tar
- 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.
- 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
Download the Esri Support App