laptop and a wrench

Bug

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

Zuletzt veröffentlicht: March 16, 2020 ArcGIS for Desktop
Bug-ID-Nummer BUG-000118138
EingereichtNovember 13, 2018
Zuletzt geändertMay 31, 2023
Gilt fürArcGIS for Desktop
Gefunden in Version10.6.1
Server-PlattformWindows OS
Client-Plattform2016 64 Bit
Version Fixed2.5.2
StatusFixed

Zusätzliche Informationen

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.

Workaround

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.

Schritte zur Reproduzierung

Bug-ID: BUG-000118138

Software:

  • ArcGIS for Desktop

Hilfe von ArcGIS-Expert*innen erhalten

Technischen Support kontaktieren

Die Esri Support-App herunterladen

Zu den Download-Optionen

Weitere Informationen zu diesem Thema erkunden

Esri Community

Nach zugehörigen Informationen suchen

Schulungen

Nach Schulungen zu diesem Thema suchen

ArcGIS Ideas

Ideen erkunden und Feedback geben