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).
| Bug-ID-Nummer | BUG-000118138 |
|---|---|
| Eingereicht | November 13, 2018 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | ArcGIS for Desktop |
| Gefunden in Version | 10.6.1 |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 2016 64 Bit |
| Behoben in Version | 2.5.2 |
| Status | Fixed |
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
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen