Bogue
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).
| Numéro d’ID de bogue | BUG-000118138 |
|---|---|
| Envoi | November 13, 2018 |
| Dernière modification | May 31, 2023 |
| S’applique à | ArcGIS for Desktop |
| Version trouvée | 10.6.1 |
| Plateforme serveur | Windows OS |
| Plateforme client | 2016 64 Bit |
| Version Fixed | 2.5.2 |
| Statut | Fixed |
Informations supplémentaires
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.Solution de contournement
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.
Étapes pour reproduire
ID de bogue: BUG-000118138
Logiciel:
- ArcGIS for Desktop
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis