laptop and a wrench

Bug

ArcGIS clients may crash when opening a map document containing layers from a SQL Server geodatabase that stores mixed precision data.

Last Published: June 8, 2016 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000095750
SubmittedApril 14, 2016
Last ModifiedMay 31, 2023
Applies toArcSDE/Enterprise Geodatabase
Version found10.3
Operating SystemWindows OS
Operating System Version7.0 64 Bit
Version Fixed1.3
StatusFixed

Description

Esri has received a number of reports from customers that ArcGIS for Desktop 10.4 and 10.4.1 (ArcMap) crashes when opening an MXD with data from a SQL Server-based enterprise geodatabase. The crashes have been reported occurring on both single and multiple database models with SQL Server 2008, 2008 R2, 2012, and 2014. This issue is data-specific to geodatabases having mixed precision data as explained below.
Note: This issue does not impact customers on other databases.

Cause

At ArcGIS 9.2, we introduced high precision coordinate storage. This feature enabled our users to 'migrate' their existing basic precision data to high precision data. When a layer was migrated, it got a new spatial reference ID, as well as storing the original spatial reference ID as a secondary reference ID, so we could work with both basic and high precision features.

As a performance enhancement, at 10.4 we introduced a schema cache where, rather than pulling metadata for individual layers when doing something like opening a map document (which slowed performance for users that had thousands of layers) . We built a cache of all layer metadata by scanning the entire sde_layers table.

The bug that is causing these crashes (BUG-000095750) is related to caching the secondary project string of the secondary reference ID.

Users who created their SQL Server geodatabase at ArcGIS 9.2 or later generally will not have mixed precision feature classes, and therefore no secondary reference ID. The exception is that it was still possible after ArcGIS 9.2  to create basic precision data by using the SDE APIs and some SDE command line tools.

Users can check to see if this issue could affect them by issuing the following query to their geodatabase:
select count (*) from sde.sde_layers
where secondary_srid is not null

Workaround

Development has released the ArcGIS 10.4.1 for (Desktop, Server) SQL Server Mixed Precision Patch to resolve this issue. We recommend that SQL Server-based customers that have verified that they have a secondary spatial reference ID apply this patch after moving to ArcGIS for Desktop 10.4.1. Download and install the patch from the following location: ArcGIS 10.4.1 for (Desktop, Server) SQL Server Mixed Precision Patch
Note: This patch is for version 10.4.1 only, and will not work with version 10.4.

Steps to Reproduce

Bug ID: BUG-000095750

Software:

  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic