ArcGIS 10.2.1 for (Desktop, Engine, Server) Utilities and Telecom Update 5 Patch

• BUG-000091718 - Improve selectivity and performance of DB_table_list_tables queries.
• BUG-000091460 - Add code to Sql Server to support insert + delete + sync case.
• BUG-000091247 - 'Underlying DBMS error ORA-01008: Not all variables bound' error observed while using Select By Attribute on a Non-Versioned Archiving enabled feature class.
• BUG-000091883 - Syncing in some cases where inserts are applied as updates causes incorrect / duplicate globalids to be set.
• BUG-000091688 - Need to add brackets to the whereclause in sqlFilter for reduction rules to have the correct filter and avoid processing filters when no features of the feature class are selected.
• BUG-000091464 - Syncing a 1 way replica fails when the child has a GN and inconsistent connectivity.
• BUG-000090884 - Errors related to the GDB_TEMP_USER_IDS table, created as an optimization to the Geometric Network Rebuild/Repair operations need to be suppressed.
• BUG-000089740 - The error, "Network I/O error [SDE.DEFAULT]", is returned when opening a MXD file after applying the Utility Update Patch 2 (UTUP2) with default connection set up via an add-in extension.
• BUG-000089580 - Slow performance for the Synchronize Changes gp tool (via Python as well) comparing to the Synchronize Changes Wizard from GUI.
• BUG-000089100 - Synchronizing one particular replica fails with the following error, "synchronize replica failed".
• BUG-000088300 - Enabling schema cache on a SQL server SDE workspace crashes ArcMap.
• BUG-000087750 - Squares appear in the annotation in an exported PDF if Unicode symbols are used with Arial font.
• BUG-000087594 - Service start up time increases the more feature classes exist in an Oracle database and the service is serving data from the Oracle database in ArcGIS 10.3 for Server.
• BUG-000087277 - An annotation feature class fails to update correctly if the feature class is joined to a table or another feature class.
• BUG-000084769 - The initial and full extent information of the feature service endpoint differs from the map service endpoint in a multi-machine site.
• BUG-000083703 - When exporting data changes for a replica from a disconnected editing session, all the changes from the related tables are not exported to the delta geodatabase.
• NIM103075 - Inefficient spatial query encountered when using the Annotate Selected. Features command on versioned SDO_GEOMETRY, ST_Geometry and Sql Server Geometry feature classes.
• NIM101171 - ArcCatalog crashes, when the Identity tool is used on a Web Map Service (WMS) in ArcCatalog preview.
• NIM100525 - Identifying a specific Web Map Service (WMS) causes ArcMap to crash.
• NIM097058 - The 'Simplification Tolerance' option disappears from the Simplify Line and Simplify Polygon geoprocessing tools after installing Internet Explorer (IE) 11.
• NIM084109 - Deleting a feature class from a large SDE/Oracle database (contains more than 3000 feature classes) causes one SQL query being executed and fetched thousands of times which leads to a slow performance issue.

• BUG-000090940 - Performances of generating/updating diagrams with rules contain SQL filters are still bad.
• BUG-000088754 - The state_id values are corrupt after exporting a geodatabase from an Oracle cluster to a single instance.
• BUG-000088668 - Dataset Editor - The query which retrieves the field related to a Field attribute fails when the name for the diagram template and its table doesn't match.
• BUG-000088666 - Some diagrams built within pre-10x version fail to migrate into a 10.x Enterprise geodatabase.
• BUG-000088350 - ST_Aggr_Union returns the incorrect results when many sliver polygons are present.
• BUG-000088244 - Optimize the deletion of objects from the geodatabases internal metadata.
• BUG-000088109 - The ST_difference function returns empty output with specific input feature classes.
• BUG-000088081 - Objects are distorted after rotating with the Utilities and Telecom Update 2 Patch (UTUP2).
• BUG-000086358 - An error, "ORA-22829" is returned when trying to migrate from SDEBinary to SDELOB on a particular dataset using the Migrate Storage tool.
• BUG-000086328 - Performing a transformation on a feature class in an Oracle database using the ST_Transform is producing a transform error: ORA-20603: Spatial References are not compatible.
• BUG-000086255 - ArcGIS for Server is unable to connect to SQL Server mirrored database during a failover.
• BUG-000086160 - Requests made in parallel to add or delete feature classes are causing deadlocks to the gdb_tables_last_modified table.
• BUG-000083633 - The order of layers in the Table Of Contents in ArcMap affects the rendering or drawing time for some layers.
• NIM103145 - Some polygons are dropped from a specific multi-polygon feature class when using the ST_TRANSFORM function.
• NIM102626 - The performance of the Trace Geometric Network geoprocessing tool is slow compared to the Utility Network Analyst toolbar when a geometric network is stored in an ArcSDE geodatabase.
• NIM102491 - When a polygon-on-polygon overlay fails with an internal resolution error, we should try it again with maximum resolution.
• NIM084109 - Deleting a feature class from a large SDE/Oracle database (contains more than 3000 feature classes) causes one SQL query being executed and fetched thousands of times which leads to a slow performance issue.
• NIM082508 - Data Pump export (expdp) of a partitioned table with a local index fails with ORA-39127.

This patch includes all fixes in the ArcGIS 10.2.1 for (Desktop, Engine, Server) Utilities and Telecom Update 3 Patch.

• BUG-000086943 - The Verify, Repair and Rebuild Connectivity Tools need to identify and fix the max EID corruption problems.
• BUG-000086941 - Support read only geodatabases in Oracle.
• BUG-000086192 - Loading data into a Geometric network Feature Class using arcpy.Append_management in Python can result in corrupted network features.
• BUG-000086160 - Requests made in parallel to add or delete feature classes are causing deadlocks to the gdb_tables_last_modified table.
• BUG-000085669 - When creating a new version during an edit session, stopping the edit session in the base version without saving the edits may corrupt the geometric network in the newly created version.
• BUG-000085184 - Splitting a complex edge causes related objects to be unrelated.
• BUG-000085006 - ArcCatalog 10.3 crashes when compressing with a specific ArcSDE geodatabase.
• BUG-000084498 - ArcGIS Desktop crashes when posting versioned edits to default with the features registered as versioned with options to move edits to base.
• BUG-000083139 - Change version dialog is extremely slow to open.
• BUG-000082420 - Calling ISimpleJunction.EdgeFeatureCount within a loop against data in sde yields a "Out of Server Memory" error.
• NIM104524 - Performance degradation is observed with the 'Select by Location' tool when using ArcGIS 10.0 SP5 and above against enterprise geodatabases.
• NIM102561 - The IFeatureEdit2.SplitWithUpdate method does not call IFeatureClassEdit.CustomSplitPolicy on a complex edge feature class extension.
• NIM101805 - Do not allow the registering of views with the geodatabase.
• NIM101236 - When viewing a non-versioned, archived SQL Server feature class with more than 123 columns, the following error message is received: "Error opening feature class. Out of server memory."
• NIM100811 - Slow performance using the Feature Class to Feature Class geoprocessing tool to load data into a SQL Server geodatabase.
• NIM099678 - The Identify tool fails to identify SDEBINARY features when a join exists from a feature class to a table using the same connection.
• NIM096843 - Redundant execution of queries - per execution of spatial query on ST_GEOMETRY FC.
• NIM096793 - Records can be left in the Geometry CAD side table when compressing updated features to the base table.
• NIM094902 - The ST_Intersection fails with the error "ORA-28579" when dealing with certain multipart line features.
• NIM094237 - Records can be left in the Geometry CAD side table when updating features and saving edits to base.
• NIM088143 - Joining a versioned feature class to a table not registered with the geodatabase causes ArcMap to crash.
• NIM085757 - The trace weight field is not preserved on new feature classes added to an existing Geometric Network.

This patch includes all fixes in the ArcGIS 10.2.1 for (Desktop, Engine, Server) Utilities and Telecom Update 2 Patch.

• BUG-000081231 - After disconnecting and connecting linear source features from a geometric network and updating the associated schematic diagram, a new schematic ID is generated for that feature and the vertices are removed.
• BUG-000082028 - Standard editing workflows consume increasing amounts of memory and do not release it after editing has stopped.
• BUG-000082630 - Versioned Difference Cursor single branch edits invert the "type" of change reported (e.g., Deletes become Inserts, Inserts become Deletes).
• NIM088321 - User defined spatial index grids are not honored by ArcGIS when using the Add Spatial Index tool, even though the tool runs successfully.
• NIM096460 - After dropping and rebuilding the geometric network and updating a schematic diagram containing schematic rules, network junction locations are not preserved.
• NIM097184 - Creating a checkout in a 9.3.1 geodatabase fails with 10.2.1 Desktop.
• NIM097983 - Optimize the opening of map documents by augmenting the geodatabase schema cache to include properties of the sde metadata.
• NIM098475 - Spatial indexes are not created when creating a feature class on an ArcSDE 10 database from an ArcGIS Desktop 10.2 client.
• NIM098196 - Exporting SDE schema using Oracle expdp generates ora-39127, ora-20098 and ora-06512 error about the spatial index created on GDB_items table having the st_grids parameter as commas when Oracle 11gR2 is used.
• NIM098665 - Making a connection to a non-spatial Oracle database using either a Spatial Database Connection or an OLE Database Connection takes a significantly long time when there is a large amount of objects in the database.
• NIM099484 - Provide a mechanism to enable instrumentation of memory usage when creating a feature cache in desktop.
• NIM096111 - Rotating a point after a specific selection workflow on a geometric network rotates and shifts the entire geometric network.
• NIM100182 - Bad SCHEMATICTID when diagrams get exported. Schematic features associated with GIS features which are not part of the geometric network are exported with "-2" at the end of their SCHEMATICTID.
• NIM100823 - Rebuild the spatial index on a versioned feature class fails with an SRID mismatch error.
• NIM100941 - Improve the Performance and Scalability of Creating and Syncing replicas by more efficiently caching database information.
• NIM101461 - When feature classes with different SRIDs are used in an ST_intersection query, it fails with 'ORA-06530: Reference to uninitialized composite'.
• NIM101468 - Unable to hide standalone tables using the IWorkspaceExtension.DataDictionaryTableNames method in ArcGIS 10.1 and above.
• NIM101270 - Recalculating the feature extent on specific datasets returns the following error: "Failed to recalculate extent. The specified coordinate exceeds the valid coordinate range."
• NIM101376 - ArcGIS for Desktop fails to save the connectivity rules for a specific geometric network.
• NIM101746 - The Alter Field online help documentation page indicates that the Alter Field tool is available at all license levels; however, the tool is unavailable at lower license levels.
• NIM102077 - ArcGIS reports that an Oracle SDELOB or WKB feature class created in a pre-10.1 geodatabase does not have a spatial index when it does exist.
• NIM102230 - Do not return the Documentation field on joined queries for Geodatabase internal metadata.
• NIM102846 - When exporting diagrams into another schematic dataset using the Export Schematic Dataset process configured with GUIDs reattachment, the process expects GUIDs for each feature they contain. This is blocking when GUIDs are only missing for a feature class, in particular when this is missing for _Junctions.
• NIM102848 - Creating a spatial index will pass values gathered from existing enterprise feature classes that may be invalid instead of passing correct values.
• NIM102883 - When using a newer client (10.1+) against an older SQL server geodatabase (pre-10.1) through an application server connection, creation of a spatial index will fail on GEOMETRY or GEOGRAPHY feature classes with 'This SDE server does not support this client or operation'.
• NIM102895 - Data exported via a XML workspace does not retain any 4-byte (or greater) characters in the data's attribute table.
• NIM102996 - After dropping a spatial index on a binary feature class through an application server connection to a pre-10.1 geodatabase in SQL Server, ArcGIS is unable to determine the index is gone.
• NIM103593 - File Geodatabase lock files should be opened as Read, rather than as Read/Write. This improves feature class/table creation performance.
• NIM103683 - When script/query/constant attributes are configured on a schematic feature class for which the schematic features are not initialized, the attributes are not updated.
• NIM103708 - Filter the AUDSYS, OJVMSYS, GSMADMIN_INTERNAL, DVSYS Oracle objects from connection in ArcGIS.
• NIM103781 - The network index DESC query must only fetch the necessary attributes and not SELECT * when obtaining the USERID or ELEMENT mappings.
• NIM104247 - Implement two new API functions for se_enable_schema_chache and se_disable_schema_cache.
• NIM104317 - When fetching a network dataset index page, only fetch the pageblob.
• NIM104321 - MDXT_xxx$% tables show up in ArcCatalog, connected to a 11.2.0.4 or 12.1.0.1 instance, and some are not deleted even when the feature class is deleted.

This patch includes all fixes in the ArcGIS 10.2.1 for (Desktop, Engine, Server) Utilities and Telecom Update 1 Patch.

• NIM086295- On Oracle ST_OrderingEquals is always returning the same value as ST_Equals.
• NIM088921 - Importing an SDE schema dump fails with ORA-39083 and ORA-02309 on SDE.st_type_export.validate_spref using datapump impdp.
• NIM089510 - Inconsistent results with st_astext_f query on polygons with more than 292 vertices.
• NIM090071 - Labeling features based on join table's field throws 'ArcMap drawing errors' when the table and feature class are stored in different DBMS.
• NIM094291 - The extent of data created in MicroStation DGN files is not correctly calculated in ArcMap 10.2 which causes the data to be displayed in the wrong location.
• NIM094556 - Results from the Trace Geometric Network geoprocessing tool to trace connected are not consistent with the trace results from the Find Connected tool in the Utility Network Analyst toolbar.
• NIM095455 - In an edit session, snapping stops working on a layer if a join exists on that layer.
• NIM096135 - Provide option to create user schema geodatabases by a user other than SYS.
• NIM096817 - Loading a large amount of coordinates via ST_Geometry function results in ORA-20004 and ORA-20000 errors.
• NIM097346 - Extproc not initialized when a ST_Intersects query involving a versioned view and a base table is the first query run in the session.
• NIM099098 - ST_ASTEXT Function is failing when the result set contains more than one record, and when the NUMPOINTS is ~2000 (or more).
• NIM099383 - Do not grant all privileges on user keyset tables when created.
• NIM099484 - Provide a mechanism to enable instrumentation of memory usage when creating a feature cache in desktop.
• NIM099485 - Attempting to build a feature cache fails without an error message and does not release consumed memory.
• NIM099500 - Reconciling a particular user version returns the following error: "Invalid network element ID."
• NIM099513 - Correctly release memory when a feature cache is cancelled on the workspace.
• NIM099517- Add a model dialog to the build feature cache command which allows a user to cancel the operation.
• NIM099519 - Do not cache layers in the feature cache when the scale range of the layer is greater than the maps extent.
• NIM099883 - The strings "Building map feature cache" is not localizable in the feature cache tool.
• NIM100028 - A significant amount of CPU power is used by an ArcMap 10.2.1 edit session when there are many layers in the map document.
• NIM100141 - Missing index on the SDE versions table results in full table scan.
• NIM100503 - Loading a very large shape (>15k points) followed by small shape results in ORA-28579: error.
• NIM100941 - Improve the Performance and Scalability of Creating and Syncing replicas by more efficiently caching database information.
• NIM100942 - Deadlocks can happen on SQL server when multiple processes are creating and syncing replicas.
• NIM101280 - Provide additional status information during a compress operation in the compress_log.
• NIM101468 - Unable to hide standalone tables using the IWorkspaceExtension.DataDictionaryTableNames method in ArcGIS 10.1 and above.
• NIM101804 - Do not return feature datasets in which the connecting user has no access to feature classes within.
• NIM101806 - Provide a mechanism to log what release a client is using when connecting to a geodatabase.
• NIM102265 - An annotation layer loaded from the Add Historical Archive button displays polygons instead of text.

System Administrators: A technical paper is available that discusses the enterprise deployment of ArcGIS 10.2.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.2.1 Enterprise Deployment.

ArcGIS 10.2.1 for 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.
   

   		Checksum (Md5)
   ArcGIS Desktop	ArcGIS-1021-DT-UTU5-Patch.msp	FB5AE71C0F8A4A09E2D3F9BAE87C03FE
   ArcGIS Desktop Arabic Language Pack	ArcGIS-1021-DT-UTU5-Patch-AR.exe	8F5190BE7D24F3B272A7DA20B226E0F5
   ArcGIS Desktop Background Geoprocessing (64-bit)	ArcGIS-1021-BGDT-UTU5-Patch.msp	42FA5DF794156BC8FF5F93B514A83E73
   ArcGIS Engine	ArcGIS-1021-E-UTU5-Patch.msp	28B1CE2EB877888D484DAB4BB7ECE120
   ArcGIS Engine Background Geoprocessing (64-bit)	ArcGIS-1021-BGE-UTU5-Patch.msp	4C29A232DA7F714EB3185C67452DC462
   ArcGIS for Server	ArcGIS-1021-S-UTU5-Patch.msp	44CBFDC55FDC9C334BD7CAA14F083327

   
   
2. Make sure you have write access to your ArcGIS installation location.
3. Double-click ArcGIS-1021-<product>-UTU5-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-1021-<product>-UTU5-Patch.msp
   
4. After the installation procedure has finished, complete the Upgrade a geodatabase section.

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

ArcGIS 10.2.1 for Engine or Server must be installed before installing this patch.

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

   		Checksum (Md5)
   ArcGIS Engine	ArcGIS-1021-E-UTU5-Patch-lx.tar	4907DD4C5F9F54572A2F7E5CD79BE1F4
   ArcGIS for Server	ArcGIS-1021-S-UTU5-Patch-lx.tar	E428D967D9FA857A3E139E2766DF1A61

   
   
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-1021-<product>-UTU5-Patch-lx.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.
5. After the installation procedure has finished, complete the Upgrade a geodatabase section.

A geodatabase upgrade is required after applying this patch. To upgrade the geodatabase, follow the instructions in the help section specific to your database management system:

SQL Server

PostgreSQL

Oracle

Informix

DB2

Check the Patches and Service Packs page periodically for the availability of additional patches. New information about this patch will be posted here.

To determine if the product(s) for this ArcGIS patch are installed, choose the appropriate operating system version of the PatchFinder utility for your environment and run it from your local machine. PatchFinder will list all core ArcGIS products, hot fixes, and patches installed on your local machine.

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.