A new Technical Support website experience is coming soon!

In the next couple of months, we will update the Technical Support website. It will look different, but all the information you expect will still be at your fingertips. In fact, we’ve worked hard to ensure you can find information even more easily.

Back to results

Bug Number	BUG-000118138
Submitted	Nov 13, 2018
Modified	Mar 25, 2023
Severity	Critical
Applies To	ArcGIS for Desktop
Version Found	10.6.1
Prog Language	N/A
Server Platform	N/A
Client Platform	N/A
Database	N/A
Locale	N/A
Status	Fixed Learn more
Version Fixed	2.5.2
SP Fixed	N/A

Bug BUG-000118138

Synopsis

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

Additional Information

The error is expected when a column is created with the data type 'double', precision 10 and scale 0, and stores a value greater than 32-bit integer limit, i.e. 2,147,483,647. A column with the data type 'double' and the precision 0, maps to the Oracle data type NUMBER(10). In ArcMap 10.2.1, this column was mapped with ArcMap the data type 'double' which allowed storing values greater than 2,147,483,647. The mapping has been corrected to represent NUMBER(10) as long integers. Thus, values greater than 2,147,483,647 are no longer allowed.

Alternate Solution

The ArcGIS (Desktop, Engine, Server) Oracle Data Type Patch is now live on the support site. The URL is: https://support.esri.com/en/download/7785.