English

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

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.

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

  2. 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
         

  3. Make sure you have write access to your ArcGIS installation location.

  4. 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.

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.

  1. 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
         

  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-<Version>-S-ODT-Patch-linux.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.


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.