Patches and updates

ArcGIS (Desktop, Engine, Server) Oracle Data Type Patch

Published: March 24, 2020

Summary

This patch addresses an issue where opening a registered class in Oracle Enterprise Geodatabases using ArcGIS 10.6.1 and newer clients incorrectly changes data type's metadata defined as a double (10, 0) to a long integer.

Description

Esri® announces the ArcGIS (Desktop, Engine, Server) Oracle Data Type Patch. This patch resolves an issue where ArcGIS 10.6.1 and newer clients will incorrectly change a data type's metadata defined as a double (10, 0) to a long integer for a registered class in an Oracle enterprise geodatabase.

If this happens the following error can be encountered [ORA-01455: converting columns overflows integer datatype] when opening the classes table in ArcMap or ArcGIS Pro and there are values in these fields which exceed the maximum long integer value of 2,147,483,647.

This issue only affects the geodatabase catalog's metadata and does not impact the field's definition on the table.

This patch deals specifically with the issues listed below under Issues Addressed with this patch.

Issues Addressed with this patch

BUG-000118138 - ArcGIS Double fields with precision = 10 and scale = 0 in an Oracle geodatabase are altered automatically to Long Integer after previewing in ArcGIS 10.6.1/ArcGIS Pro 2.2 or later clients. An error is returned, "[ORA-01455: converting columns overflows integer datatype]" if the fields contain numbers larger than the maximum for a Long Integer (2,147,483,647).

To avoid conflicts the 10.7.1 version also addresses:

BUG-000124326 - Renaming an SDO_Geometry feature class fails on Oracle 19c.
BUG-000124325 - Create Spatial Type fails on Oracle 19c.

To avoid conflicts the 10.7 version also addresses:

There are no cumulative issues for this version.

To avoid conflicts the 10.6.1 version also addresses:

BUG-000124326 - Renaming an SDO_Geometry feature class fails on Oracle 19c.
BUG-000124325 - Create Spatial Type fails on Oracle 19c.
BUG-000122703 - Related fixes for the Optimized Compress work
BUG-000121378 - Data loss in the text field (VARCHAR2) when importing data using ArcGIS Desktop 10.6.1 (HF-000004619) to Oracle geodatabase if the field characters are more than 2000 characters.
BUG-000121297 - Font smoothing in Windows 10 significantly degrades ArcMap performance.
BUG-000115147 - When calling ITopologicalOperator::Buffer on a polygon, if the polygon is degenerated to a point, the buffer call crashes.

Installing this patch on Windows

Installation Steps:

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.

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

ArcGIS 10.8		Checksum (Md5)

ArcGIS Desktop Background Geoprocessing (64-bit)	ArcGIS-108-BGDT-ODT-Patch.msp	578DD2A3FD0A3919E0FCD859AC9843B9

ArcGIS Engine Background Geoprocessing (64-bit)	ArcGIS-108-BGE-ODT-Patch.msp	127E84F2718F79D548637A0ACE9D22EF

ArcGIS Desktop	ArcGIS-108-DT-ODT-Patch.msp	16E93919CFE4F32F80F3B7CCB943DA8A

ArcGIS Engine	ArcGIS-108-E-ODT-Patch.msp	4905CE477BF02E5FD90D296A2116FD45

ArcGIS Server	ArcGIS-108-S-ODT-Patch.msp	FCFA70A5140897871617DDAD213E95F8

ArcGIS 10.7.1		Checksum (Md5)

ArcGIS Desktop Background Geoprocessing (64-bit)	ArcGIS-1071-BGDT-ODT-Patch.msp	FD0C87762EC1E9B94F33AC93CDC917BF

ArcGIS Engine Background Geoprocessing (64-bit)	ArcGIS-1071-BGE-ODT-Patch.msp	CD80141F0DF03069C1EE7D0942C07AC3

ArcGIS Desktop	ArcGIS-1071-DT-ODT-Patch.msp	29B9C2130BE83D7F7105CE1DE0527C97

ArcGIS Engine	ArcGIS-1071-E-ODT-Patch.msp	9CADBE9BEAC7559C851354285A96F81A

ArcGIS Server	ArcGIS-1071-S-ODT-Patch.msp	1855F7EC7169744949CFAB16E6DFF1AD

ArcGIS 10.7		Checksum (Md5)

ArcGIS Desktop Background Geoprocessing (64-bit)	ArcGIS-107-BGDT-ODT-Patch.msp	BA97BB28210BE166BB446DA7E09BED0E

ArcGIS Engine Background Geoprocessing (64-bit)	ArcGIS-107-BGE-ODT-Patch.msp	75E632CA00508ED6121F48BE834413A1

ArcGIS Desktop	ArcGIS-107-DT-ODT-Patch.msp	7452E876C53B888EB819803D3C51D340

ArcGIS Engine	ArcGIS-107-E-ODT-Patch.msp	05CEBF6B9F43A8028B196B86BCC6D441

ArcGIS Server	ArcGIS-107-S-ODT-Patch.msp	54031BDF7534C2349E2F0D93E1570BE1

ArcGIS 10.6.1		Checksum (Md5)

ArcGIS Desktop Background Geoprocessing (64-bit)	ArcGIS-1061-BGDT-ODT-Patch.msp	875ABEBAADA0D82EDE741AC2361D4311

ArcGIS Engine Background Geoprocessing (64-bit)	ArcGIS-1061-BGE-ODT-Patch.msp	B8F6ABABE9EFD51312ACACEFE0301540

ArcGIS Desktop	ArcGIS-1061-DT-ODT-Patch.msp	78F9C1A3257ED4D4AB6C360C6595FA98

ArcGIS Engine	ArcGIS-1061-E-ODT-Patch.msp	5932EB9CD4058EA6DC31FBCA423459A9

ArcGIS Server	ArcGIS-1061-S-ODT-Patch.msp	F3CAEE9AEF43609CACC15D0E4A611DD8

Make sure you have write access to your ArcGIS installation location.
Double-click ArcGIS-<Version>-<Product>-ODT-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>-<Product>-ODT-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.

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

ArcGIS 10.8		Checksum (Md5)

ArcGIS Server	ArcGIS-108-S-ODT-Patch-linux.tar	925ACFA1D84FA68F230BA8C6EB44C9D2

ArcGIS 10.7.1		Checksum (Md5)

ArcGIS Server	ArcGIS-1071-S-ODT-Patch-linux.tar	77E3C7E8CC26D493F57F156903EE637A

ArcGIS 10.7		Checksum (Md5)

ArcGIS Server	ArcGIS-107-S-ODT-Patch-linux.tar	FFC0A213416340D4E4453F2D45456FDA

ArcGIS 10.6.1		Checksum (Md5)

ArcGIS Server	ArcGIS-1061-S-ODT-Patch-linux.tar	9707C8DC12C6D941E6EB977CA27BC5AA

Make sure you have write access to your ArcGIS installation location, and that no one is using ArcGIS.
Extract the specified tar file by typing:

% tar -xvf ArcGIS-<Version>-S-ODT-Patch-linux.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.

Upgrade a geodatabase

When a hotfix or patch for ArcGIS has been applied, it may also be necessary to upgrade your geodatabase. See the Upgrade the Geodatabase section on the Geodatabase management page for your individual DBMS platform for more information.

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 /tmp 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.